تخطي للذهاب إلى المحتوى
لقد تم الإبلاغ عن هذا السؤال
3 الردود
719 أدوات العرض
الصورة الرمزية
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

الصورة الرمزية
إهمال
الصورة الرمزية
Thuy Ngoc
أفضل إجابة

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
الكاتب أفضل إجابة

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
أفضل إجابة

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.

الصورة الرمزية
إهمال