It's all about the answers!

Ask a question

RQMImporter - Artifacts not shown in Project Area af


Kunhong Xu (115) | asked Nov 22 '16, 11:02 a.m.

I am new to RQM. I work for GM tools and process group to pilot RQM in Doors user acceptance validation area.

I have imported an excel file successfully which has 17 test cases/test scripts and one test plan. But none of the artifacts can be seen in project Area.

============cfg file==========================

// this configuration file will create a testplan and testase objects and link them
testplan.XLSWorksheetID="Function"
testplan.dc:title=B1
testplan.XLSLink=testcase

// This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data

// Start looking for scripts at row 11
testscript.XLSWorksheetID="Function"
testscript.XLSStartRow=11

// use the data in the first row of a found script's column D- Purpose
testscript.dc:title=A
testscript.dc:description=B

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.description=G
testscript.steps.expectedResult=H
testscript.steps.comment=I

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
 
// we want to use the data we got for each test script to create a test case
testcase.XLSWorksheetID="Function"
testcase.XLSStartRow=11

// by referring to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

============end of cfg file==========================

image of excel file is attached

fail to attaché image.

==========content of Mso2RQM_Debug.log file.

11/22/2016 9:05:16 AM:
SESSION: 11/22/2016 9:05:16 AM


11/22/2016 9:05:16 AM: INFO: <Unknown Caller Context>: RQMExporter created!


11/22/2016 9:05:16 AM: INFO: <Unknown Caller Context>: RQMExporter Startup!


11/22/2016 9:05:16 AM: INFO: <Unknown Caller Context>: Mso2Rqm: Mso2Rqm instantiated


11/22/2016 9:05:16 AM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


11/22/2016 9:05:16 AM: INFO: <Unknown Caller Context>: caption : RQM


11/22/2016 9:05:16 AM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Created commands


11/22/2016 9:06:00 AM:
--------------------------------------------------------------------------------

11/22/2016 9:06:00 AM:
SESSION: 11/22/2016 9:06:00 AM


11/22/2016 9:06:00 AM: Getting artifacts from current document NEW - CG3978 GIS-501 Info 3.0 Home Screen - Standard Home Screen View.xlsx.xls

11/22/2016 9:06:01 AM: Created 17 artifacts, writing to files

11/22/2016 9:06:01 AM: Writing testscript 0 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_5.xml

11/22/2016 9:06:01 AM: Writing testscript 1 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_4.xml

11/22/2016 9:06:01 AM: Writing testscript 2 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_6.xml

11/22/2016 9:06:01 AM: Writing testscript 3 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_8.xml

11/22/2016 9:06:01 AM: Writing testscript 4 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_7.xml

11/22/2016 9:06:01 AM: Writing testscript 5 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_1.xml

11/22/2016 9:06:01 AM: Writing testscript 6 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_3.xml

11/22/2016 9:06:01 AM: Writing testscript 7 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_2.xml

11/22/2016 9:06:01 AM: Writing testcase 8 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_1.xml

11/22/2016 9:06:01 AM: Writing testcase 9 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_7.xml

11/22/2016 9:06:01 AM: Writing testcase 10 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_8.xml

11/22/2016 9:06:01 AM: Writing testcase 11 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_6.xml

11/22/2016 9:06:01 AM: Writing testcase 12 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_2.xml

11/22/2016 9:06:01 AM: Writing testcase 13 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_4.xml

11/22/2016 9:06:01 AM: Writing testcase 14 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_3.xml

11/22/2016 9:06:01 AM: Writing testcase 15 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_5.xml

11/22/2016 9:06:01 AM: Writing testplan 16 named NEW_-_CG3978_GIS-501_Info_3.0_Home_Screen_-_Standard_Home_Screen_View_Function_1.xml

11/22/2016 9:06:01 AM: finished writing artifacts

11/22/2016 9:06:01 AM: INFO: <Unknown Caller Context>: Exporting complete successfully!


11/22/2016 10:07:26 AM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


11/22/2016 10:07:26 AM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


11/22/2016 10:07:26 AM: INFO: <Unknown Caller Context>: Mso2Rqm Shutdown!

=============end of debug_log.txt=========================

My project URL is:

https://rqm-qm-dev-n2.gm.com:9443/qm/web

Note- My co-worker was able to use the same excel file and cfg file to import to a different project area.

Please identify what's the issue.

Thanks!


Comments
Kunhong Xu commented Nov 22 '16, 11:05 a.m.

Work environment - Microsoft Office 2013, .Net V4.0, Win7 enterprise, RQM 6.0.2 web client.

One answer



permanent link
Kunhong Xu (115) | answered Nov 22 '16, 2:13 p.m.
Issue has been resolved - I was working on a branched stream and imported test scripts are imported to its initial stream which is not visible to its branched stream.

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.