It's all about the answers!

Ask a question

importing CSV files (requirements) into sandbox2


John Schilt (6111822) | asked Mar 24 '13, 11:39 p.m.
retagged Mar 30 '13, 10:56 a.m. by Douglas Bush (28125)
Hi,

I've seen a number of references to importing a requirements CSV file into a sandbox2 project - but no one seems to have been able to do this successfully.  Can we please have a definite answer ?

Question : Are we able to import a CSV file into a Sandbox project with a bunch of requirements in it ? 

Assuming that we have the :

- right column headings (ie, Type,Primary Text,Title,Description)
- file encoded with UTF8

Sample file :

Type,Primary Text,Title,Description
Requirement,"This is the primary text of my first requirement","CSV Test 1","This requirement was imported from a CSV file"
Requirement,"This is the primary text of my second requirement","CSV Test 2","This requirement was imported from a CSV file"
Requirement,"This is the primary text of my third requirement","CSV Test 3","This requirement was imported from a CSV file"

Thanks

John




Comments
Douglas Bush commented Mar 30 '13, 10:58 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

Glad to see that Christian answered your question.
FYI only... more on CSV format in the online help information center here:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m2/index.jsp?topic=%2Fcom.ibm.rational.rrm.help.doc%2Ftopics%2Fr_csv_format.html

Accepted answer


permanent link
Christian Glockner (16613) | answered Mar 25 '13, 6:51 a.m.
Hi John,

Somewhere along the way between version 3 and version 4 a change was made to the import format. The column "Type" now needs to be called "Artifact Type" for the import to succeed.

So change the first line accordingly and see if that helps.

-Christian
Technical Support Engineer
Rational Client Support Europe
John Schilt selected this answer as the correct answer

Comments
John Schilt commented Mar 25 '13, 7:13 p.m.

Thanks - this worked .

Your answer


Register or to post your answer.