تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
2 الردود
7321 أدوات العرض

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.

الكاتب

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)

أفضل إجابة

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

Regards,

الصورة الرمزية
إهمال
الكاتب

I never used, wich one you recommend ?

Yep! Talend is a good choice.

أفضل إجابة

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.

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

الكاتب

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

Can you provide more info from the log ?

المنشورات ذات الصلة الردود أدوات العرض النشاط
1
نوفمبر 24
1528
4
نوفمبر 18
8137
0
مارس 15
4129
1
مارس 15
4270
1
يوليو 24
1620