Developer forum

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

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

Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

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

 
Dynamicweb Employee
Dmitriy Benyuk
Reply

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 Dynamicweb Employee
Adrian Ursu
Reply

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