I am constantly having issues with Data Integration jobs where I use Excel as input.
No matter if I use Dynamicweb Provider or EcomProvider, the columns that are supposed to be identified as Int, are mapped in the job as Double and the import job fails.
The workaround is to always edit manually the job XML but it becomes pretty annoying to having to do that especially when an admin user has to do it and we don't want to encourage them to mess with the XML job definitions.
Is there something wrong with my files? Should I prepare them differently? Or is it a problem in the mapping logic?
I am using DW 9.9.5