Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot generate a CSV file in reports

 
SOLVED
Go to solution
Highlighted

Cannot generate a CSV file in reports

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.

7 REPLIES 7
Highlighted
Valued Contributor
Solution

Re: Cannot generate a CSV file in reports

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
Highlighted
Valued Contributor

Re: Cannot generate a CSV file in reports

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
Highlighted

Re: Cannot generate a CSV file in reports

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.
Highlighted
Valued Contributor

Re: Cannot generate a CSV file in reports

Hi Mathew,

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

Please go through it.


Thanks,
Arunav
Highlighted

Re: Cannot generate a CSV file in reports

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
Highlighted

Re: Cannot generate a CSV file in reports

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
Highlighted
Valued Contributor

Re: Cannot generate a CSV file in reports

Hi Mathew,

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


Thanks,
Arunav