Morning.
I am getting errors on values that I am trying to import, and not sure why, as they seem correct. This is the error:
Import job failed: cannot parse '1753-01-01' to a System.DateTime. Table: EcomProducts. Column: stock2Date The failed input row is: [ProductID:"250"], [ProductNumber:"25080"], [ProductVariantID:""], [ProductName:"Inlay Outline"], [ProductStock:"86"], [productType2:"Inlay"], [Highlight:"False"], [ViewOnWeb:"True"], [ViewInShop:"True"], [NOS:"False"], [GroupID:"GROUPINLAY"], [ProductVariantCounter:"8"], [stock2:"0"], [stock2Date:"1753-01-01"], [stock3:"0"], [stock3Date:"1753-01-01"], [stock4:"0"], [stock4Date:"1753-01-01"], [stock5:"0"], [stock5Date:"1753-01-01"], [stock6:"0"], [stock6Date:"1753-01-01"], [stock7:"0"], [stock7Date:"1753-01-01"], [stock8:"0"], [stock8Date:"1753-01-01"]
I have also got the error " cannot parse '0' to a System.Int32" previously. Looking at the row printed, it seems also that all the fieds are mapped as string, and they are not, but this might just be the way the output was formatted. Any ideias on how to get around this?
On a related topic, how do I set values to null on Data Import? I have tried using the Nullable<> types, but it does not work.
Thanks.
Marco.