(imported topic written by Steve73)
Hi
Fixlet Compliance By Computer Group (1.6)
http://forum.bigfix.com/viewtopic.php?id=4307&p=1
The report works great but I can’t export to excel from Firefox
I’m using latest firefox browser and the export is saved as a .xls.part extension so it only appears to partly downloading the excel file.
Have tried a number of things but can’t get this working.
Not sure if the report or browser causing the issue.
Any suggestsions?
Cheers
(imported comment written by Lee Wei)
I use FireFox 14.0.1 and it appears to use extension .xls and works correctly for me.
When the file is saved as .part, simply rename to .xls and it will work fine.
You will notice that the file is actually an XML file that Excel understands and knows how to open.
So you can open in a text editor to browse.
Lee Wei
(imported comment written by Steve73)
Thanks for the reply Lee.
If i rename to .xls and then i attempt to open it i get the following error:
“The file you are trying to open, “filename.xls”, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?”
…I then click Yes and get the following:
“The file is corrupt and cannot be opened”
I then click ok and get:
“Problems came up in the following areas during load:”
Workbook Setting
This is in Excel 2010.
Any other thoughts?
Thanks
Steve
(imported comment written by Steve73)
Lee,
Just to add, after i click ok after the Workbook Setting error it generates a log file with the following content:
XML Spreadsheet Warning in Workbook Setting
REASON: String too long
ACTION: Truncating string
FILE: C:\Users\g0790524\AppData\Local\Temp\p1Oo7geN.xls
GROUP: Workbook
TAG: Worksheet
ATTRIB: Name
VALUE: Compliance for - SERVERS: CSM Patching - Test by COMPANYNAME: MICROSOFT PATCH BASELINE: Servers 2012 - Last Updated to May 2012 (SR): (3048 total items)
XML ERROR in Workbook Setting
REASON: Bad Value
FILE: C:\Users\g0790524\AppData\Local\Temp\p1Oo7geN.xls
GROUP: Workbook
TAG: Worksheet
ATTRIB: Name
VALUE: Compliance for - SERVERS: CSM Patching - Test by COMPANYNAME: MICROSOFT PATCH BASELINE: Servers 2012 - Last Updated to May 2012 (SR): (3048 total items)
(imported comment written by Lee Wei)
Hi Steve,
All the messages are expected, except that you should be able to open the spreadsheet.
So try again by accepting the errors.
Lee Wei
(imported comment written by Steve73)
Hi Lee
Unfortunately it doesn’t open.
When the Workbook Setting error comes up it says below it:
this file cannot be opened because o errors. Errors are listed in:
…etc…log (the content of the log file in my previous post
Clicking ok at this point opens excel itself but not the report.
Cheers
Steve
(imported comment written by Steve73)
Hi Lee
I have noticed that if i open the spreadsheet in a text editor and change the lines:
Compliance for - SERVERS: CSM Patching - Test by COMPANYNAME: MICROSOFT PATCH BASELINE: Servers 2012 - Last Updated to May 2012 (SR): (3048 total items)
To something shorter like “report” it will then open fine in excel.
Do we know what the character length limit is?
Cheers
Steve
(imported comment written by Steve73)
Hi Lee
It appears the cause for this issue is the title (too long)
Where you say:
“I take the title of the grid and use that to name the worksheet”
It is possible to edit the script to just name the worksheet “Report” which should resolve my issue?
Cheers
Steve
(imported comment written by Lee Wei)
Hi Steve,
Yes I will put this on my to-do list.
Are you able to workaround it by pressing “continue” when you get the message?
Lee Wei
(imported comment written by Steve73)
Thanks Lee.
continue just opens a blank excel with no report data.
If as above I edit the xml title and name tags to something shorter like “Report” it does then open ok.
Cheers
Steve