Test script import from Excel
Hi. I have:
A B C
Step # Step Type Step Description
Step Type is either "execution" or "reporting". These settings cause export to repository to fail:
Error sending to server....
The "detailed" log adds no further information and Mso2Rqm_Debug.log doesn't appear to contain anything helpful either. I've tried exporting to a file and the contents look just like those obtained using RQMUrlUtility to pull a test script from RQM.
I've also tried putting quotes around execution and reporting in the Excel cells. Export to repository works fine if I set
testscript.steps.type="execution"
rather than
testscript.steps.type=B
Any suggestions please?
I'd also like to set the test script title to the worksheet name. However, XLSWorksheetID can only appear on the left side. Is there any way of setting the test script title to the worksheet name?
Thanks!
A B C
Step # Step Type Step Description
Step Type is either "execution" or "reporting". These settings cause export to repository to fail:
Error sending to server....
The "detailed" log adds no further information and Mso2Rqm_Debug.log doesn't appear to contain anything helpful either. I've tried exporting to a file and the contents look just like those obtained using RQMUrlUtility to pull a test script from RQM.
I've also tried putting quotes around execution and reporting in the Excel cells. Export to repository works fine if I set
testscript.steps.type="execution"
rather than
testscript.steps.type=B
Any suggestions please?
I'd also like to set the test script title to the worksheet name. However, XLSWorksheetID can only appear on the left side. Is there any way of setting the test script title to the worksheet name?
Thanks!
5 answers
This appears to be a defect (inverse of https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/56614). Please open a new defect.
Note, defect https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/55185 adds additional logging detail, but you need to download the RQM 3.5 M2 version of the utility (backwards compatible).
Looks like you have already seen https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Troubleshooting.
Note, defect https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/55185 adds additional logging detail, but you need to download the RQM 3.5 M2 version of the utility (backwards compatible).
Looks like you have already seen https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Troubleshooting.
Are you saying that the problem reading the test step type from the Excel spreadsheet is a defect?
Yes.
Not sure what you mean by inverse off...
Defect https://jazz.net/jazz02/resource/itemName/com.ibm.team.workitem.WorkItem/56614 is related to an issue with using literal strings with the XLSArtifactID keyword, instead of a column or cell definition (e.g. inverse).
Or is this relating to how I can use the worksheet name as my test script name?
No.