Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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
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)
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
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.
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
