Importing data into RQM from Excel

Hi @ranparam,
step1.1.1 can be description of testscript which depends on the config file. this is just a description to suggest to separate artifact with a new line, and if you want to reference, I suggest to use self reference
testcase.dc:description=testscript.dc:description

Hello,

As per the wiki the latest changes in import for RQM v4.0 RC1 shows the order as shown below:

1. title
1.1 testcase1 title
1.1.1 testscript1 reference to the testcase1
1.1.1.1 testscript1 step1 title
1.1.1.1.1 testscript1 step1 description
1.1.1.1.2 testscript1 step1 expectresuit

can you please let me know what step 1.1.1 means. what kind of reference am i supposed to create?

I was able to import the data but each test script was getting associated to all the test cases that are presented in the same spreadsheet. Can anyone please guide me?

@wanhaobj , Thanks of the reply .

Got the intent of section 1.1.1 from the above post. Now the question is i need to link a test plan,test case and test scripts, the data for all three being picked up from the same spreadsheet.

Can you please suggest the possible way in which the config file has to be created if i have to import multiple test cases and multiple test script with the data residing in a single spreadsheet.

The config file link that you have mentioned above "testcase.dc:description=testscript.dc:description" also populates the same description for the records. Any other suggestions that works out wherein field values are not similar?

The wiki only shows linking of testcase to a single test script, how can i link multiple test scripts in a single test case considering the below hierarchy

1. title
1.1 testcase1 title
1.1.1 testscript1 reference to the testcase1
1.1.1.1 testscript1 step1 title
1.1.1.1.1 testscript1 step1 description
1.1.1.1.2 testscript1 step1 expectresuit
1.1.1.2 testscript1 step2 title
1.1.1.2.1 testscript1 step2 description
1.1.1.2.2 testscript1 step2 expectresuit
1.1.1.3 testscript1 step3 title
1.1.1.3.1 testscript1 step3 description
1.1.1.3.2 testscript1 step3 expectresuit
1.1.1.4 testscript1 step4 title
1.1.1.4.1 testscript1 step4 description
1.1.1.4.2 testscript1 step4 expectresuit
\n <- this new line is expected to separated the testcase.

1.2 testcase2 title
1.2.1 testscript2 reference to the testcase2
1.2.1.1 testscript2 step1 title
1.2.1.1.1 testscript2 step1 description

@ranparam,
if you want to link a testcase with multi testscripts, I think XLSLink and Link() and meet your requirement.
see detail in
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter

and by the way, you can also refer to the samples in the installation folder RQMExcelImporter\Samples.

@wanhaobj , Thanks of the reply .

Got the intent of section 1.1.1 from the above post. Now the question is i need to link a test plan,test case and test scripts, the data for all three being picked up from the same spreadsheet.

Can you please suggest the possible way in which the config file has to be created if i have to import multiple test cases and multiple test script with the data residing in a single spreadsheet.

The config file link that you have mentioned above "testcase.dc:description=testscript.dc:description" also populates the same description for the records. Any other suggestions that works out wherein field values are not similar?

The wiki only shows linking of testcase to a single test script, how can i link multiple test scripts in a single test case considering the below hierarchy

1. title
1.1 testcase1 title
1.1.1 testscript1 reference to the testcase1
1.1.1.1 testscript1 step1 title
1.1.1.1.1 testscript1 step1 description
1.1.1.1.2 testscript1 step1 expectresuit
1.1.1.2 testscript1 step2 title
1.1.1.2.1 testscript1 step2 description
1.1.1.2.2 testscript1 step2 expectresuit
1.1.1.3 testscript1 step3 title
1.1.1.3.1 testscript1 step3 description
1.1.1.3.2 testscript1 step3 expectresuit
1.1.1.4 testscript1 step4 title
1.1.1.4.1 testscript1 step4 description
1.1.1.4.2 testscript1 step4 expectresuit
\n <- this new line is expected to separated the testcase.

1.2 testcase2 title
1.2.1 testscript2 reference to the testcase2
1.2.1.1 testscript2 step1 title
1.2.1.1.1 testscript2 step1 description

Hi,

I am using RQM Importer utility to export test cases from Excel to RQM.

I have done that successfully few days back.

Now when I try to export, the login is successful it says credentials validated

But it is failing to list the projects.

What can be the solution ?

Thanks,
_shashank