V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y'

Question

When importing any excel file with a date I get this error. locale is es_ES although en_US is also installed (cannot be unistalled). In the file the date is displayed as 31/01/2025 and formatted as date. The fact thar it shows 2025-01-31 tells me that in first instance Odoo ir correctly interpreting the date but in the process of importing is looking for a different format.
Even tried importing a freshly exported file right from odoo...

Only workwaround i´ve found is to import using CSV, but ne

Asis · Answer

I meant in the Odoo import dialog:
imagen [1]

imagen [2]

[1] /web/image/63176715-85111be3/imagen.png?access_token=06c68e7d-aef7-4863-ae21-478d1f4c84f7
[2] /web/image/63176714-90beef92/imagen.png?access_token=86493e67-b146-4023-9350-5722b3c0307d

Ray Carnes (ray) · Answer

>>
The fact that it shows 2025-01-31 tells me that in first instance Odoo is correctly interpreting the date

Are you sure Odoo isn't just showing you what is stored in the field?
What is shown when you click the Formula Bar?
image [1]
(example to show how Excel can display and store two different values)

Try either of these two options:
A column with no format containing and displaying *31/01/2025*
A column with the following format containing and displaying *31/01/2025*
* image [2] *

[1] /w

Post Terkait	Replies	Tampilan
Odoo journal entry modification after posting by import importing	1 Apr 25	741
Import mehrerer Artikel mit Varianten importing	0 Okt 24	746
Importing Excel/CSV using custom unique field instead of XML ID importing	2 Mei 24	3119
Product export then import duplicates everything importing	0 Apr 24	919
Import Employees ? importing	2 Jul 23	1647

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!