Importing Test Scripts and Test Cases.
![](http://jazz.net/_images/myphoto/cdf618daee4fe6a71eba89dd6af0d559.jpg)
8 answers
![](http://jazz.net/_images/myphoto/cdf618daee4fe6a71eba89dd6af0d559.jpg)
Hi Clayton - no problems here.
I usually get the XML "skeleton" either by looking at one of the sample XML files in the install dir or by using Poster to get an existing artifact. I then modify the data and reimport (either through the Import functionality in the UI or by PUTing with Poster). Works fine.
Are you getting a specific error when you try to do this?
Regards,
John
I usually get the XML "skeleton" either by looking at one of the sample XML files in the install dir or by using Poster to get an existing artifact. I then modify the data and reimport (either through the Import functionality in the UI or by PUTing with Poster). Works fine.
Are you getting a specific error when you try to do this?
Regards,
John
Has anyone had any success getting test scripts and test cases in xml format to import successfully?
![](http://jazz.net/_images/myphoto/cdf618daee4fe6a71eba89dd6af0d559.jpg)
When you mention, reimport, are you talking about following sequence of tasks:
1. export test cases from RQM
2. modify in some editor, say excel
3. import test cases into RQM to modify the original ones
I am looking for same solution for reimporting RQM data.
1. export test cases from RQM
2. modify in some editor, say excel
3. import test cases into RQM to modify the original ones
I am looking for same solution for reimporting RQM data.
Hi Clayton - no problems here.
I usually get the XML "skeleton" either by looking at one of the sample XML files in the install dir or by using Poster to get an existing artifact. I then modify the data and reimport (either through the Import functionality in the UI or by PUTing with Poster). Works fine.
Are you getting a specific error when you try to do this?
Regards,
John
Has anyone had any success getting test scripts and test cases in xml format to import successfully?
![](http://jazz.net/_images/myphoto/cdf618daee4fe6a71eba89dd6af0d559.jpg)
@chidamla,
for test case, if delete the identifier and webid , projectarea information and using a POST request, then a new testcase will be created, if using PUT with an unexisting external id there's also will be new testcase created, if using PUT with an exist external id, then the testcase with the external will be updated.
if can use RQM URL utility or POSTer to do the request.
if your data is in Excel or word, you can use RQM word/excel importer to do so.
for test case, if delete the identifier and webid , projectarea information and using a POST request, then a new testcase will be created, if using PUT with an unexisting external id there's also will be new testcase created, if using PUT with an exist external id, then the testcase with the external will be updated.
if can use RQM URL utility or POSTer to do the request.
if your data is in Excel or word, you can use RQM word/excel importer to do so.
When you mention, reimport, are you talking about following sequence of tasks:
1. export test cases from RQM
2. modify in some editor, say excel
3. import test cases into RQM to modify the original ones
I am looking for same solution for reimporting RQM data.
Hi Clayton - no problems here.
I usually get the XML "skeleton" either by looking at one of the sample XML files in the install dir or by using Poster to get an existing artifact. I then modify the data and reimport (either through the Import functionality in the UI or by PUTing with Poster). Works fine.
Are you getting a specific error when you try to do this?
Regards,
John
Has anyone had any success getting test scripts and test cases in xml format to import successfully?
![](http://jazz.net/_images/myphoto/cdf618daee4fe6a71eba89dd6af0d559.jpg)
@Hao Wan,
I have done the first upload using a template from the samples folder of Excel Importer Installation folder. Template used is "Testsuite with testcases that have testscripts"; Test Suite, Test Case, Test Script are created and linked with each other.
Now I wanted to update/overwrite only the test script. Can you help me with the cfg file and an excel template. I can be reached at chidambaram (at) maintec (dot) in. My client will be comfortable with excel than command line.
I have done the first upload using a template from the samples folder of Excel Importer Installation folder. Template used is "Testsuite with testcases that have testscripts"; Test Suite, Test Case, Test Script are created and linked with each other.
Now I wanted to update/overwrite only the test script. Can you help me with the cfg file and an excel template. I can be reached at chidambaram (at) maintec (dot) in. My client will be comfortable with excel than command line.
![](http://jazz.net/_images/myphoto/cdf618daee4fe6a71eba89dd6af0d559.jpg)
hi @chidamla,
you can use the following config file.
and don't change column B in excel, as column contains the external id of the testscript.
you can use the following config file.
and don't change column B in excel, as column contains the external id of the testscript.
testscript.XLSStartRow=5
testscript.XLSArtifactID=B
testscript.dc:title=B
testscript.dc:description=C
testscript.steps.type="execution"
testscript.steps.description=E
testscript.steps.title=D
testscript.steps.name=D
testscript.steps.expectedResult=F
testscript.XLSDelimeter=\n
@Hao Wan,
I have done the first upload using a template from the samples folder of Excel Importer Installation folder. Template used is "Testsuite with testcases that have testscripts"; Test Suite, Test Case, Test Script are created and linked with each other.
Now I wanted to update/overwrite only the test script. Can you help me with the cfg file and an excel template. I can be reached at chidambaram (at) maintec (dot) in. My client will be comfortable with excel than command line.
![](http://jazz.net/_images/myphoto/cdf618daee4fe6a71eba89dd6af0d559.jpg)
hi @chidamla,
just sent email to you.
just sent email to you.
@Hao Wan,
I have done the first upload using a template from the samples folder of Excel Importer Installation folder. Template used is "Testsuite with testcases that have testscripts"; Test Suite, Test Case, Test Script are created and linked with each other.
Now I wanted to update/overwrite only the test script. Can you help me with the cfg file and an excel template. I can be reached at chidambaram (at) maintec (dot) in. My client will be comfortable with excel than command line.