Error format fate when import data from Excel

Question

I have data from excel as follows, in the "Used date" column in excel I have the value "01/01/1995" but when importing to Odoo, Odoo reads it as 1995-01-01 so when I click "Test" I get the error "time data '1995-01-01' does not match format '%d/%m/%Y')"

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
This error happens because Odoo is trying to parse
the date using the format you specified (%d/%m/%Y), but the actual date
in the file is already in the format YYYY-MM-DD (1995-01-01), which
doesn't match.
solution:
1. Adjust the date format in Excel to match odoo import format
Select the date column in Excel. Format -> Number -> Custom date and time
Image [1]

set custom date as (%d/%m/%Y)
Image [2]

2. Adjust the date format in Odoo to match in Excel
Setting -> Translations->Language
Sele

İlgili Gönderiler	Cevaplar	Görünümler
Importing data in Odoo import odoo importing data from excel file odoo15	1 May 25	21191
Import product data from Amazon to Odoo python import data excel odoo	0 May 24	2620
How to ignore rows? import excel odoo ignore odoo16features	1 Oca 24	2785
Odoov13 How to use odoo import excel feature in custom module Çözüldü import excel sale.order importing data from excel file odooV13	2 Ağu 22	8384
How can I write data from Odoo in an existing Excel file, while maintaining the cells format ? excel odoo	2 Kas 16	7580

Bu soru işaretlendi

Tartışma hoşunuza mı gidiyor? Sadece okumakla kalmayın, katılın!