RQM Excel importer configuration file
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
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
Comments
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
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
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" |
The column S should have below value for that row
literal.priority.110
One other answer
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