Exporting an Excel spreadsheet from an RTC 2.0 Query page
Hi,
I want to be able to track the line items using a spreadsheet, as we are getting into Agile. However, the icon on the top right -Download as Spreadsheet (.csv) option does not work. Nothing happens when I click on the icon-not even an error message.
On one or two occasions, I right clicked a page of "line items" and saw the Export as Excel option, and was able to open an empty Excel sheet. I went through Data> Import External Data> Edit Query, but the page did not populate. I got a Javascript error. My Java settings are intact.
My question is, does RTC 2.0 support the generation or export of a spreadsheet, with all the formatting intact? Or a CSV file, with minimum formatting? Please note that I am not referring to the Report generation option, but instead, a query page, from where I want an Excel sheet.
Thank you. Thelonius Monk
I want to be able to track the line items using a spreadsheet, as we are getting into Agile. However, the icon on the top right -Download as Spreadsheet (.csv) option does not work. Nothing happens when I click on the icon-not even an error message.
On one or two occasions, I right clicked a page of "line items" and saw the Export as Excel option, and was able to open an empty Excel sheet. I went through Data> Import External Data> Edit Query, but the page did not populate. I got a Javascript error. My Java settings are intact.
My question is, does RTC 2.0 support the generation or export of a spreadsheet, with all the formatting intact? Or a CSV file, with minimum formatting? Please note that I am not referring to the Report generation option, but instead, a query page, from where I want an Excel sheet.
Thank you. Thelonius Monk
5 answers
I cannot find documentation on exactly what setting needs to be changed to allow .csv downloads on IE. I am running IE 9 and used the fixit tool provided by Microsoft to reset IE. This worked for me. Take a look at:
http://support.microsoft.com/kb/923737
Note that this will reset all your browser settings, and not just the ones for controlling .csv downloads.
http://support.microsoft.com/kb/923737
Note that this will reset all your browser settings, and not just the ones for controlling .csv downloads.
Hi Jelly,
Thank you for responding. My main issue is that nothing happens when I click the Download as Spreadsheet (.csv)" button. Either I should get an error message or a Download window from Firefox, or something similar. In the status bar below, too nothing happens. I am beginning to wonder if there is a Microsoft enabled setting I should ensure, to be able to connect to the Excel download command.
regards
Thelonius
Thank you for responding. My main issue is that nothing happens when I click the Download as Spreadsheet (.csv)" button. Either I should get an error message or a Download window from Firefox, or something similar. In the status bar below, too nothing happens. I am beginning to wonder if there is a Microsoft enabled setting I should ensure, to be able to connect to the Excel download command.
regards
Thelonius