The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Groups and Excel - error
Posted: 10 Apr 07 1:33 PM
|
Hi... Is this a known issue or limitation of SLX v7?
A customer of ours created a group... when trying to export the group to excel, they got this error:
"Error exporting group in ExportCurrentGroupToExcel function:
Either BOF or EOF is True, or the current record has been deleted. ….."
Turns out the problem was a condition in the group that looked for a value "in" a list… if the list had more than 6 values in it, the error occurs when you try to export the group to Excel. Our customer's list had 7 items. I changed the query to have one condition for 6 of the values, and another condition that looked for the 7th value. That worked.
Anyone else have this problem?
|
|
|
|
Re: Groups and Excel - error
Posted: 11 Apr 07 6:30 AM
|
99% of the times I've seen export to excel fail was because of something bad in the actual data of a particular record (or records) in the group.. Never because of the actual query.
--
rjl |
|
|
|
Re: Groups and Excel - error
Posted: 31 May 07 10:26 AM
|
| Question on this issue -- any idea why you can see data in the group and but then when we get the error in exporting to excel blame it on bad data. Either way, we employ this work around. Make a copy of the offending group and then we are able to export. Unfortunately though this is not a solution. Any other thoughts? |
|
|
|
Re: Groups and Excel - error
Posted: 01 Jun 07 10:23 PM
|
I've seen where there was some bad data in a record that caused export problems.. typically a NULL.
You just have to track it down and fix the data in SalesLogix.
--
rjl |
|
|
|
Re: Groups and Excel - error
Posted: 13 Sep 07 2:17 PM
|
Forgive me for being ignorrant in SalesLogix. I'm interested in what you mean by NULL. I know that NULL typically means no value there or whatever so I'm more wondering what values, if left NULL, would cause an issue with SalesLogix.
Thanks |
|
|
|
Re: Groups and Excel - error
Posted: 13 Sep 07 5:03 PM
|
Typically rows that required formatting, but this could be a script bug as well....
Lets say for instance that I have the following variable assignment:
Dim x
x = arec("FIELDNAME").Value
Alternatively, I could do the following if I knew FIELDNAME is a string:
x = arec("FIELDNAME").Value & ""
Assuming that the value of FIELDNAME is NULL, on the first case x isn't a string and if you try to use it as a string you will get errors.
On the second case, x will get defaulted to a blank string due to the fact taht I added that concatenation which allowed the variable to be defined regardless of the NULLon the recordset field.
Now, I am not saying this is the specific issue, but if you know the exact set of records that are making the export group fail you could debug your system and try and figure out why it fails and potential work arounds. |
|
|
|