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

Error while Importing artifacts from CSV file

Questions
Tags
Users
Badges
Chandan Jha
(9●1●11●14) Sep 06 '12, 2:39 a.m.

Hi,

   I am  using  RQM 4.0  version of CLM 4.0.  When I start importing  from CSV  file it gives  me the following error:- The comma-separated values (CSV) file was not imported.

ID CRRRW7570E  The comma-separated values (CSV) file was not imported.

Error 400: Bad RequestError 400: Bad Request"CRRRS4211E Required column is missing: Name, server can not proceed with the import operation." (More info found at entry [851b6570a215b791] in RRS server log)Requirements Management/4.0
The Rational help  says  - Refresh the browser and try again. But still  it  happens.  Please  tell  me how to resolve this  error  and  import artifacts from the CSV  file.   Which  required  column is missing ?
Thanks-
Chandan

0 votes

4 answers
5,627 views
0 votes

4 answers

Permanent link
Rajat Singh
(598●3●35●45) edited
Sep 06 '12, 3:09 a.m.
RQM V4 csv import, now uses the UI name for the csv column headings. Is the name in the UI the same as the csv column name?

1 vote

Comments
Chandan Jha
Sep 06 '12, 5:40 a.m.

Still getting the error - Required column is missing: Artifact Type, server can not proceed with the import operation.

This is how i used my CSV file according to the Artifacts UI of RQM V4:--

"Artifact Type", Primary Text, Name Requirement,"CSV Primary Text","CVS Req. Title"

Can you share if the above CSV file has something wrong.

Permanent link
Rajat Singh
(598●3●35●45) Sep 06 '12, 6:01 a.m.
You might have to use "Artifact Type" instead of "Type" and "Name" instead of "Title"

0 votes

Comments
Chandan Jha
Sep 06 '12, 6:12 a.m.

Thanks Rajat for helping. I tried in the Mozilla with the same as you suggested.

"Artifact Type", Primary Text, Name

Requirement,"CSV Primary Text","CVS Req. Name".
In RQM can we get any sample CSV file to try this ?

Permanent link
Hao Wan
JAZZ DEVELOPER (1.5k●3●5) Sep 10 '12, 2:10 a.m.
Hi Chandan,
you can refer to the link
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/index.jsp?topic=%2Fcom.ibm.rational.test.qm.doc%2Ftopics%2Ft_create_datapools.html
to work with test data.

0 votes

Permanent link
Hao Wan
JAZZ DEVELOPER (1.5k●3●5) Sep 10 '12, 2:14 a.m.
this one is for requirement.
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/index.jsp?topic=%2Fcom.ibm.rational.rrm.help.doc%2Ftopics%2Fr_csv_format.html

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

Question asked: Sep 06 '12, 2:39 a.m.

Question was seen: 5,627 times

Last updated: Sep 10 '12, 2:14 a.m.

Confirmation Cancel Confirm