It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,958

question asked: Aug 19 '09, 1:27 p.m.
question was seen: 6,144 times
last updated: Aug 19 '09, 1:27 p.m.

Related questions

RQM - Requirements Import using ExcelImporter

0
Sanal Menon (61●16●12) | asked Aug 19 '09, 1:27 p.m.
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
---------------------------------------

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Karen Steele (1.2k●4●139●148) | answered Aug 20 '09, 10:40 a.m.
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
permanent link
Sanal Menon (61●16●12) | answered Aug 20 '09, 11:05 a.m.
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

Your answer

Register or 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.