تخطي للذهاب إلى المحتوى
لقد تم الإبلاغ عن هذا السؤال
importdatabasev7live
1 الرد
4938 أدوات العرض
الصورة الرمزية
umer farooq

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.

الصورة الرمزية
إهمال
الصورة الرمزية
miguel alonso
أفضل إجابة

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

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

Thanks Miguel Alonso for your response,I export 5,6 demo customers and I got the CSV file then I had a fresh database without any data prior in it and i tried to import CSV there and got this

umer farooq
الكاتب

No matching record found for external id '__export__.res_partner_45_199' in field 'Account Payable' between rows 2 and 3

miguel alonso

please check the financial fields. when creating "master" records (mainly customers, vendors items) the financial fields must be set up, because when the user post the first invoice, openERP will save the corresponding accounting journal automatically.

Ray Carnes

Fix this bug ( https://bugs.launchpad.net/openobject-server/+bug/1194893 ), then export again. It appears like the External ID OpenERP is generating is not valid because of this bug.

Ray Carnes

Patch this bug ( https://bugs.launchpad.net/openobject-server/+bug/1194893 ) and try a new export. You should get External ID's that actually match the accounts you have instead of the ones you are getting.

umer farooq
الكاتب

ray carnes thanks but I don't know how to patch it and what to do with it:s

Ray Carnes

You need to change the file openerp/osv/orm.py - there are three changes to make, based on what is shown when you click the line "Diff: 44 lines (+6/-5) 2 files modified". You don't have to worry about the changes to openerp/tests/addons/test_impex/tests/test_export.py. Once you have edited the files, restart the server. If you have used bzr to access the source code, you can download the changes as a DIFF file and use the command "bzr patch" to apply the changes.

المنشورات ذات الصلة الردود أدوات العرض النشاط
How to Restore Database from ancient server
import database v7
الصورة الرمزية
الصورة الرمزية
1
مارس 15
8446
How to select a different database on login screen تم الحل
database v7
الصورة الرمزية
4
يوليو 24
33918
How to import multiple lines text fields with CSV ? تم الحل
import v7
الصورة الرمزية
الصورة الرمزية
الصورة الرمزية
الصورة الرمزية
الصورة الرمزية
5
سبتمبر 25
24970
Database import and odoo start
import database
الصورة الرمزية
الصورة الرمزية
2
أغسطس 18
11266
How to import an existing chart of accounts?
import v7
الصورة الرمزية
الصورة الرمزية
2
يوليو 16
13883