How to upgrade existing workitems from CSV file?
Hello,
My case is following: I have external database which I would like to synchronize with RTC. The database has a key which can be used as primary key. I decided that the easiest way will be simply exporting database to csv and then importing to RTC. Anyway I would like to periodically import work items. My issue is that I would like to avoiding the same work item twice. What are the options I should set? Here is the header of my csv file: Type";"Name";"Id" "Customer";"Krzysztof Kazmierczyk";"9492" where 9492 is any unique key from RTC. But when I try updating workitem I got following error: The CSV file is missing a proper identifier attribute "Id". The desired work item cannot be retrieved. How can I make it working? |
Accepted answer
2 other answers
Millard Ellingsworth (2.5k●1●24●31)
| answered Sep 24 '13, 7:55 p.m.
FORUM ADMINISTRATOR / JAZZ DEVELOPER
A couple questions:
1. Did you copy the header in correctly? Should the first line begin with a "?
2. When importing, did you set the separator as a semi-colon rather than a comma -- the data displayed above is not comma separated.
According to this article, it should work fine if all is configured properly. I did a quick export from the Web UI that looks like this -- it defaulted to tab-separated (truncated for clarity):
"Type" "Id" "Status" "Priority" "Severity" "Summary"
I changed the Task entry to:
"Task" "104" "New" "High" "Normal" "Define a better build"
and it imported fine. So I'd check your separators and the quoting in your header.
|
Hey Krzys,
as per CSV Import / Export reference article - https://jazz.net/library/article/69
To update existing Work Items, add a column named 'Id' with the respective Id of the Work Item to update
So assume this should work - possibly, the id column must be the first one in the CSV file.
Eric.
|
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.