Impossible to import datetime field from xlsx file in odoo v16

Question

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 fie

Panos Anagnostakis · Accepted Answer

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.

Tuan Bui VKS · Answer

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.

Thuy Ngoc · Answer

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)

Max Szajowicz · Answer

Didn't worked for me

관련 게시물	답글	화면
How i can upload date data in dd-mm-yyyy H:m format from XLS File import datetime xlsx	1 10월 20	5549
Need help importing product variants from an Excel fileroduits dans Odoo 16 import variant xlsx odoo16features	2 12월 23	2601
Import Create and Update Dates 해결 완료 import datetime	1 10월 21	4004
Translations in Odoo 16 Online 해결 완료 import translations odoo16features	8 10월 25	7996
Multiple Vendor lines after imports 해결 완료 import xls odoo16features	1 4월 25	2291

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!