Skip to Content
Dette spørgsmål er blevet anmeldt
importdateexcelodooimporting data from excel file
1 Svar
1140 Visninger
Avatar
Vo Nguyen Phuc Ngan

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')"

Avatar
Kassér
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Bedste svar

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



set custom date as (%d/%m/%Y)


2. Adjust the date format in Odoo to match in Excel

Setting -> Translations->Language

Select your language and change the date format.





Hope it helps

Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
Importing data in Odoo
import odoo importing data from excel file odoo15
Avatar
Avatar
1
maj 25
17192
Import product data from Amazon to Odoo
python import data excel odoo
Avatar
0
maj 24
1016
How to ignore rows?
import excel odoo ignore odoo16features
Avatar
Avatar
1
jan. 24
1219
Odoov13 How to use odoo import excel feature in custom module Løst
import excel sale.order importing data from excel file odooV13
Avatar
Avatar
2
aug. 22
6422
How can I write data from Odoo in an existing Excel file, while maintaining the cells format ?
excel odoo
Avatar
Avatar
2
nov. 16
5690