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

RQM Test cases Excel Export not working

Dears,

I am trying to do excel export of test case to RQM using cfg file. I am trying to export around 280 test cases but it created only 9 out of it and showing sending test cases 587 in log out of it around 18 with  Server returned code Created and rest  Server returned code OK.

And the custom attributes are also not able to import though the format is correct in cfg file, please refer the below lines.

testcase.customAttributes identifier="SR/PR Number".name="SR/PR Number".type="Text(Small)".value=W
testcase.customAttributes identifier="Req Id".name="Req Id".type="Text(Small)".value=C
Thank you...!

Could you please help out on this issue urgently...since we are going Live with application.


Thank You....!

0 votes



One answer

Permanent link
What version of RQM and RQMExcelImporter do you use?
Without the cfg file and xls file, it is very hard to know what is wrong if the log does not show any errors.
Are you able to provide the cfg/xls files so that a test can be done by the community?

There are two things you can check:
1) whether only big number of testcases when you try to export would it cause the unexpected result, for example, if you try 30 testcases(because you only got 9 imported), does it work or not?
2) create a new testing project area, then use the sample: TestCases 001 with custom attributes.xls and TestCases 001 with custom attributes.cfg to export to it and see if it works or not.
By default, this sample will only create 5 testcases, you can copy the rows in the same xls file to make up the number to 50, 100, 200 and so on and see if the export will work or it may break in some stage or not.
This will give an indication if something is related to your xls/cfg or not.

Regarding custom attributes, even though the GUI may show the type as Text(Small), cfg file should use SMALL_STRING instead, so replace your type with SMALL_STRING should work.

0 votes

Comments

Also the identifier should not have spaces. Replace space with underscore char '_'  similar to below

testcase.customAttributes identifier="Req_Id".name="Req Id".type="SMALL_STRING".value=C

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
× 12,014

Question asked: May 06 '15, 11:16 a.m.

Question was seen: 2,709 times

Last updated: May 07 '15, 12:58 a.m.

Confirmation Cancel Confirm