It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,960

question asked: Sep 30 '11, 4:56 a.m.
question was seen: 6,433 times
last updated: Sep 30 '11, 4:56 a.m.

Related questions

Test script import from Excel

0
David Hanslip (231●2●44●48) | asked Sep 30 '11, 4:56 a.m.
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!

5 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Paul Slauenwhite (8.4k●1●2) | answered Sep 30 '11, 7:24 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.
0
permanent link
David Hanslip (231●2●44●48) | answered Oct 02 '11, 1:15 a.m.
Thanks Paul.

Are you saying that the problem reading the test step type from the Excel spreadsheet is a defect? Not sure what you mean by inverse off...

Or is this relating to how I can use the worksheet name as my test script name?

Regards, Dave.
0
permanent link
Paul Slauenwhite (8.4k●1●2) | answered Oct 03 '11, 8:32 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.
0
permanent link
David Hanslip (231●2●44●48) | answered Oct 03 '11, 8:24 p.m.
Thanks Paul. I'll raise a defect on that.

So, is there any way of setting the test script title to the worksheet name?
0
permanent link
Paul Slauenwhite (8.4k●1●2) | answered Oct 03 '11, 8:59 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
So, is there any way of setting the test script title to the worksheet name?


Unfortunately, no. Please considering open an enhancement.

Your answer

Register or 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.