Skip ke Konten
Pertanyaan ini telah diberikan tanda
importinvoice.lineCSV
2 Replies
2365 Tampilan
Avatar
Alfonso Gonzalez

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"
"","nueva_v2","2023-03-12","2023-03-12",30.0,30.0,10.0,"__export__.product_product_10_803b28e0",300.0

Avatar
Buang
Avatar
Niyas Raphy (Walnut Software Solutions)
Jawaban Terbai

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


Thanks

Avatar
Buang
Alfonso Gonzalez
Penulis

Yes I use ODOO saas I suppose is last version, thanks

Avatar
Peter Groft
Jawaban Terbai

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

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
File for import with commas in names [Odoo 17]
import CSV Odoo17
Avatar
Avatar
1
Agu 24
1461
Importing supplier invoice with multiple invoice lines
import supplier invoice.line
Avatar
Avatar
Avatar
Avatar
Avatar
5
Mei 17
15032
Importacion de Atributos y Valores
import
Avatar
Avatar
Avatar
2
Mei 25
1313
Import from Winbooks Diselesaikan
import
Avatar
Avatar
Avatar
Avatar
Avatar
4
Mei 25
5000
can i import journal entries from Excel
import
Avatar
Avatar
1
Agu 24
2309