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

RQM - Requirements Import using ExcelImporter

STEPS
1. I select "RQM -> Export To Repository" in Excel file that contains my requirements.
2. Against the field "Choose the mapping file"" , I select a .cfg file from "C:\Program Files\IBM\RQMExcelImporter\Samples" directory.
Note: This sample file was modified by me for Requirements.
3. On click of "Export" I get a confirmation message stating improt successful.

ISSUE
After import into RQM,
1. I do not see the imported requirements in the requirements list (Note: Imported Requirements are visible when I query from RTC. This implies that the requirements are getting imported but not getting displayed in RQM.
2. Only the RQM built in fileds are getting imported. Custom fields added by me in RQM are not getting imported.

Below is the content of .CFG file which Ihave modified for Requirements. Can you confirm if anything is wrong in this?

---------------------------------------
requirement.XLSStartRow=2

requirement.dc:title=D

//testscript.XLSArtifactID=B

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
requirement.title=D
requirement.req_scopeId=F
requirement.req_ReqType="Functional"
requirement.req_ReqCat=A
requirement.req_ReqSubCat=B
requirement.req_busowner="Business Analysis Team"
requirement.req_deliveredIn=C
requirement.req_Reqsource="Use Case"
requirement.req_Reqstatus="Complete"
requirement.req_ReqPriority="P4"
requirement.description=E

// a new script starts when we encounter an empty row
requirement.XLSDelimeter=\n
---------------------------------------

0 votes



2 answers

Permanent link
STEPS
1. I select "RQM -> Export To Repository" in Excel file that contains my requirements.
2. Against the field "Choose the mapping file"" , I select a .cfg file from "C:\Program Files\IBM\RQMExcelImporter\Samples" directory.
Note: This sample file was modified by me for Requirements.
3. On click of "Export" I get a confirmation message stating improt successful.

ISSUE
After import into RQM,
1. I do not see the imported requirements in the requirements list (Note: Imported Requirements are visible when I query from RTC. This implies that the requirements are getting imported but not getting displayed in RQM.
2. Only the RQM built in fileds are getting imported. Custom fields added by me in RQM are not getting imported.

Below is the content of .CFG file which Ihave modified for Requirements. Can you confirm if anything is wrong in this?

---------------------------------------
requirement.XLSStartRow=2

requirement.dc:title=D

//testscript.XLSArtifactID=B

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
requirement.title=D
requirement.req_scopeId=F
requirement.req_ReqType="Functional"
requirement.req_ReqCat=A
requirement.req_ReqSubCat=B
requirement.req_busowner="Business Analysis Team"
requirement.req_deliveredIn=C
requirement.req_Reqsource="Use Case"
requirement.req_Reqstatus="Complete"
requirement.req_ReqPriority="P4"
requirement.description=E

// a new script starts when we encounter an empty row
requirement.XLSDelimeter=\n
---------------------------------------


Part 1 resolved I believe we do see the requirements in the view ...

Part 2 - unresolved, defect in jazz recorded and confirmed to be possible REST API problem with custom fields

0 votes


Permanent link
The import worked using the batch import process. Excel Import still has not worked and that's what the problem is.
Note: I was told that the custom fields got migrated for someone using the Excel Importer, which tells me that there's something not correct with my .CFG file.

STEPS
1. I select "RQM -> Export To Repository" in Excel file that contains my requirements.
2. Against the field "Choose the mapping file"" , I select a .cfg file from "C:\Program Files\IBM\RQMExcelImporter\Samples" directory.
Note: This sample file was modified by me for Requirements.
3. On click of "Export" I get a confirmation message stating improt successful.

ISSUE
After import into RQM,
1. I do not see the imported requirements in the requirements list (Note: Imported Requirements are visible when I query from RTC. This implies that the requirements are getting imported but not getting displayed in RQM.
2. Only the RQM built in fileds are getting imported. Custom fields added by me in RQM are not getting imported.

Below is the content of .CFG file which Ihave modified for Requirements. Can you confirm if anything is wrong in this?

---------------------------------------
requirement.XLSStartRow=2

requirement.dc:title=D

//testscript.XLSArtifactID=B

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
requirement.title=D
requirement.req_scopeId=F
requirement.req_ReqType="Functional"
requirement.req_ReqCat=A
requirement.req_ReqSubCat=B
requirement.req_busowner="Business Analysis Team"
requirement.req_deliveredIn=C
requirement.req_Reqsource="Use Case"
requirement.req_Reqstatus="Complete"
requirement.req_ReqPriority="P4"
requirement.description=E

// a new script starts when we encounter an empty row
requirement.XLSDelimeter=\n
---------------------------------------


Part 1 resolved I believe we do see the requirements in the view ...

Part 2 - unresolved, defect in jazz recorded and confirmed to be possible REST API problem with custom fields

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.

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: Aug 19 '09, 1:27 p.m.

Question was seen: 6,248 times

Last updated: Aug 19 '09, 1:27 p.m.

Confirmation Cancel Confirm