topic Re: Cannot generate a CSV file in reports in Server Management - Systems Insight Manager

Cannot generate a CSV file in reports

Mathew Kohnen — Tue, 09 Nov 2010 14:06:27 GMT

HP SIM verizion 6.2
If i create a report in csv format it will not open in excel
Microsoft Excel cannot access the file
There are several possible reasons:

The file name or path does not exist
The file you're trying to open is being used by another program. Close the document in the other program, and try again.
The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook with a different name.

I cannot save it either

I came acroos some similar problems on the WEB which suggested changing the HTTP headr in IIS.
That did not work.

Re: Cannot generate a CSV file in reports

Arunav Nayak — Wed, 10 Nov 2010 05:19:02 GMT

Hi Mathew,

Can you please verify(if you have administrative access on the CMS) if the file that the browser is trying to access is present under
\hpwebadmin\webapps\ROOT\mxportal\reports

And if present, does it have any data in it. If the file is present and has data in it then there might be issue with access to the file.

Also, can you please share the SIM log file after creating a csv report.

Thanks,
Arunav

Re: Cannot generate a CSV file in reports

Arunav Nayak — Wed, 10 Nov 2010 05:30:53 GMT

Hi Mathew,

I have few more questions:
a) Are you able to successfully create xml report?
b) Are you seeing the same problem while performing the same operation in Firefox 3.6?

Thanks,
Arunav

Re: Cannot generate a CSV file in reports

Mathew Kohnen — Wed, 10 Nov 2010 12:43:00 GMT

Good morning, Thank you for replying.
yes I am an administrator.
The csv file is being creaated coorectly and if i open excell and manually navigate to
\Program Files (x86)\HP\Systems Insight Manager\hpwebadmin\webapps\ROOT\mxportal\reports, I can open it fine
Firefox opens the file in a browser window
I do believe it is IE8. Ther are some articals on the WEB about downloading a file via SSL that speaks of the headers being sent.

Re: Cannot generate a CSV file in reports

Arunav Nayak — Wed, 10 Nov 2010 12:57:42 GMT

Hi Mathew,

I have attached a pdf file where detailed analysis has been given.

Please go through it.

Thanks,
Arunav

Re: Cannot generate a CSV file in reports

Mathew Kohnen — Wed, 10 Nov 2010 13:53:58 GMT

Thank you, I had seen everything listed in the PDF and tried them execpt IE9. I installed IE9.
Still does not work.
I was aware of the firefox work around. I'll navigate to the report directory and open it in excel.
Thank you again for your suggestions

Re: Cannot generate a CSV file in reports

Mathew Kohnen — Wed, 10 Nov 2010 14:22:39 GMT

It bothered me that the registry fix was not working. So i tripled checked it and of course I found a stupid mistake.
Thank you for having me take another look
I can confirm that it worksd and it is needed for IE9 also.
Thanks again for your help

Re: Cannot generate a CSV file in reports

Arunav Nayak — Wed, 10 Nov 2010 16:35:36 GMT

Hi Mathew,

Thank you for confirming.
Your suggestion will help lot of our other users to resolve similar issues.

Thanks,
Arunav