Import job failed: cannot parse '1' to an System.Int32.

Adrian Ursu

Posted on 15/01/2021 14:58:14

Hi guys,

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

Thank you,

Adrian

Replies

Dmitriy Benyuk

Posted on 15/01/2021 15:04:02

Hi Adrian
it is a known bug and there is already an item to fix that: 89890 Excel Provider: Numeric values not parsed/cast as integer.
As a workaroung try to make your numeric Excel columns as "strings", not numbers.
Kind regards, Dmitrij

Adrian Ursu

Posted on 15/01/2021 15:20:02

Hi Dmitrij,

Thank you for the suggestion. I will try your suggestion until you release the fix.

Thank you,

Adrian

You must be logged in to post in the forum

Developer forum

Import job failed: cannot parse '1' to an System.Int32.

Replies