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.
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:
- Customers and Suppliers (Partners)
- Product categories
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
|Asked: 3/3/13, 9:21 AM|
|Seen: 1044 times|
|Last updated: 3/16/15, 8:10 AM|