(imported topic written by Don65)
Using Excel 2.0 plugin with Excel 2007. Web reports is version 7.2.4.60.
I’m able to retrieve various properties and analysis using the Excel 2.0 plugin, however, the “user name” and “last report time” columns in Excel contain no data. I can also view the “user name” and “last report time” data in the BES console and a few of the web reports users are also generating reports with “user name” and “last report time” data.
Any assistance greatly appreciated.
(imported comment written by Lee Wei)
Don,
I will send you the latest version to test and see if it behaves differently.
Lee Wei
(imported comment written by Don65)
The installation of the version 3.1 Bigfix Excel Connector plugin via the MSI was seamless - no issues encountered.
The “User name” column in Excel 2007 continues to be empty using the 3.1 plugin.
Including “Last report time” in the query returns the following error message - Error from Bigfix: Singular expression refers to non existent object. Getting the above error running the relevance query. It is possible some items may have been removed from the back end, such as a retrieved property since the query was defined? Try using the query wizard to generate a new report.
The above error was returned during subsequent queries of the “Last report time”.
Don
(imported comment written by Lee Wei)
Is it possible that you have duplicate properties with the same names?
This won’t show up in the Excel Connector, and you need to go to the BigFix Console to see it.
You can also try this relevance query to see if there are duplicates.
(name of it, (if (exists source analysis of it) then (name of source analysis of it) else (“Global”))) of bes properties whose (name of it as lowercase = “user name”)
If that is the case, we need to change them to make them unique.
Lee Wei
(imported comment written by Don65)
We had duplicates properties with the same name. Creating uniquely named properties resolved the problem.
Thanks,
Don
(imported comment written by Lee Wei)
Don,
Thanks for letting me know.
The plug-in should really take care of this scenario, so I will work on fixing this at some point.
Lee Wei
(imported comment written by Don65)
A message appears after the query completes indicating “cells over 8200 chars truncated†.
Wondering if there’s a setting (possibly in the registry) to increase the allowable number of chars or possbily disable truncation.
Don
(imported comment written by Lee Wei)
What version of Excel are you using? When I worked on this last, there are bugs for Excel 2003 and 2007.
911 characters in Excel 2003 - http://support.microsoft.com/kb/818808
8203 characters in Excel 2007 - http://support.microsoft.com/kb/832136
I have not looked into whether Excel 2010 might have a different limit, or has fixed this issue.
The maximum characters for a cell for all these versions are 32K.
Excel specifications and limits:
2003 - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx?CTT=1
2007 - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx?CTT=1
2010 - http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=1
Depending on what kind of data you are dealing with, you can also try to NOT Concatenate Multi-Value Restuls.
This is a checkbox option in the Wizard page to selected attributes. Click on the Question mark for info.
Lee Wei
(imported comment written by Lee Wei)
I just checked the source code.
The Excel Connector 3.1 is correctly allowing all 32K of data for a cell for Excel 2010.
There is a warning for cell over 32767.
I tried going pass 32767. Excel 2010 quietly truncates without any errors, so I am going to leave my own warning in the Wizard.
Lee Wei
(imported comment written by Don65)
The truncation message occured inside the Bigfix query wizard where it lists how many rows were returned. Thought the character limitation may have been invoked by the query wizard.
We were using Excel 2007 - I’ll test Excel 2010 later today.