It's all about the answers!

Ask a question

RQM Excel Importer : Could not retrieve the Project


Naveen Tyagi (19778152) | asked Feb 17 '15, 1:54 p.m.
edited Feb 18 '15, 7:57 a.m.
 I am using  RQM Excel Importer tool, i have Installed it successfully and its now visible in Excel Add-Ins. When I open the importer tool I perform the following steps: 
1. Open the excel file containing the test case name and subject. 
2. In the add-ins tab I go to RQM>Export to Repository 
3. In the Export to RQM window I enter/validate my credentials, after validating my credentials Projects are  not populating in drop down list, Any ideas how to sort this out ?  Your help would greatly appreciated.

Some related Info.
  •  MS Excel 2013
  • RQMExcelWordImporter-5.0.2.
  • RQM 5.0  
  • Window 7 
  • I  have Project Admin Righs with "Data Migration Administrator" Role and  tried this by JAZZ admin credentials as well but still facing same problem.


Comments
Ara Masrof commented Feb 17 '15, 3:44 p.m.
JAZZ DEVELOPER

 Is the user you are specifying to connect a member of the QM project Area(s)? 


Naveen Tyagi commented Feb 17 '15, 11:48 p.m.

Hi Ara,

I have project admin rights and i have tried this by JAZZ admin credentials as well but still facing same problem.


Naveen Tyagi commented Feb 18 '15, 4:41 a.m. | edited Feb 18 '15, 4:43 a.m.

Here is my Mso2Rqm_Debug.log details if i am trying to Export without any Project in drop down list....

18-02-2015 15:02:08: sending testcase38 named Test_Cases_made_from_scripts_Acme_Hammers_1.xml

18-02-2015 15:02:09: Server returned code Found

18-02-2015 15:02:09: Error sending to server Test_Cases_made_from_scripts_Acme_Hammers_1.xml of type testcase

18-02-2015 15:02:09: Found

18-02-2015 15:02:09: ERROR: <Unknown Caller Context>: ExcelExportRepositoryDialog: Error saving to url https://****************.com/rm of type testcase


18-02-2015 15:02:09: ERROR: <Unknown Caller Context>: With description: Found with message


18-02-2015 15:02:09: finished writing artifacts

18-02-2015 15:02:09: INFO: <Unknown Caller Context>: Exporting completed with 39 failures!


Reshma Ratnani commented Feb 18 '15, 6:25 a.m.
JAZZ DEVELOPER

Its expected behavior. Without providing any Project Area where will the utility export the artifact? Utility needs to know to which Project Area the artifacts have to be exported. Without that server will throw exception.

User should have "Data Migration Administrator" role

One answer



permanent link
Reshma Ratnani (1.1k1) | answered Feb 18 '15, 6:26 a.m.
JAZZ DEVELOPER
Refer https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter#Prerequisites for more information

Comments
Naveen Tyagi commented Feb 18 '15, 6:47 a.m.

Thanks Reshma for your response, I have read this article before and I am assigined Data migration Administrator role but still getting same error.

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.