4.24 - Excel Reader "Mapping Style By Field Heading" still not working (1 reply)
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.
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.