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
Verified using RTC 4.0.4 - modified summary on CSV Import
1 - export as CSV
2 - edit CSV file and modify some summaries - save
3 - CSV import
--> summaries are modified as expected
CSV content (tab separated):
"Type" "Id" "Status" "Priority" "Severity" "Summary" "Owned By" "Created By"
"Task" "90" "New" "Unassigned" "Normal" "modified on CSV import" "Eric JODET" "Eric JODET"
"Task" "91" "New" "Unassigned" "Normal" "modified on CSV import" "Eric JODET" "Eric JODET"
"Task" "92" "New" "Unassigned" "Normal" "modified on CSV import" "Eric JODET" "Eric JODET"
"Task" "93" "New" "Unassigned" "Normal" "Define categories and releases for work items" "Eric JODET" "Eric JODET"
"Task" "94" "New" "Unassigned" "Normal" "Define team members" "Eric JODET" "Eric JODET"
"Task" "95" "New" "Unassigned" "Normal" "Define permissions" "Eric JODET" "Eric JODET"
Krzysztof Kaźmierczyk selected this answer as the correct answer
Comments
Krzysztof Kaźmierczyk
commented Sep 25 '13, 5:18 a.m.
Hi Eric and Millard,
1
yes.
If external ID is different from [internal] RTC ID,
then you should use a mapping file to do ID mapping.
Eric
|
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.