CSV import line error Enterprise 16

Question

When I try to import a invoice CSV I get "Server error price_unit", or "Server error quantity", the error is with first float field from line
Same file can be importe ok v15 community, but get error in v16 Enterprise, I have tried two different databases (just
editing
external id from product)

The CSV file is
"id","name","invoice_date","invoice_date_due","amount_total","invoice_line_ids/price_unit","invoice_line_ids/quantity","invoice_line_ids/product_id/id","invoice_line_ids/amount_currency"
"

Niyas Raphy (Walnut Software Solutions) · Accepted Answer

Hi,
Are you using Odoo saas 16.1 ? If yes, there is an issue with relational field import and it has been fixed already.
Hope the source code will updated soon in the odoo online db's.

FIX:  https://github.com/odoo/odoo/commit/871690afdc2ce4da2770a144cc4fc5ed038e6f73 [1]

Thanks

[1] https://github.com/odoo/odoo/commit/871690afdc2ce4da2770a144cc4fc5ed038e6f73

Peter Groft · Answer

To repair a corrupt CSV file, you need to make sure it's saved with UTF-8 encoding. You might also need to remove special characters like semicolons and commas that are causing data cells to be wrongfully split in two.
Regards,
Peter

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
File for import with commas in names [Odoo 17] import CSV Odoo17	1 elok. 24	1938
Importing supplier invoice with multiple invoice lines import supplier invoice.line	5 toukok. 17	15758
Issue with import and comma in Excel File (odoo 19) import	0 syysk. 25	234
Importacion de Atributos y Valores import	2 toukok. 25	2204
Import from Winbooks Ratkaistu import	4 toukok. 25	6524

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!