Is there a quick way to migrate my pertinent data (inventory items and categories, partners, and chart of accounts) so that I can get this to work?
I do not want to just copy the database in its entirety as something is blocking me (perhaps a document module) from properly emailing.
I ask because, I cannot get email function to work from quotations and rfqs (asked in other post here yesterday) and however can get it to work in parallel database with sample data.
My error I have found in many relevant postings (here, the old forum and on launchpad) and it appears that no one sees it as an issue.
For me it makes the system unusable. I can print and then attach pdf's in my current ERP system, but I am trying to get the efficiency of faster communication with OpenERP. (now old erp and openerp function the same with only printing available)
Export each Page of Vendors Customers Inventory Product Categories Chart of Accounts (not really needed if nothing custom added)
Then Create New Database and first Assign Full set of Modules Required (compare to original even if it is disfunctioning)
then in New, also Define Chart of Accounts then Duplicate Customer Tags then Import Customers (Tags and Category ID's.. use only one: Tags are better but perhaps Category ID's will work) It is likely you will have too many fields in your export set and you will need to remove unused ones. Spend some time on getting this right then Import Vendors then Import Product Categories then Import Products
(Before you do these imports you can clean your data somewhat. I was able to get Tags and Product Categories (base on the export ids) to work which really improved on my previous data set.
Finally, test your system. Make sure the bug you had/may have had is not again showing. Mine was not evident (Yes!) I could email a Quotation.
If you have the ability to do "in situ" Snapshots along the way I highly recommend it. In the process above I had at least 2 Snapshot Restores when one course of import or another course of attempted short cut failed.
In the end the recommendations given about building a New Database were the best ones. It is possible to get the data out and over when the old Database is not functioning right (at least it was for me).
Nothing quick, but it gives good foundation. Each time working with export and import sets more of the process and codes makes sense. I also recommend having a browse of the data as you go with Built in Postgres or a other Data Browser like Navicat.
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: 2/28/13, 11:00 AM|
|Seen: 1300 times|
|Last updated: 3/16/15, 8:10 AM|