Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
Hello, In our office we are ready to Go live with openerp7, Production server is created and openerp7 is installed now first thing to know database is completely fresh in Production Server,Now we have data of last 2 years which includes customers,vendors,suppliers and their invoices old data for e.g 20 customers 10 suppliers 100 invoices overall in "Excel Sheet" like all the necessary data for company to maintain accounts and history.Now I want all of them to be uploaded in Production Server Database(import export functionality or whatever is possible) and then we will start our new journey with Openerp7.
Help me in it. Thank You.
From web client, you have a drop-down menu in the top of the form. There you have the options Import and Export, which can import data from or export data to CSV format files. I suggest you to create an "example" record (one customer, one vendor, etc), export this record to a CSV file and then open the file with Excel.
This is the fastest way I know to get the tables structure into Excel. There you can paste your Customer, Vendor, Suppliers, etc, list, save the file (which will be saved in CSV format) and finally import into OpenERP from web client.
Check if users can import data from CSV files in Configuration module. If not, check this option to TRUE.
Hope this could help. Regards
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 platform 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 11/29/13, 8:16 AM|
|Seen: 1098 times|
|Last updated: 3/16/15, 8:10 AM|