Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Bulk insert TestCases using the RQMURlUtility?

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

0 votes



7 answers

Permanent link
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.

0 votes


Permanent link
Thanks Paules.

I was expecting it so I actually did write a script yesterday, that invokes this utility for each testcase. Its working!

Thanks

0 votes


Permanent link
Great news. Did you want to post it for others to use?

0 votes


Permanent link
Its jruby script and more proprietary for the application I am working with. I need to make it more generic and post it in as open source. Do you have a forum for that?

0 votes


Permanent link
I was thinking something a little simpler such as posting it to this thread. Alternatively, if you could provide an extension to the RQM URL Utility, you could open an enhancement and attached the code as a patch.

0 votes


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

0 votes


Permanent link
We are planning to add this support to the RQM Reportable API under Support bulk upload for all resources. (71696).

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 06 '11, 2:45 p.m.

Question was seen: 6,450 times

Last updated: Nov 15 '12, 8:13 a.m.

Confirmation Cancel Confirm