How to import workitems from html in RTC?
There is an option to export the work items from RTC Eclipse client and can be saved either in csv or html format.
However, if I need to import these in a different project area there is only 'import from csv' option.
What will be the steps to take, if I need to import from html?
Should I convert the html to csv first and then import?
If so, what is the use case of providing the option to export and save in html format?
Accepted answer
One other answer
Exporting to HTML is to put the information up on a web page.
Exporting to csv is for subsequent importing.
So if you want to subsequently import, you would export to csv format, not to HTML format.
If your work item data for some reason is in html format, and you cannot "re-export" it into csv format, you would have to write a script to convert it to csv format in order to import the data into RTC.
Exporting to csv is for subsequent importing.
So if you want to subsequently import, you would export to csv format, not to HTML format.
If your work item data for some reason is in html format, and you cannot "re-export" it into csv format, you would have to write a script to convert it to csv format in order to import the data into RTC.
Comments
Geoff
--> Work item data is xml in this case and the attribute type is 'Large String'.
With this, when you export WI either as html or csv, the data is not exported. Only the attribute is.
Do you have any recommendations in this case on what can be done to export and import the WI's to a different repository?
a. We cannot update the type to wiki or Large Html (with which the data gets exported for the attribute), if that is an option.
Thank you
You'll probably want to post a separate question for that, something like "How do I export/import a work item attribute whose type is "Large String".