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

4.24 - Excel Reader "Mapping Style By Field Heading" still not working (1 reply)

Randy
3 years ago
Randy 3 years ago

We are still having issues with the Excel reader where the mapping style of "By Field Heading" is not picking up columns by field headings.  It has repeatedly wiped out product data whenever the spreadsheet is modified.  This happens if you run the job via schedule without first confirming that the fields match.

The issue is that IMan ALWAYS uses the position (1, 2, 3, etc) and not the field heading ("sku", "name", "description", etc).

If you have columns, A, B, D, and you add a column C between B and D, when IMan is building the dataset it will attempt to put the data from C into D because D was the third column the last time the job was opened.

 

This is high priority for us as it has destroyed the product data for a few production sites.

Support
3 years ago
Support 3 years ago

Randy, the Excel (and indeed the CSV) readers both expect the fields to be in the same order as they were when you're working in the designer.

If the fields are moved around neither the Excel nor the CSV reader will detect this and indeed there may be corruption.

If the fields are moved, you need to open the Reader in the designer, press Refresh, and the field positioning will be updated.

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