Odoo Help


Import problem with purchase ID (external id)

on 6/4/13, 10:07 AM 1,830 views

Hello, I'm working on the importation of purchases in a a CSV file. And, I have a big issue with the id.When I try to create new purchases, I create for all my purchase a unique id. But, OpenERP doesn't want of my new ID, they have to exist already. I have more than 6000 row to en enter and I don't have super-power. So How I can force openERP to accept my new ID.

Other problem, I can't find the collumn state. I don't know if it's important but I'm wondering to forget siomething. It has so many things to thinks. Did Y ou have some file samples of complete purchase (invoice, picking, voucher)?

Same problem for purchase order line id and invoice id. I add the collums used: order_line/product_id/id, id, date_order, partner_ref, partner_id/id, frais, fraistva, tva, invoice_ids/id, order_line/price_unit, order_line/product_qty, order_line/id.

on 6/4/13, 11:21 AM

are you trying to use the openerp import option, or are you making a script?

on 6/4/13, 5:11 PM

I use the openERP import tool.

on 6/5/13, 5:08 AM

I remember from another post regarding this issue, that you can specify that openERP should continue if an error occurs. But I refer to use scripts, than I know for sure everything is imported.

on 6/5/13, 5:29 PM

What kind of script? For explain, my method I imported all the purchase of my company in CSV. After, I transformed my CSV to adapt the data to openERP. After I try to use the openERP import tool but the collumn that I call ID (and it is called id on an export CSV that I take on openERP) is transformed in external ID.

on 6/6/13, 5:10 AM
On 6/5/13, 12:51 PM

Any help, please.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 6/4/13, 10:07 AM
Seen: 1830 times
Last updated: 3/16/15, 8:10 AM