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

RQM: Excel Importer: Cannot import pre-conditions

Questions
Tags
Users
Badges
Gonzalo Garcia Favre
(61●3●8●13) Feb 26 '13, 9:00 a.m.
Hi,

I'm having problems trying to import preconditions using the Excel Importer tool.

I have used the following line in the script for pre-conditions:

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=G

After having imported the test cases and test scripts, I go to RQM to see if everything was importer correctly, but when I look at the preconditions I found the following text:

%3Cdiv xmlns="http%u003A//www.w3.org/1999/xhtml" xmlns%u003Ao="urn%u003A//schemas-microsoft-com%u003Aoffice%u003Aoffice" xmlns%u003Ast1="urn%u003A//schemas-microsoft-com%u003Aoffice%u003Asmarttags" xmlns%u003Av="urn%u003A//schemas-microsoft-com%u003Avml" xmlns%u003Aw="urn%u003A//schemas-microsoft-com%u003Aoffice%u003Aword"%3EA video is streamming.%3C/div%3E

Does anyone knows what could be the problem?

Thanks

0 votes

Comments
Chenyue Gao
JAZZ DEVELOPER Feb 26 '13, 3:44 p.m.

are the test cases linked to any test suite? It will be much more helpful, if you could post your entire script. Thanks

Gonzalo Garcia Favre
Feb 26 '13, 3:49 p.m.

I paste the script below. I couldn't pasted it here

6 answers
10,195 views
0 votes

6 answers

Permanent link
Anthony Paul
(70●2●18●21) Feb 27 '13, 10:59 a.m.
 i am using excel 2010 and on the other PC I have is excel 2007. here is the script we use, have look and see if we are doing anything different to you:

// This configuration file creates a test case with each test script and links them.
// The linking is accomplished by self referential data


// Start looking for scripts after row 2
testscript.XLSStartRow=2

// use the data in the first row of a found script's column A
testscript.XLSArtifactID=A
testscript.dc:title=D
testscript.dc:description=M
testscript.category term="Test Phase".value=E
testscript.category term="Test Area".value=F
testscript.category term="Sub Test Area".value=G
// testscript.category term="Change Item".value=H


testscript.customAttributes identifier="Deadlines".name="Deadlines".type="SMALL_STRING".value=J
testscript.customAttributes identifier="Test_Data_Location".name="Test Data Location".type="SMALL_STRING".value=L
testscript.customAttributes identifier="Originating_RMT_File".name="Originating RMT File".type="SMALL_STRING".value=C
testscript.customAttributes identifier="Originating_RMT_File_Location".name="Originating RMT File Location".type="SMALL_STRING".value=B


// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.description=O
testscript.steps.title=N
testscript.steps.name=N
testscript.steps.expectedResult=P

// a new script starts when we encounter an empty row
testscript.XLSDelimeter=\n
// we want to use the data we got for each test script to create a test case
testcase.ID=testscript.XLSArtifactID

// by refering to the testscript's field instead of the column that data comes from
// the tool will also create links to each of the test scripts.
testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description


testcase.category term="Test Phase".value=E
testcase.category term="Test Area".value=F
testcase.category term="Sub Test Area".value=G
testcase.category term="Change Item".value=H

testcase.weight="100"

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition", "RQM-KEY-TC-PRE-COND-TITLE")=I

1 vote

Comments
Gonzalo Garcia Favre
Feb 27 '13, 12:20 p.m.

Thanks for your help Anthony. I don't find any difference between both configuration files, but I don't know why it works for you and I have a different result executing that line. thanks for all your help

Permanent link
Gonzalo Garcia Favre
(61●3●8●13) Feb 26 '13, 3:49 p.m.
This is the entire config file

////////////////////////////////////Script Configuration
// Start looking for scripts after row 2
testscript.XLSStartRow=2
testscript.dc:title=B
testscript.dc:description=F

// the literal "execution" will be put into the step type tag, so all steps will be of type execution
testscript.steps.type="execution"
testscript.steps.title=B
testscript.steps.description=K
testscript.steps.expectedResult=L

testscript.XLSDelimeter=\n

////////////////////////////////////Test Case Configuration
// Start looking for scripts after row 2
//testcase.XLSStartRow=2

testcase.dc:title=testscript.dc:title
testcase.dc:description=testscript.dc:description

testcase.weight="1"

testcase.category term="Applicable devices".value="All"
testcase.category term="Project".value="Project X"
testcase.category term="Release".value="Release X"
testcase.category term="Feature".value=N
testcase.category term="Execution Type".value="Manual"
testcase.category term="Test Scenario".value="Normal"

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=G

// a new Test starts when we encounter an empty row
testcase.XLSDelimeter=\n

0 votes

Permanent link
Hao Wan
JAZZ DEVELOPER (1.5k●3●5) Feb 26 '13, 10:33 p.m.
hi Gonzalo,
what's the value in the excel document in column G?

0 votes

Comments
Gonzalo Garcia Favre
Feb 27 '13, 7:16 a.m.

Its a text string: E.g.:

Project XX is up and running 
User is located at the Main Menu  

Permanent link
Anthony Paul
(70●2●18●21) Feb 27 '13, 7:54 a.m.
 Hi I run the same script and the preconditions look fine for us. What version of the migration tool are you running. We are using 4.01 and our RQM version is 4.0.


The line we use is

testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition", "RQM-KEY-TC-PRE-COND-TITLE")=I

And the only difference I can tell with yours is we have a space between , and "RQM-KEY....


0 votes

Comments
Gonzalo Garcia Favre
Feb 27 '13, 8:27 a.m.

I have the RQMExcelImporter Version: 1.0.4529.9380 and using RQM 4.0.
Where have you download that version from RQM excel importer from?

Anthony Paul
Feb 27 '13, 8:40 a.m.

Its from here:


Anthony Paul
Feb 27 '13, 8:41 a.m.

 If you get a weird access denied message from that link try this one:


Gonzalo Garcia Favre
Feb 27 '13, 10:09 a.m.

Thanks Anthony. I've download the latest version (4.0.1.9638) and tried to import again using "test" as the string to be imported in pre-conditions but got the same result:

%3Cdiv xmlns="http%u003A//www.w3.org/1999/xhtml" xmlns%u003Ao="urn%u003A//schemas-microsoft-com%u003Aoffice%u003Aoffice" xmlns%u003Ast1="urn%u003A//schemas-microsoft-com%u003Aoffice%u003Asmarttags" xmlns%u003Av="urn%u003A//schemas-microsoft-com%u003Avml" xmlns%u003Aw="urn%u003A//schemas-microsoft-com%u003Aoffice%u003Aword"%3Etest%3C/div%3E

Any ideas?


Permanent link
Anthony Paul
(70●2●18●21) Feb 27 '13, 10:38 a.m.
 I am sort of out of ideas. out of curiosity what is www.w3.org, where is it getting that from

Maybe take the "Scripts that create testcases" excel template add a new column at the end for the pre condition and try again.

Maybe there is something up with the excel sheet you are using. 

0 votes

Comments
Gonzalo Garcia Favre
Feb 27 '13, 10:47 a.m.

Hi Anthony. What version of Excel are you using?
I am using Excel 2007. it was an xlsm file since I needed to code some things before doing the import.
I have copied and pasted  what I wanted to import (only values) in another excel file (xls 97-2003) but the same result shows up.

Permanent link
Manoj Khatua
(11●2) Mar 23 '17, 9:18 a.m.

I am trying to export test cases using RQM Excel Importer, I have modified the configuration file according to my Test Case sheet.
I am able to export the cases without the testCasePreCondition. But with testCasePreCondition, I’m getting the following error.

The remote server returned an error: (403) Forbidden.
Your account does not have the group memberships required to access the requested resource.

I am using the bellow line for Pre-condition.
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=C

I have Test Team Member access on the project Area.
Do i need any special permission to export with testCasePreCondition?

0 votes

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
× 10,941
× 173

Question asked: Feb 26 '13, 9:00 a.m.

Question was seen: 10,195 times

Last updated: Mar 23 '17, 9:18 a.m.

Related questions
Confirmation Cancel Confirm