Export to Excel and Error

[Edwin Hannan]

Hello

The export to Excel does not appear to work for approx 2100 rows in a browse (filtered on Lead Source) but ok with 500 or less for other Lead Sources?

Is there a max limit setting somewhere?

Please advise

Many thanks

Edwin
Clarion 10 v12014, NT9.06, Xfiles 2.79, String Theory 2.43

[kevin plummer]

Is the browser timing out before it can serve up the file?

[Bruce]

I'm not aware of a limit, but if you can send me an example I would be happy to take a look.

Cheers
Bruce

[Edwin Hannan]

Hi

I will experiment with server time out settings and set to a longer period and let you know

Many thanks

Ed

[Edwin Hannan]

Hi Bruce

Still same issue, I will send you an example app / data

Many thanks

Ed

[Edwin Hannan]

Hello

I have found the cause of my issue, the value of 16E in the string Address1, why this should be so is not clear to me.

Chnaging to 16 or 16 E is ok also and I get a successful export xml and opening in Excel

I have other records with a value for Address1 =  97a and this has not caused any export issues.

NOTE: if I amend back to 16E for yhis record then I cannot export to Excel, error ‘Bad Value’ occurs’ ??

I have uploaded a document detailing my testing

Can anyone throw any light on what is going on here?

Many thanks

Edwin
Windows 10, Clarion 10, Nettalk 9.06

[kevin plummer]

It might be some sort of mathematical notation (exponential?) although I typed it into Excel and it accepted the value. You probably need to nominate the field as Text or add '<39>' before the value. So any number followed by E will probably fail.

[Bruce]

thanks for the report.
I have updated xFiles (build 2.80) to take care of this.

cheers
Bruce