Discussions  >  CollabNet TeamForge APIs  >  RE: .NET API code samples

Back to topic list

RE: .NET API code samples

Author nhartani
Full name Nassim Hartani
Date 2012-03-16 09:57:46 PDT
Message Nice, i will take a look at the favourite pane but we need to have the data into a specific workbook with macros and formulas to calculate the indicators.

Your code exemples helped me a lot and I could create a button for Excel wich automatically grab my tracker artifacts into my spreadsheet.

That's work fine with GetArtifactList Method but when I use the GetArtifactDetailList (wich I suppose is faster ?) I have only the title and priority columns on my sheet.

Here is the piece of code I used :

string[] columns = new string[4]{ "COLUMN_STATUS", "COLUMN_TITLE", "COLUMN_FLEX_FIELDS" };

IArtifactDetailListCollection artifacts = TrackerService.GetAr​tifactDetailList(tra​ckerId, filters, columns);

i = 0;
foreach (IArtifactDetailRow artifact in artifacts)
            {
                ((Excel.Range)range.Cells[2 + i, 1]).Value2 = artifact.Title;
                ((Excel.Range)range.Cells[2 + i, 2]).Value2 = artifact.Priority;
                ((Excel.Range)range.Cells[2 + i, 3]).Value2 = artifact.Status;
                ((Excel.Range)range.Cells[2 + i, 4]).Value2 = artifact.Category;
                ((Excel.Range)range.Cells[2 + i, 5]).Value2 = artifact.FlexFields["Date de création"];
                ((Excel.Range)range.Cells[2 + i, 6]).Value2 = artifact.FlexFields[​"Demandeur"];
                i++;
            }

Thats work when I invoke GetArtifactDetailList with null parameter for columns but it take a very long time to load :

IArtifactDetailListCollection artifacts = TrackerService.GetAr​tifactDetailList(tra​ckerId, filters, null);

Any hint for the columns name constants to be used as parameters ?

« Previous message in topic | 9 of 13 | Next message in topic »

Messages

Show all messages in topic

Subject
Author
Full name
Date posted
+
.NET API code samples nhartani Nassim Hartani 2012-03-15 10:14:32 PDT
     RE: .NET API code samples baybora Baybora Aksoy 2012-03-15 10:44:04 PDT
     RE: .NET API code samples kevin_cn Kevin Hancock 2012-03-15 10:52:58 PDT
         RE: .NET API code samples nhartani Nassim Hartani 2012-03-16 03:16:23 PDT
             Re: .NET API code samples markphip Mark Phippard 2012-03-16 04:14:56 PDT
                 RE: Re: .NET API code samples nhartani Nassim Hartani 2012-03-16 06:25:21 PDT
                     RE: Re: .NET API code samples baybora Baybora Aksoy 2012-03-16 06:52:58 PDT
             RE: .NET API code samples baybora Baybora Aksoy 2012-03-16 07:13:41 PDT
                 RE: .NET API code samples nhartani Nassim Hartani 2012-03-16 09:57:46 PDT
                     RE: .NET API code samples baybora Baybora Aksoy 2012-03-16 11:29:10 PDT
                         RE: .NET API code samples nhartani Nassim Hartani 2012-03-19 02:48:01 PDT
                             RE: .NET API code samples baybora Baybora Aksoy 2012-03-19 06:27:44 PDT
                                 RE: .NET API code samples nhartani Nassim Hartani 2012-03-19 08:27:21 PDT
Messages per page: