It's all about the answers!

Ask a question

RTC Data Export not exporting id's or workitem links to csv.


Karthick Veeramani (12211) | asked Mar 03 '16, 8:26 a.m.
 RTC Data Export not exporting id's or workitem links to csv.   RTC exporting links and ids without any links and porefix is "#"<id> or "#<linked workitem>". Can you explain me why ?

Comments
sam detweiler commented Mar 03 '16, 10:11 a.m.

on the export there is a column selection table.. make sure those columns are selected. (should be by default..)

3 answers



permanent link
Arun K Sriramaiah (3.2k13477) | answered Mar 03 '16, 9:51 a.m.
Hi Karthik,

It could be problem with the query or data is not available for the filter you selected in query.

1) Please make sure you run the query and check its retrieving the data which is used for exporting workitem and correct filter before use it.

2) Check the respective columns are selected in the query and export output, If its missing add the column 9 eg: id).

Regards,
Arun.



permanent link
Karthick Veeramani (12211) | answered Mar 04 '16, 6:57 a.m.
 HI ,

Thank you for the update .

  
--> select "download as CSV"  --> Here i am unable to select any records.


My out put in excel follows --> #id, summary #<workitem number> , description 

Kinldy suggest me how to fix it .




permanent link
Karthick Veeramani (12211) | answered Mar 04 '16, 7:04 a.m.
 One of our attribute type is " workitem list " .How do display thsi in csv with out "#".



Comments
sam detweiler commented Mar 04 '16, 7:42 a.m. | edited Mar 04 '16, 7:43 a.m.

 I don't think you can do that. the number is the link to the other item in the spreadhseet.

this is the column selection panel, right after you push Next the first time.

note that you can try different data types in the dropdown next to each column


Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.