Universal Data Exporter ASP Support Product Page

Under investigation

Incorrect data in Excel export

Reported 13 years ago
1
has this problem
13 years ago 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 13 years ago
13 years ago Bart Garner replied:
Sample:
Note OTSKU column on page, then in export
www.otools.ca/excel.asp
Replied 13 years ago
13 years ago 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 13 years ago
13 years ago Bart Garner replied:
Miro has found the issue and is working on it.
Replied 13 years ago
13 years ago Bart Garner replied:
When can we expect a resolution to this issue?
Replied 13 years ago
13 years ago 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 13 years ago
13 years ago Bart Garner replied:
Will this issue EVER be fixed?
Replied 12 years ago
12 years ago christian verdirame replied:
neverending story: bad extension

Reply to this topic