Passa al contenuto
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
La domanda è stata contrassegnata
importdatetimexlsxodoo16features
4 Risposte
5402 Visualizzazioni
Avatar
Panos Anagnostakis

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?

Avatar
Abbandona
Avatar
Panos Anagnostakis
Autore Risposta migliore

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.

Avatar
Abbandona
Avatar
Tuan Bui VKS
Risposta migliore

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.

Avatar
Abbandona
Avatar
Thuy Ngoc
Risposta migliore

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)

Avatar
Abbandona
Avatar
Max Szajowicz
Risposta migliore

Didn't worked for me

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
How i can upload date data in dd-mm-yyyy H:m format from XLS File
import datetime xlsx
Avatar
Avatar
1
ott 20
5507
Need help importing product variants from an Excel fileroduits dans Odoo 16
import variant xlsx odoo16features
Avatar
Avatar
Avatar
2
dic 23
2572
Import Create and Update Dates Risolto
import datetime
Avatar
Avatar
1
ott 21
3969
Translations in Odoo 16 Online Risolto
import translations odoo16features
Avatar
Avatar
Avatar
Avatar
Avatar
8
ott 25
7925
Multiple Vendor lines after imports Risolto
import xls odoo16features
Avatar
Avatar
1
apr 25
2247