how to preserve workitem external id when importing from CSV?
It was discussed in https://jazz.net/forum/questions/128225/how-to-upgrade-existing-workitems-from-csv-file but I have decided to create new one.
I have RTC 4.0.3. 1. I have following CSV file: "Type";"Id";"Status";"Priority";"Severity";"Summary";"Owned By";"Created By" "Task";"1000000";"New";"Unassigned";"Normal";"Define permissions";"admin";"admin" Id - is identifier from external system I use import from CSV option. After import there is created new work item number 98 (I leave Id value as 1000000) 2. I modify only summary field in CSV file 3. Use import from CSV option to import work item. Select "Update Matched Work items" option. What is => New work item number 99 is created What I would like to have => summary of work item number 98 is modified. How can I acheive that? How should I modify my CSV file/importing options to achieve what I want to? |
One answer
Hello Krzysztof,
have you tried in step "2" modifying the "Id" field as well? In your example to make it match the 98 of the previously created item. That would be the way to uniquely identify the work item you are willing to update. Regards, Jorge. Comments
Krzysztof Kaźmierczyk
commented Oct 11 '13, 3:56 a.m.
hi Jorge,
Hi Krzysztof,
sam detweiler
commented Mar 04 '14, 11:42 a.m.
right..to update, there must be a column labeled ID and the value of the rows in that column MUST be existing workitem numbers.
I just did this for one of our imports.. we missed a field on import, but had saved the original system ID in a separate field.
so, on the old system we exported ID and new data
and on the new system we exported ID, and Old ID,
then used Excel to merge those two sheets together.
we deleted the Old ID and old sheet ID field columns after the merge. leaving only
ID and New Data
then the importer was told to update, not create
worked perfectly.
|
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.
Comments
Hello !
No.. the only matching done for Update import is on the ID column, where the data must match existing RTC workitem IDs (unless u specify create if not found)