It's all about the answers!

Ask a question

RQM Excel Importer


0
1
Sanjay Sutar (46256) | asked Apr 02 '12, 2:34 a.m.
To export the Excel data to RQM repository, we use Jazz Utility RQM ExcelImporter.

The pre-requisites checked are:
1. MS .Net framework -v2.0 or later(v 1.0 also needed)
2. MS-Excel 2007
3. MS-Office Inter-op assemblies

Steps followed to install the RQM Excel Importer Utility:
1. Checked for all the pre-requisites
2. Installed the Utility
3. Restarted MS-Excel


Installation could be completed successfully. However, RQM menu does not appear in Excel window after installation
When checked in the COM Addins tab, "Mso2Rqm Excel Add-in" seems to be available. However, Load Behaviour says, "Not Loaded. A runtime error occurred d during the loading of the COM Add-in"
Checked Mso2Rqm_Debug.log file which says: 3/30/2012 3:18:50 PM: INFO: : RQMExporter created!

Concerning the same, I've following queries regarding this Utility:
1. Is this Utility sufficient enough to export Excel data to RQM
2. Are the other utilities: RQM Copy & RQM Url Utilities required as well. If so, how to they come in picture with RQM Excel Importer.
3. What are steps taken to create a corresponding cfg file for the excel data
4. Any article explaining the usage of RQM Excel Imported would prove helpful

6 answers



permanent link
Ranjith Parameswaran (12311215) | answered Apr 02 '12, 4:09 a.m.
Hello Sanjay,

Please refer the wiki link below, it has all the required details.
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter

permanent link
Girish Chandra P (953246) | answered Jul 29 '12, 2:36 a.m.
1) Check the macro settings have to be enabled
2) check the logged in user have write permissions in folders C:\Users\Administrator\AppData\Roaming\Mso2Rqm

permanent link
Girish Chandra P (953246) | answered Nov 09 '13, 11:11 a.m.
Archana,

If you are using MS Office - 2007 , then MAcro Setting will be in
Excel options ->Add ins
Choose the RQM****.dll ad enanle the same.

How to enable :
Down there will b an option called Manage , and select Disabled Items and click on GO and select RQmimporter and click om okay , rebook the MS excel and look into RQM Addins.

permanent link
Girish Chandra P (953246) | answered Jul 29 '12, 2:37 a.m.
Sorry enabled macro I mean  in the macro settings the RQM*****.dll should be enabled or disable the macro settings ( keep the security to low).

permanent link
Hao Wan (1.5k35) | answered Jul 30 '12, 2:05 a.m.
JAZZ DEVELOPER
 Ranjith and Girish is right, what's more you also need to give write permissions to registry to this user.
what's more you can take a reference to the samples in the Excel Importer folder.

permanent link
archana kurup (2026972) | answered Nov 09 '13, 3:43 a.m.

Your answer


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