Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
3 Odpowiedzi
718 Widoki
Awatar
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

Awatar
Odrzuć
Awatar
Thuy Ngoc
Najlepsza odpowiedź

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)

Awatar
Odrzuć
Awatar
Andy Caignie
Autor Najlepsza odpowiedź

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

Awatar
Odrzuć
Awatar
Dmytro Iliushko
Najlepsza odpowiedź

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.

Awatar
Odrzuć