Skip to Content
Menu
This question has been flagged
1 Reply
7641 Views

I'm currently migrating datas from my old OpenERP V5 to a new fresh install of OpenERP V7. I'm exporting CSV data from V5 and importing to V7. Working fine for partners, products, orders, except invoices. It seems not possible to import new invoices. It works only when exporting and importing already existing invoices. It seems there's no "number" field for import.

This file work (invoice with external ID "__export__.account_invoice_1" allready existing) :


id,payment_term/id,date_due,date_invoice,name,currency_id/id,origin,note1,period_id,comment,invoice_line/product_id/id,invoice_line/name,invoice_line/origin,invoice_line/price_unit,invoice_line/quantity,invoice_line/discount,invoice_line/sequence,invoice_line/invoice_line_tax_id,supplier_invoice_number,partner_id/id,note2,company_id/id,user_id/id __export__.account_invoice_1,__export__.account_payment_term_7,2013-12-30,2013-12-30,,base.EUR,,,12/2013,,__export__.product_product_75,My product A,,631.66,1.0,,,19.6,,__export__.res_partner_1055,,base.main_company,base.user_root ,,,,,,,,,,__export__.product_product_75,My product A,,347.59,1.0,,,19.6,,,,, ,,,,,,,,,,__export__.product_product_52,My product B,,45.0,1.0,,,19.6,,,,, ,,,,,,,,,,__export__.product_product_4,My product C,,,1.0,,,19.6,,,,,


If I change id field from "__export__.account_invoice_1" to "__export__.account_invoice_2" (wich doesn't exists) in the csv file, it drive me to "'NoneType' object has no attribute 'group'" error.

Is there another way to import invoices ? Is there a way to bulk create invoices in OpenERP V7 ?

Avatar
Discard
Best Answer

I always import invoices with Python scripts that update the OpenERP database with xmlrpc. You can find further information here:

https://doc.openerp.com/6.0/de/developer/6_22_XML-RPC_web_services/

Avatar
Discard
Author

Thank you so much. I will try this. It will be more difficult than I think in first time. I will do a php script using this class https://github.com/tejastank/openerp-php-connector

Related Posts Replies Views Activity
3
Dec 19
8524
3
Jun 20
3835
1
Apr 19
2025
1
Nov 18
9352
11
Feb 17
63636