Cannot generate a CSV file in reports

[Mathew Kohnen]

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.

[Arunav Nayak · Accepted solution]

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

[Arunav Nayak]

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

[Mathew Kohnen]

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.

[Arunav Nayak]

Hi Mathew,

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

Please go through it.


Thanks,
Arunav

[Mathew Kohnen]

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

[Mathew Kohnen]

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

[Arunav Nayak]

Hi Mathew,

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


Thanks,
Arunav