Import CSV with blank date

Question

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

Thuy Ngoc · 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)

Andy Caignie · 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

Dmytro Iliushko · 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.

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!