It's all about the answers!

Ask a question

RQM Excel importer configuration file


Klaus Jørgensen (917) | asked Sep 22 '15, 9:31 a.m.

Hi there

I am having some problems with importing test cases from excel to RQM, when using the below shown configuration file there is create extra fields on the RQM database for the fields "Weight" and "Estimate", so that I end up having two fields called "Weight" and "Estimate".

Could anyone see what's wrong with my configuration file?

RQM version 5.0.1

Excel importer version 4.0.3.7581

// 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 from row 2
testscript.XLSStartRow=2

// Use the data in the first row of a found script's column B
//testscript.XLSArtifactID=C
testscript.dc:title=B
testscript.dc:description=C
testscript.dc:Priority=S
testscript.dc:Originator=T
testscript.dc:Owner=U
//testscript.pre-condition=H
//testscript.category term="Application".value=H

// 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=E
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F

//testcase.XLSLink=testscript
// 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="Type".value=H
testcase.category term="1. Quality Activity".value=K
testcase.category term="2. Architecture Perspective".value=L
testcase.category term="3. Solution Element Type".value=M
testcase.category term="4. Code Review Type",value=N
testcase.category term="5. Test Case Type".value=O
testcase.category term="6. Manual / Automated Test".value=P
testcase.category term="Estimate".value=Q
testcase.category term="Weight".value=R
//testcase.category term="Expected Test Result".value=F
//testcase.category term="Module".value=A
//testcase.category term="Priority".value=B
//testcase.category term="Test Name”.value=C
//testcase.category term="Test Description”.value=D
//testcase.category term="Step description”.value=E
//testcase.category term="Effort (Minutes)".value=G
//testcase.category term="Service".value=I
//testcase.category term="Sub Service".value=J       
//testcase.category term="Test Phase".value=K
//testcase.category term="Created By".value=M
//testcase.dc:Created By=M
//testcase.Pre-Condition=H

Accepted answer


permanent link
Reshma Ratnani (1.1k1) | answered Sep 23 '15, 3:14 a.m.
JAZZ DEVELOPER
Hi,

Please remove below 2 lines from your cfg

testcase.category term="Estimate".value=Q
testcase.category term="Weight".value=R


These 2 lines are creating 2 categories in your testcase
Klaus Jørgensen selected this answer as the correct answer

Comments
Klaus Jørgensen commented Sep 23 '15, 3:28 a.m.

Hi Reshma
Thanks for your fast answer, but if I need the option to import the two fields "Estimate" and "Weight" how should I then specify it in the cfg file?

Regards

Klaus


Reshma Ratnani commented Sep 23 '15, 3:33 a.m.
JAZZ DEVELOPER

You can use below syntax

testcase.weight=D
testcase.estimate

Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Supported_Attributes_and_Configu  for more details


Klaus Jørgensen commented Sep 23 '15, 4:00 a.m.

Awesome, one last question related to how I should specify the field "Priority" in the cfg file.

If I have column "S" in my spreadsheet named "Priority" and a specific testcase row with a priority = "Low" how should that be specified in the cfg file?

Priority  testcase.priority  Supported values:
literal.priority.110 : Low,
literal.priority.120 : Medium,
literal.priority.130 : High,
literal.priority.101 : Unassigned

Example: testcase.priority="literal.priority.130"

Reshma Ratnani commented Sep 23 '15, 4:06 a.m.
JAZZ DEVELOPER

The column S should have below value for that row

literal.priority.110

One other answer



permanent link
Klaus Jørgensen (917) | answered Sep 23 '15, 7:28 a.m.

Once again thanks a lot.

A couple of new question has now popped up.

How can I populate the field "Originator" I assume that field should hold the name of the person who wrote the testcase and not the one importing it?

The "Estimate" field is in mili seconds, is there a syntax to specify minutes or hours e.g. "5min" is 5 minutes?

Regards

Klaus

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.