Skip to Content
This question has been flagged
importdateexcelodooimporting data from excel file
1 Respondre
1037 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
16973
Import product data from Amazon to Odoo
python import data excel odoo
Avatar
0
de maig 24
949
How to ignore rows?
import excel odoo ignore odoo16features
Avatar
Avatar
1
de gen. 24
1143
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
6303
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
5561