Developer forum

Forum » Integration » Handling of empty decimal

Handling of empty decimal

E-mail notifications
Justin Sjouw Dynamicweb Employee
Justin Sjouw
Reply
Posted on 27/07/2023 09:46:31

Hello,

Similar to https://doc.dynamicweb.com/forum?ThreadID=88520&PID=1605 I need to handle decimals with a CSV or Excel source and DynamicWeb and Ecom provider.

I now have an error handling an empty value in a CSV, what is the preffered way to handle this?

Job Failed with the following message: Cannot parse '' to a double. Table: EcomProducts. Column: Bebat The failed input row is: [BEBAT:""], [Country invoice:""], [Country origin:""], [Country supplier:""], [Product name EN:""], [Productcode:"AGC 1010"]

Thanks,

Justin


Replies

 
Rasmus Sanggaard Dynamicweb Employee
Rasmus Sanggaard
Posted on 28/07/2023 13:59:55
Reply
This post has been marked as an answer

Hi Justin,

We are actually already working on a solution on how to work with decimals and different cultures for DW10, I believe that would also fix this. I have added the need to merge it down to DW9 as well, if possible.

BR Rasmus

Votes for this answer: 1

 

You must be logged in to post in the forum