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

.CSV File imports into RTC is causing the system ID to jump to several thousand IDs ahead..Any ideas as to why this happens?

Questions
Tags
Users
Badges
Aizaz Aslam
(11●1) Mar 24 '16, 2:37 p.m.

Using the import utility in RTC, I am importing a .CSV file that is mapped to the corresponding fields in CLM. This import consists of CCRs (workitems) in the file with fields we want to export over from ClearQuest. It seems like the system automatically generates an Id number so high that it is throwing everything off.  For example, the CCR import would have the headline, description, priority, etc. on the file....and once imported the system does not use the sequential numbering it has established  i.e 1115..................it jumps to 7000 or something. I can't seem to figure out why it is doing this. So, when we are back to creating new CCRs....it takes the new series of numbers and goes sequentially from there! Feeling stumped over here...any guidance would be greatly appreciated.

0 votes

1 answer
5,227 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.6k●3●36●49) Mar 24 '16, 3:22 p.m.
If the ID is provided the system tries to update (if the option is checked) for an import don't use update or if you want to import and update, be careful which ID's you import-

0 votes

Comments
Aizaz Aslam
Mar 24 '16, 3:25 p.m.
thank you for the response. I am sending over data without the Id field and the system automatically generates the number? all the way up? Is there a way to change IDs in RTC without disrupting anything?

Alan Sampson
JAZZ DEVELOPER Mar 24 '16, 8:16 p.m.
Work item ID numbers within RTC are unique and are generated by an internal number generator. They are usually sequential and new ones are assigned starting at {current newest work item ID in the repository}+1.  The process of assigning a work item ID number is automatic and there's no way to change it that I'm aware of.

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 29 '16, 2:32 a.m.
If you import and include the ID and tell the system to upgrade, I think you can force an ID. I think I have done that in the past. I can't be sure though.

Alan Sampson
JAZZ DEVELOPER Mar 29 '16, 1:55 p.m.
Just tried importing with "Update" from .CSV into RTC 6.0.1. The import ignored the ID I provided in the .CSV and instead added a work item with the incremented unique ID.

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

Question asked: Mar 24 '16, 2:37 p.m.

Question was seen: 5,227 times

Last updated: Mar 29 '16, 1:55 p.m.

Confirmation Cancel Confirm