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

Creating Configuration Files for use with ExcelImporter

I am using the RQMWordExcelImporter Tool to create XML files from an Excel spreadsheet to import into RQM. Does anyone know where can I find more examples of configuration files other than the samples provided with the excel importer tool. The samples that come with the tool don't have examples for some fields such as 'State' etc. I haven't been able to find anything useful on this topic in the forum and would really appreciate some assistance. Thanks.

0 votes



3 answers

Permanent link
More info:
Excel spreadsheet contains a column called Status in this column a possible value can be 'Approved' or 'Under Reveiw'. I want to be able to export that column and have the xml output look like this: <alm>com.ibm.rqm.planning.common.approved</alm>

I have no idea how to write the line for the configuration file to create the output I am looking for from the excel spreadhseet using the RQM Excel Importer. Someone please help! Thank you.

0 votes


Permanent link
XML output didn't show up how it is suppose to look, this is how it should look
<alm:state xmlns:alm="http://jazz.net/xmlns/alm/v0.1/">com.ibm.rqm.planning.common.approved</alm:state>

0 votes


Permanent link
Hey if anyone happens to look at this post I figured out the configuration file line of code for the State field in RQM.

In my excel spreadsheet column E is called Status where it can be Draft, Under Review or Approved.

I used this line of code in the configuration file to get the correct XML ouput:
testcase.alm:state xmlns:alm="http://jazz.net/xmlns/alm/v0.1/"=E

I hope this helps others.

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: Aug 31 '09, 1:58 p.m.

Question was seen: 5,814 times

Last updated: Aug 31 '09, 1:58 p.m.

Confirmation Cancel Confirm