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?
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.
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
hi Jorge,
This is what I exactly would like to avoid. Is there any way to do that without looking into RTC what is RTC new Id?
Hi Krzysztof,
not as far as I know. If you don't specify the ID of matching item I don't see how the work item would be uniquely identified.
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.
Comments
Joerg Ihle
Mar 04 '14, 11:52 a.m.Hello !
sam detweiler
Mar 04 '14, 11:44 a.m.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)