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

Read File CSV - won't read all records (5 replies)

Sue Herrmannn
6 years ago
Sue Herrmannn 6 years ago

Hi, Guys,

I have a csv file with 68 records in it, one header record. For some reason, when I tell Iman v3.2 to read the file (Refreshing inside the Read File event), it reads records 1-3, then skips down and reads records 65-68. I opened the csv file with notepad++ and I don't see any special characters or anything "weird" about the formatting. I also did a reboot and verified the job wasn't hung  - no luck.

I thought maybe it was just an issue with the preview, but when I run the job, it only processes the 6 records or so that it reads. I've attached the csv file and snapshots of the csv read file event. 

Help? 

https://www.realisable.co.uk/wp-content/uploads/2018/03/read-file-settings2.jpg
https://www.realisable.co.uk/wp-content/uploads/2018/03/Iman-csv-records-read.jpg
https://www.realisable.co.uk/wp-content/uploads/2018/03/read-file-settings.jpg
Support
6 years ago
Support 6 years ago

Sue, can you please attached the file?

Sue Herrmannn
6 years ago
Sue Herrmannn 6 years ago

Sorry - I thought I did. Here you go! =)

Sue Herrmannn
6 years ago
Sue Herrmannn 6 years ago

Okay, so it didn't like the csv file type - I zipped it for you... 

Support
6 years ago
Support 6 years ago

Have the same issue and are investigating.

We try and turn this around for either this afternoon, or your Monday morning.

Thanks

Support
6 years ago
Support 6 years ago

We've sending you a patch and some instructions separately.

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