This question has been flagged
1 Reply
3240 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

Avatar
Discard
Best Answer

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
Avatar
Discard

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