Skip to Content
This question has been flagged
3 Replies
694 Views
Avatar
Andy Caignie

I have created a table with some date fields, and I want to import data from our legacy ERP.

One of the fields, 'date finished', is not always filled in, so there is an empty field in the csv.

When I try to import the CSV I get the error:

Column dateFinished contains incorrect values. Error in line 3: time data '' does not match format '%d/%m/%Y'

How can I solve this please? The ODOO version is 17.

Regards,

Andy

Avatar
Discard
Avatar
Thuy Ngoc
Best Answer

Hi Andy,

I think this video can help you https://www.youtube.com/watch?v=Auaqj6WtdcM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=5 (starting at 51:40 in this video)

Avatar
Discard
Avatar
Andy Caignie
Author Best Answer

Hi Dmytro,

Splitting the files might do the trick. I will have to check how many files there will be, as there are other dates in the import that might be empty too.

Thx for your help

Andy

Avatar
Discard
Avatar
Dmytro Iliushko
Best Answer

Hi Andy,

As I know it is not possible, to import lines with empty date field in part of them. Possible solution can be importing the lines twice. So first time you import only lines which have the date finished field filled, and the second time you import only those, which are don't have this field field and you don't import this column. Or you can fill this lines in your legacy ERP and then import everything in one time. 
I hope this will be helpful for you.

Avatar
Discard