Does anyone have a configuration file that imports all 3 artifacts, Test Plan, Test Cases, & Test Scripts and links them all together? I have read that it is not possible but then I am told it is possible without a sample solution.

As discussed in thread https://jazz.net/forums/viewtopic.php?p=57773, you can combine the samples (see https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration) to arrive at this solution:

Configuration:
testplan.XLSStartRow=1
testplan.dc:title=A
testplan.XLSLink=testcase

testcase.XLSStartRow=1
testcase.dc:title=B
testcase.XLSLink=testscript

testscript.XLSStartRow=1
testscript.dc:title=C

Excel:
A B C
1 testplan1 testcase1 testscript1

I would suggest:

1) Reviewing the RQM Excel/Word Importer WIKI (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter).

2) Reviewing the RQM Excel/Word Importer samples (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Document_Configuration).

3) Using the RQM Excel/Word Importer 3.0.1 (https://jazz.net/downloads/rational-quality-manager/releases/3.0.1?p=allDownloads).

As I stated previously, I did already combine both config files and it did not link all 3 artifacts. However, you mentioned something new, using RQM Excel/Word Importer 3.0.1. Does solution only work in this version? I'm not using RQM Excel/Word Importer 3.0.1 and now wonder if that has been the problem all along.

Hi,

I use the RQM Excel Import Utility 2.0.0.1 and have a cfg file that works & pulls in all 3 artifacts. We use each tab as a separate case / script for updating purpose. In the event the script becomes longer we don't have to do any maneuvering of other scripts within the excel template. The only downside is the Test Plan will import in multiple instance, as rqm reads the plan as a different one per sheet, but test plan creation and linking is not that time consuming.

I want to use RQMExcelImporter to input daily test results for the same test cases every day. The spreadsheet is one test case per line, with test case id, test case name, test result, pass point, fail point, defect and so on. Each day we create a new copy of this spreadsheet and fill the test results.

The cfg I use is:
executionworkitem.XLSWorksheetID="Deployment"
executionresult.XLSWorksheetID="Deployment"
executionworkitem.XLSStartRow=5
executionresult.XLSStartRow=5

executionworkitem.dc:title=A
executionworkitem.dc:description=C
executionworkitem.weight=J
executionworkitem.XLSArtifactID=A

executionresult.dc:title=executionworkitem.dc:title
executionresult.XLSArtifactID=A & "201105311618"
executionresult.alm:state=K
executionresult.alm:owner=F1

executionresult.er:starttime=F2
//executionresult.er:iterations=
executionresult.er:endtime=F2
executionresult.er:details=O
//executionresult.er:buildid=H1
executionresult.er:pointspassed=L
executionresult.er:pointsfailed=M

The executionresult's XLSArtifactID is correct with string '201105311618' append after executionworkitem's ID when I test with "Export to File". But the filename of this resource is still without the appending string. So when I run with "Export to Repository" successfully, and then check with http://<rqmhost>:9444/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager/executionresults/, I found the title and resource id are all the same with the executionworkitem.

This blocked me in input multiple test results with the same TER.
Can some one tell me how to implement this by ExcelImport?

See the note on XLSArtifactID @ https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#XLSArtifactID.