Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
4 Odpowiedzi
4512 Widoki

No matter what I have tried, I can't import a datetime field from an xlsx file in odoo 16.

I go to "Import records", then load an xlsx file and then I press test. I get the following error:   Column payment_date contains incorrect values. Error in line 204: unconverted data remains: 2022-11-21 09:34:46

I've tried with a variety of date time formats (including the one in language settings), but it always concludes to the above error message...

Which is the correct format to import a datetime field from an xlsx file?

Awatar
Odrzuć
Autor Najlepsza odpowiedź

Found the source of the problem and solved it. For people who may encounter the same problem, in my case the problem was that the first rows of the excel file had an empty value for the datetime. When I sorted the excel to bring the rows with datetime values on top, it worked. So, the solution is to sort the excel file to bring first the entries with a value and leave the empty values at the end of the list.

Awatar
Odrzuć
Najlepsza odpowiedź

The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.

Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.

Awatar
Odrzuć
Najlepsza odpowiedź

Hi Panos Anagnostakis,

I think this video can help you: https://www.youtube.com/watch?v=etMYrOJyaiU&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=2 (starting at minute 55 in this video)

Awatar
Odrzuć
Najlepsza odpowiedź

Didn't worked for me

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
1
paź 20
4654
2
gru 23
1905
1
paź 21
3341
8
sty 25
6784
1
kwi 25
1491