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....!
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....!
One answer
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.
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.
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
Refer wiki page for more information
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter