Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Export/Import of Work Items - How to retain IDs?

Questions
Tags
Users
Badges
T M
(887●8●188●143) Sep 04 '12, 8:46 a.m.

Is there a way to export the work items from one RTC repository and import them to the new RTC repository and still retain the ID’s?

Thanks!

0 votes

Comments
sam detweiler
Sep 04 '12, 9:28 a.m.

no.. IDs are NOT importable.. they are a generated value. (thus why moving data is so complicated)

6 answers
5,233 views
0 votes

6 answers

Permanent link
Kevin Ramer
(4.5k●9●186●201) Sep 04 '12, 9:14 a.m.
I wouldn't think so as the IDs start @ 1 and increase for each new work item created in the repository.  I'd also wager the ID are immutable property in the back-end database, or at least a database generated value is stored. You're bound to hit clashes of ID quicker than you'd guess.

Kevin

0 votes

Permanent link
T M
(887●8●188●143) Sep 04 '12, 9:52 a.m.
Can't we have a custom id field like in ClearQuest and increment the number on creation?

0 votes

Comments
sam detweiler
Sep 05 '12, 7:37 a.m.

sure.. you can put anything in a custom field.. but the workitem base NUMBER will change..

retained to me is keep the workitem ID the same.. that cannot be done

Permanent link
T M
(887●8●188●143) Sep 05 '12, 5:10 a.m.
With some UUID manipulation can we retain the IDs? Just a thought!

0 votes

Comments
Kevin Ramer
Sep 05 '12, 5:13 a.m.

I think your question has been answered. Anything else would be conjecture.

Permanent link
T M
(887●8●188●143) edited
Sep 05 '12, 8:12 a.m.

Workaround (for the benefit of others):

I had WIs with IDs from 124 to 925 on RTC server A. I had to move all the WIs to RTC server B with the same ID numbers. I created dummy WIs on RTC server B using dummy CSV file (dummy rows) with IDs from 1 to 925. Then I updated the WIs with the actual CSV file that I exported from RTC server A. So all of my WIs got updated and the dummy WIs (1 to 123) were moved to a different project and I will delete those WIs one a day :)

0 votes

Permanent link
sam detweiler
(12.5k●6●195●201) Sep 05 '12, 10:14 a.m.
interesting but only works ONCE if the server is new..

my servers are at workitems 117580 and 43865

adding adds to the end..

0 votes

Permanent link
T M
(887●8●188●143) Sep 06 '12, 6:20 a.m.
Is there a way to get "History" info when RTC WIs are exported/imported?

0 votes

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,131

Question asked: Sep 04 '12, 8:46 a.m.

Question was seen: 5,233 times

Last updated: Sep 06 '12, 6:20 a.m.

Confirmation Cancel Confirm