It's all about the answers!

Ask a question

Uploading into RTC using CSV

Susan Helders (812) | asked Nov 04 '14, 5:14 a.m.
I have been investigating a way to upload tasks into RTC without the need to use the Eclipse client and have not been successful. Is anyone aware of a potential solution? If not, would a solution be provided in a later release of RTC. Thanks

Accepted answer

permanent link
Ralph Schoon (63.3k33646) | answered Nov 04 '14, 5:25 a.m.
edited Nov 04 '14, 5:25 a.m.
Susan, I am not aware of a solution for CSV file import in the Web UI. I only know the Eclipse client based solution. This can also work with the mapping files required to map attributes and their values. The only way to import work items in the Web UI is based on the MS Project XML. I believe that this does not cover all attributes.

It is possible to use the API to do this, however, it would not be a trivial task to attempt that.

What is the reason behind not using the Eclipse client? Typically this would be only used at the beginning of a project. Once work items are in the tool you should work with them. Trying to perform round trip scenarios with exporting, importing, exporting is usually a very brittle and error prone approach.

I think it would be desirable to have a way of exporting and importing work item data, probably not CSV file based, because CSV is a bad format to be used with multi-line text and the like. This would be most useful for migration purposes.

I would suggest to create an enhancement request.
Susan Helders selected this answer as the correct answer

Susan Helders commented Nov 04 '14, 5:36 a.m.

Thanks for the info. I have raised an enhancement request as suggested.

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.