Skip to Content
This question has been flagged
importdateexcelodooimporting data from excel file
1 Respondre
3107 Vistes
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
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best 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



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
Descartar
Related Posts Respostes Vistes Activitat
Importing data in Odoo
import odoo importing data from excel file odoo15
Avatar
Avatar
1
de maig 25
21192
Import product data from Amazon to Odoo
python import data excel odoo
Avatar
0
de maig 24
2620
How to ignore rows?
import excel odoo ignore odoo16features
Avatar
Avatar
1
de gen. 24
2790
Odoov13 How to use odoo import excel feature in custom module Solved
import excel sale.order importing data from excel file odooV13
Avatar
Avatar
2
d’ag. 22
8385
How can I write data from Odoo in an existing Excel file, while maintaining the cells format ?
excel odoo
Avatar
Avatar
2
de nov. 16
7583