Pular para o conteúdo
Esta pergunta foi sinalizada
importdateexcelodooimporting data from excel file
1 Responder
1961 Visualizações
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
Cancelar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Melhor resposta

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
Cancelar
Publicações relacionadas Respostas Visualizações Atividade
Importing data in Odoo
import odoo importing data from excel file odoo15
Avatar
Avatar
1
mai. 25
19471
Import product data from Amazon to Odoo
python import data excel odoo
Avatar
0
mai. 24
1726
How to ignore rows?
import excel odoo ignore odoo16features
Avatar
Avatar
1
jan. 24
2006
Odoov13 How to use odoo import excel feature in custom module Resolvido
import excel sale.order importing data from excel file odooV13
Avatar
Avatar
2
ago. 22
7249
How can I write data from Odoo in an existing Excel file, while maintaining the cells format ?
excel odoo
Avatar
Avatar
2
nov. 16
6589