Odoo Help


This community 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.


Importing Purchase Order from another system

Renato Ferreira
on 4/1/13, 1:05 AM 2,432 views

Hi, I´m trying do import purchase orders from another system to OpenERP v7.0, but, everytime I have a different error. I´m trying to import with this data fields:

Destination Warehouse 
Order Lines/Quantity (I think it´s quantity of the product)
Order Lines/Analytic Account
Order Lines/ Unit Price (I think it´s unit price of the produtct)
Supplier/ External ID (I imported supplier from another system too)
External ID
Product/External ID
Destination (OpenERP requires a destination field, I give 1 value to every line in this field, i tried a lot of values (stock, default, location and many more)
PriceList (OpenERP requires a Pricelist field, I give 1 value to every line in this field)

It doesn´t work. What fields I should I import?

The error message is usually quite clear. May be you should paste your messages here, this will help people answering your question.

Fabien Pinckaers (fp)
on 4/1/13, 5:25 AM

This is the error message I received on validation

No matching record found for name '1' in field 'Destination' at row 2 Get all possible values (821 more)

No matching record found for name '1' in field 'Pricelist' at row 2 Get all possible values (821 more)

Missing required value for the field 'location_id'. This might be 'Destination' in the current model, or a field of the same name in an o2m. at row 2 (626 more)

Avitis - Software Development, Renato Ferreira
on 4/1/13, 1:03 PM
Sandro Regis
On 4/1/13, 11:34 PM

May you can be more productive if you use some ETL tool, if there are too many data.


I never used, wich one you recommend ?

Avitis - Software Development, Renato Ferreira
on 4/3/13, 2:48 AM
Maxime Chambreuil
on 4/5/13, 11:52 PM

Yep! Talend is a good choice.

Sandro Regis
on 4/6/13, 4:50 PM
Maxime Chambreuil
On 4/1/13, 10:38 PM

OpenERP cannot relate the data from your file with the one in OpenERP.

You should export a Purchase Order with the fields you want to import to figure out which data you need to put in your file and how to format it.

I did that, but I don´t need destination and Price List, so, if I don´t import that, OpenERP says this fields are required. If I just copy Destination and Price List from Export file, many other errors with location_id occurs.

Avitis - Software Development, Renato Ferreira
on 4/2/13, 12:12 PM

Can you post the error message when you set the Destination and Price list?

Maxime Chambreuil
on 4/2/13, 10:09 PM

I did again, export a Purchase made on the system, got Destination database Id and Price List databse Id from the export, set that on my import, and receive this message:

"current transaction is aborted, commands ignored until end of transaction block"

I don´t know what can be

Avitis - Software Development, Renato Ferreira
on 4/3/13, 2:32 AM

Can you provide more info from the log ?

Maxime Chambreuil
on 4/5/13, 11:54 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 4/1/13, 1:05 AM
Seen: 2432 times
Last updated: 3/16/15, 8:10 AM