It's all about the answers!

Ask a question

Excel Importer: any changes for MS Office 2010 needed?


Judith Leick (8156) | asked Nov 20 '12, 12:03 p.m.
Hello,

we have a cfg file which is working for my colleagues with MS Office 2003, but it's not working with MS Office 2010. Do we need to change the the parameters?

e.g. currently we have statements like this:
testscript.XLSWorksheetID="Template"
testscript.XLSStartRow=8

Do we need to change the config file to values like testscript.XLSXWorksheetID="Template"
testscript.XLSXStartRow=8 or something similar?

Regards
Judith

2 answers



permanent link
Jerry Shengulette (63914) | answered Nov 20 '12, 3:16 p.m.
JAZZ DEVELOPER
I have been running MS Office 2010 for a while now with no specific issues. 

You might have to re-install the Interop assemblies; instructions here (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter) under "Add-in Installation" section.

Constructs such as you mentioned should still be OK.  How, exactly, is your new stuff not working?

Comments
Judith Leick commented Nov 21 '12, 4:41 a.m.

Hi Jerry,
we are getting the error message: "Invalid server name, user name or password". But the credentials are working fine for MS Office 2003.


permanent link
Hao Wan (1.5k35) | answered Nov 23 '12, 11:54 p.m.
JAZZ DEVELOPER
Hi Judith,
I think no changes needed for office 2010
does the MS office 2003 and office 2010 installed on the same windows?
would you take a look at the MSO2RQM_debug.log, to see if it is a network problem and attach the log here?


Comments
Judith Leick commented Nov 27 '12, 7:53 a.m.

Hi Hao,

MS office 2003 and MS Office 2010 are installed on the same Windows/Laptop.
Here is the content of the logfile:
26.11.2012 14:04:13:
SESSION: 26.11.2012 14:04:12
26.11.2012 14:04:13: INFO: : RQMExporter created!
26.11.2012 14:04:13: INFO: : RQMExporter Startup!
26.11.2012 14:04:13: INFO: : Mso2Rqm: Mso2Rqm instantiated
26.11.2012 14:04:14: INFO: : ExcelApplicationContext: Destroyed commands
26.11.2012 14:04:14: INFO: : ExcelApplicationContext: Created commands
11/26/2012 2:05:38 PM: ERROR: : RQMConnector: Login - Error POSTing credentials to https://henry.ihost.com:9445/qm
11/26/2012 2:05:38 PM: EXCEPTION: : Object reference not set to an instance of an object.
11/26/2012 2:05:38 PM:    at Mso2Rqm_Common.RQMConnector.GetFromServer(String url)
   at Mso2Rqm_Common.RQMConnector.Login(String url, String username, String password)
11/26/2012 2:35:27 PM: INFO: : ExcelApplicationContext: Destroyed commands
11/26/2012 2:35:28 PM: INFO: : ExcelApplicationContext: Destroyed commands
11/26/2012 2:35:28 PM: INFO: : Mso2Rqm Shutdown!

I hope this helps....


Hao Wan commented Nov 28 '12, 3:00 a.m.
JAZZ DEVELOPER

Hi Judith, please sure the user have the correct permission and license.
and you can restart the RQM server and have a try again.


Sam Leathem commented Feb 20 '13, 5:10 a.m.

Hi Hao,

I am having issues getting the Mso2Rqm installer to appear in Excel 2010 once it has "successfully" installed.  I have checked all pre requisites and still no luck.  Please advise.

Thanks.

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.