Back to forum list… Back to Issues and Problems...

4.1 - Inconsistency with CSV reader (No replies)

Randy
5 years ago
Randy 5 years ago

I've been having a few issues with the CSV Reader where I will get an error such as "Field in position [45] on line [5] is out of range.", but when I modify the CSV to only have line 5, the CSV reader works fine.

I have another case where IMan will correctly work if I process lines 1-60, but it will break if I process lines 1-61.  When I attempt to process ONLY line 51, IMan works.

Unfortunately, due to the inconsistent errors, it is impossible for me to see which lines of the CSV have the issue -- As soon as I have isolated the CSV line in question, IMan seems to have no issue with it.

 

 

I noticed that the value in question is an HTML blob and has a good amount of double- and single-quotes, but they are all "closed".  Another possibility could be line endings which are present in the data as \r\n.

 

Attached are 3 screenshots:

  • IMan failing when attempting to process CSV rows 1 - 1590
  • IMan succeeding when attempting to process CSV rows 1 - 1526.
  • IMan failing when attempting to process the data from rows 1526 - 1590.
https://www.realisable.co.uk/wp-content/uploads/2019/08/2019-08-05_13-38-37.png
https://www.realisable.co.uk/wp-content/uploads/2019/08/2019-08-05_13-38-36.png
https://www.realisable.co.uk/wp-content/uploads/2019/08/2019-08-05_13-38-32.png

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close