viewpoint-particle

Author Topic: ItemExtract reading Excel data incorrectly  (Read 2042 times)

Ariphaneus

  • Newbie
  • *
  • Posts: 2
ItemExtract reading Excel data incorrectly
« 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.

td

  • Tech Support
  • *****
  • Posts: 3139
    • WinBatch
Re: ItemExtract reading Excel data incorrectly
« Reply #1 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.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

td

  • Tech Support
  • *****
  • Posts: 3139
    • WinBatch
Re: ItemExtract reading Excel data incorrectly
« Reply #2 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.
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade

Ariphaneus

  • Newbie
  • *
  • Posts: 2
Re: ItemExtract reading Excel data incorrectly
« Reply #3 on: January 15, 2016, 12:11:17 pm »
Truncated the CSV to the fields of note and the script started running again.

td

  • Tech Support
  • *****
  • Posts: 3139
    • WinBatch
Re: ItemExtract reading Excel data incorrectly
« Reply #4 on: January 15, 2016, 02:33:56 pm »
gigo...
"No one who sees a peregrine falcon fly can ever forget the beauty and thrill of that flight."
  - Dr. Tom Cade