NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Edwin Hannan on March 27, 2016, 02:57:40 PM

Title: Export to Excel and Error
Post by: Edwin Hannan on March 27, 2016, 02:57:40 PM

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

Title: Re: Export to Excel and Error
Post by: kevin plummer on March 28, 2016, 03:27:09 PM

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

Title: Re: Export to Excel and Error
Post by: Bruce on March 29, 2016, 11:23:17 PM

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

Title: Re: Export to Excel and Error
Post by: Edwin Hannan on April 02, 2016, 07:10:18 AM

Hi

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

Many thanks

Ed

Title: Re: Export to Excel and Error
Post by: Edwin Hannan on April 02, 2016, 07:21:53 AM

Hi Bruce

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

Many thanks

Ed

Title: Re: Export to Excel and Error
Post by: Edwin Hannan on April 03, 2016, 08:04:42 AM

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

Title: Re: Export to Excel and Error
Post by: kevin plummer on April 03, 2016, 02:39:08 PM

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.

Title: Re: Export to Excel and Error
Post by: Bruce on April 18, 2016, 01:05:13 AM

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

cheers
Bruce