WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: Ariphaneus on January 14, 2016, 07:58:50 AM

Title: ItemExtract reading Excel data incorrectly
Post by: Ariphaneus on January 14, 2016, 07:58:50 AM
I have a script that I inherited that pulls data from an Excel csv file to generate tickets in a ticketing system.  It then produces the results in a second csv file.  This was running great on a 2003 x86 server however we now moved it to a server 2012r2 x64.  What we are seeing is that it will return some results fine - generating the ticket with the three specified fields and then reporting ticket number and the fields correctly.  However for about half of them it will report the cell value for the row minus one and/or not reporting the ticket number correctly.  The version is 2008b x32.
Title: Re: ItemExtract reading Excel data incorrectly
Post by: td on January 14, 2016, 08:25:30 AM
While your version of WinBatch is not officially supported on Windows 2012 R2, that does not appear to be the problem here.  There isn't enough information here to tell you what the problem is but superficially it has the appearance of some kind of integer overflow issue.  You may want to look for changes in the representation of your input data that might cause an integer overflow.
Title: Re: ItemExtract reading Excel data incorrectly
Post by: td on January 14, 2016, 10:44:54 AM
You may also want to check if your files are in UTF-8 or some other non ANSI character set.
Title: Re: ItemExtract reading Excel data incorrectly
Post by: Ariphaneus on January 15, 2016, 12:11:17 PM
Truncated the CSV to the fields of note and the script started running again.
Title: Re: ItemExtract reading Excel data incorrectly
Post by: td on January 15, 2016, 02:33:56 PM
gigo...