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

RRC 4.0.6 Importing .csv requirements, change delimiter character

Questions
Tags
Users
Badges
Rogério Moreira
(7●3●8) Sep 23 '14, 12:12 p.m.
Hello,
To importing requirements via .csv files, RRC seems to be only capable of importing .csv that uses comma ( , ) as a delimiter? but do to a combination of regional settings and excel, everyone exports their .csv files from excel with semi-colon ( ; ) as delimiter. Therefore unable to import to RRC. 
Can i change from server side the delimiter used on the import?

Many thanks :)

I've already checked, no help :(  http://www-01.ibm.com/support/knowledgecenter/api/content/SSWMEQ_4.0.6/com.ibm.rational.rrm.help.doc/topics/r_csv_format.html 

0 votes

1 answer
3,498 views
0 votes

Accepted answer

Permanent link
Benjamin Silverman
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (4.1k●6●10) Sep 23 '14, 4:46 p.m.
There is currently no support for delimiters other than a comma.  The help topic on CSV import points to RFC4180 on how the feature was implemented.  The RFC4180 article indicates there is no formal specification for a CSV file and goes on to say the article was written based on the common implementation.  But I don't think it's unreasonable to request support for other delimiters.  I'd suggest logging an enhancement to be considered for a future release.  I didn't see any existing ones out there.  Hope it helps,
Rogério Moreira selected this answer as the correct answer

1 vote

Comments
Rogério Moreira
Sep 24 '14, 5:55 a.m.

Thank you, I will open an RFE. For non technical users that try to import their requirements this restriction is causing some problems, at least for the Portuguese systems the " ; " is set as default delimiter and I can guess that Brazil and Latin countries also use the same.

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,124
× 173

Question asked: Sep 23 '14, 12:12 p.m.

Question was seen: 3,498 times

Last updated: Sep 24 '14, 5:55 a.m.

Confirmation Cancel Confirm