ItemExtract reading Excel data incorrectly

Started by Ariphaneus, January 14, 2016, 07:58:50 AM

Previous topic - Next topic

Ariphaneus

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.

td

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.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

td

You may also want to check if your files are in UTF-8 or some other non ANSI character set.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

Ariphaneus

Truncated the CSV to the fields of note and the script started running again.

td

"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade