Dear all,
It makes now almost a week that I am trying to export data from one OE7 database to import it in another one. Here's my problem (I do not want to restore a Postgresql database):
- I am using OpenERP Version 7.0-20140620-231150
- I created a database, lets call it DB1, with the following Apps installed
- Project Management (which also installs the Social Network app)
- Accounting and Finance
- Sales Management
- Employee Directory
- Timesheets
- Address Book
- However, the people for whom I am installing the database don't need all this, they only need
- Project Management (which automatically installs the Social Network app)
- Employee Directory
- Address Book
- So I created a new database, lets call it DB2, with only the 3 needed apps mentioned above
- And I thought about exporting from DB1, say the Users, and importing them in DB2
- However there always seems to be a bug at import, on the lines of: "No matching record found for external id '__export__.mail_alias_139' in field 'Alias' between rows 3 and 4"
- So I first tried to tackle each of the "issues" OE7 seems to find at import
- I spent almost an entire day doing it, diligently, until I realised that only a few columns remained but OE7 was still not happy.
- I thought that as there were more Apps in DB1, DB2 could not import the data generated in DB1 and that I was stuck with all those unwanted Apps.
- So I thought about doing the export process the other way around (DB2 to DB2):
- by creating only one user in DB2 (apart from the administrator),
- exporting the data in CSV,
- erasing the user and
- reimport it in DB2,
- but oddly enough, OE7 is creating the same kind of messages as in the original DB1 to DB2 imports...
Could anyone tell me what is going on? If the DB1 to DB2 transaction does not work, it is imaginable because the installed Apps are not the same. But come on, from DB2 to DB2, that should work...
What are the fields needed if I want to have say the following items (for the moment only Settings -> Users):
- Preferences tab
- Picture
- Name
- Login
- Company
- Active
- Language
- Timezone
- Signature
- Access Rights tab
- Sales
- Project
- Human Resources
- Sharing
- Administration
- Contact Creation
I would like to do the same with the Projects and the Human Resources Apps (the show the same kind of issues as the Users Export-Import in Settings).
Thanks in advance for any advice/help,
Peter
++++
I cannot remember it's name off-hand, but there is a special data table dedicated to correlating external IDs to internal IDs. If you have not addressed the problems of having that match up correctly you will fail at this. My understanding however, is that attempting to bypass the ORM layer and go directly to the database will involve you in an endless tangle of problems. The "safe" route in is via XMLRPC.