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
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