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

Importing test scripts from Excel with custom columns in to RQM

Questions
Tags
Users
Badges
William McCown
(11●1) Jun 12 '20, 12:09 p.m.

I have just been given the responsibility to get our test scripts imported in to RQM. We are using four columns in Excel to hold all the pieces we need. I can get three of them to go smoothly in to the default test script columns, Description, Expected Results, and Attachments. The problem I am having is with our requirement IDs. In RQM I have created a custom column for the IDs. In the .cfg file I cant seem to get things right to put the value from Excel in the test script ID column in RQM.


.cfg file

testscript.XLSStartRow=7
testscript.dc:title=B

testscript.steps.type=P
testscript.steps.description=E
testscript.steps.title=B
testscript.steps.name=A
testscript.steps.expectedResult=F&image(N)
testscript.steps.customAttributes.identifier="ID".name="ID".value=O

testcript.XLSDelimeter=\n

When I try and do the import i get some errors.

"Error sending to server images_Test_2.xml of type testscript
The remote server returned an error:(400) Bad Request."

I'm certain that I am doing something wrong, but I don't know what it is. I used the sample "WOW Test Cases" to get the structure for the custom attributes part. I have also read the https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Custom_Attributes and that other parts of the wiki and have not found anything about custom attributes for test scripts. I was hoping that I could just change "case" to "script" and it would work. 

Any help would be appreciated.



0 votes

2 answers
2,229 views
0 votes

2 answers

Permanent link
Mehul Patel
FORUM MODERATOR (969●5) Jun 15 '20, 1:48 a.m.

William,


Could you please check whether the identifier of the custom attribute is correct, check wiki on how to get Custom Attribute Identifier and follow steps. 

Please note, step custom attribute is available only v602 onward, and if you are using earlier version than this then you might see some unexpected error.

Regards,
Mehul

0 votes

Permanent link
William McCown
(11●1) Jun 15 '20, 3:53 p.m.

 Mehul,


What you suggested was the problem. I had gotten it in my head from reading various things in the wiki and this forum led me to believe that the identifier was the first name you gave to the custom attribute. Thank you for pointing me in this direction.

While looking in to this some more I ran across the tool called RQMURL utility, read about it here https://www.ibm.com/support/pages/how-retrieve-custom-attribute-identifier-rational-quality-manager. I could not get this tool on the computer I needed it on as my organizations IT department has to approve all software on the computer and have not gotten to it.

In the mean time  I talked to some of my coworkers and one of them suggested to use the dev tools in the web browser to see what was sent. So I made a test script with some data in the custom attribute. I saved off what the browser sent, then I changed the data, sent, and saved again. I then compared both of them looking for my change. This led me to find the attribute ID. I have tried to import with this ID and it woks. This is perhaps not the best way to find it, but it is a workaround.

0 votes

Comments
Mehul Patel
FORUM MODERATOR Jun 15 '20, 11:23 p.m.

William,

I'm glad, it worked for you. Yes RQMUrlUtility is one of the way to conclude identifier which internally makes to similar REST call what you might have captured. You could refer RQM Reportable REST API (https://jazz.net/wiki/bin/view/Main/RqmApi) for more details related to REST support.

Regards,
Mehu

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.

Ask a question
Guidelines
FAQ
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
× 343
× 218
× 173

Question asked: Jun 12 '20, 12:09 p.m.

Question was seen: 2,229 times

Last updated: Jun 15 '20, 11:23 p.m.

Confirmation Cancel Confirm