Universal Data Exporter ASP Support Product Page

Under investigation

Incorrect data in Excel export

Reported 20 Apr 2011 18:56:00
1
has this problem
20 Apr 2011 18:56:00 Bart Garner posted:
I have a column that is reporting the wrong data.
I checked the field types and the field in question was set to Number, whicn should be fine, because it is indeed a number.

I noticed that other similar fields were set to Text and they work fine. I do not do any math on this field so I opted to change it to Text and I get the same results.

The column is called OTSKU

The ASP page shows the correct numbers - first row 8155500
The Excel spreadsheet shows - 6174900

The data is similarly wrong for all 326 records.

This is a production issue. A prompt reply would be much appreciated.

Replies

Replied 26 Apr 2011 14:29:21
26 Apr 2011 14:29:21 Bart Garner replied:
Sample:
Note OTSKU column on page, then in export
www.otools.ca/excel.asp
Replied 27 Apr 2011 12:31:11
27 Apr 2011 12:31:11 Andreas Knapp replied:
Hi. I checked this also on my site with database on a telephon-number field as string. And it did also the conversion. Maybe a error in the ExcelWriter.asp on the integer oder number function. Whatever... must be urgent corrected !
Replied 27 Apr 2011 16:56:10
27 Apr 2011 16:56:10 Bart Garner replied:
Miro has found the issue and is working on it.
Replied 26 May 2011 01:21:47
26 May 2011 01:21:47 Bart Garner replied:
When can we expect a resolution to this issue?
Replied 17 Jun 2011 20:53:19
17 Jun 2011 20:53:19 shaun anderson replied:
I've had the same error, (error converting CLng was line 890 or something) the function is to check a number even though in my case they are all defined as text fields, have reverted to version 1.12 and all works fine...
Replied 26 Aug 2011 03:22:38
26 Aug 2011 03:22:38 Bart Garner replied:
Will this issue EVER be fixed?
Replied 12 May 2012 07:44:50
12 May 2012 07:44:50 christian verdirame replied:
neverending story: bad extension

Reply to this topic