Odoo Help

Welcome!

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.

0

Open ERP 7.0 : Order of Importing and mandatory fields

By
Sudheendra Walvekar
on 3/3/13, 9:21 AM 1,047 views

Dear all,

I have setup openERP 7.0 and have created the company. Now, I would like to import fresh data into the openERP system. It would be of great help if any one can inform, in what order I should import the data into openERP. I need to import following data into the system. 1. Customers,2. Leads, products and product category 3. Taxes,4.Suppliers.

Also, please inform the mandatory fields that should be not be null for each of the imports.

Regards

0

Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
5823
| 7 7 8
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo USA

Fabrice Henrion (fhe)
On 3/3/13, 3:08 PM

This is a question that can become very complicated as the number of objects you want to import increases. The order of import has to do with the objects associations: the most independent an object is, the earlier it will be imported. Essentially, you can only become good at importing csv data (or even through scripts) by knowing the tables structure (PgAdmin will help you visualize this).

In your example, my suggestion will be to import in the following order:

  1. Taxes
  2. Customers and Suppliers (Partners)
  3. Product categories
  4. Products
  5. Leads

As you are migrating from another system, I guess you also need to import your chart of accounts, so you will need to import it first...

Mario Arias Badila
on 3/5/13, 2:35 AM

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

0 follower(s)

Stats

Asked: 3/3/13, 9:21 AM
Seen: 1047 times
Last updated: 3/16/15, 8:10 AM