Bulk insert TestCases using the RQMURlUtility?
![](http://jazz.net/_images/myphoto/91755c0247e902ab68e82b6f63164d99.jpg)
Hello
I generated an XML file that has a few TestCases (parent tag say root). During PUT I get 400 when XML has multiple TestCases. I scceeds when XML has one TestCase only. Is bulk insert supported? If so what should be the parent tag?
If this is not supported is a way to do it using this utility?
Thanks
I generated an XML file that has a few TestCases (parent tag say root). During PUT I get 400 when XML has multiple TestCases. I scceeds when XML has one TestCase only. Is bulk insert supported? If so what should be the parent tag?
If this is not supported is a way to do it using this utility?
Thanks
7 answers
![](http://jazz.net/_images/myphoto/91755c0247e902ab68e82b6f63164d99.jpg)
Bulk create (POST)/update (PUT)/delete (DELETE) is not supported (see https://jazz.net/wiki/bin/view/Main/RqmApi#Usage_Basics), since the request URL must be a resource URL (see https://jazz.net/wiki/bin/view/Main/RqmApi#resourceUrl_for_interaction_with). You would need to write a script to invoke the URL Utility for each test case.
![](http://jazz.net/_images/myphoto/91755c0247e902ab68e82b6f63164d99.jpg)
As an alternative, You can consider using import.bat tool to import an XML file into RQM. It import one file at a time. I think writing a script on top of it to iterate through all xml files and import files using import.bat tool should not be a big task.
The tool can be found in RQM installation e.g. C:\Program Files\IBM\JazzTeamServer\server\conf\qm\tools\import\import.bat
Usage:
Usage: import.bat [options]
/H : show this help
/S server : RQM server. E.g. https://servername:9443
/C context : RQM context root (Optional, default is qm
/U username : login username
/P password : login password
/A area : project area. Default is Quality+Manager
/T type : type of resource. E.g. testcase
/F file : XML file to import
The tool can be found in RQM installation e.g. C:\Program Files\IBM\JazzTeamServer\server\conf\qm\tools\import\import.bat
Usage:
Usage: import.bat [options]
/H : show this help
/S server : RQM server. E.g. https://servername:9443
/C context : RQM context root (Optional, default is qm
/U username : login username
/P password : login password
/A area : project area. Default is Quality+Manager
/T type : type of resource. E.g. testcase
/F file : XML file to import
![](http://jazz.net/_images/myphoto/91755c0247e902ab68e82b6f63164d99.jpg)
We are planning to add this support to the RQM Reportable API under Support bulk upload for all resources. (71696).