10-09-2009 10:29 AM
I have 2 databases that need to be merged. DB "B" has about 5000 international contacts and needs to be merged into our main database "A" with approximately 15000 contacts. The databases are identical (including same list of record managers, custom opportunity fields, etc) physically - only differing in the contacts involved.
I have tried exporting a lookup of records for which I am the record manager (and I'm admin in both DBs) - failed.
I have tried exporting a lookup of records for which another user is record mananger (changing them to MANAGER in both DBs) - failed.
I have tried exporting ALL CONTACTS - failed.
I need all the records from "B" added to "A" including history, opportunities, activities, etc. while preserving the record manager info (and the create date as well).
10-10-2009 04:10 AM
Can you expand a little on what you mean by "failed". Do you mean nothing was imported, i.e. the import just didn't work, or that it did import but not as you wanted.
One of the issues you may have is that the Record Managers although having the same name in both databases could potentially be "different", unless database B was created by copying database A then exporting the Record Managers from A to B.
10-10-2009 05:33 AM
Try this ACT! Knowledge Base article -
10-12-2009 08:16 AM
I mean "failed" as in nothing is imported. I just again followed every step on the KB link provided and still get nothing. I go through the wizard, it launches a progress bar which sits there blank for about 30 seconds then just disappears.
I have every user (duplicated from the original A database when the B database was created) as a manger in both A & B.
I'm confused honestly by the "Ensure that the Allow Editing option is enable for all fields"...I can't find this anywhere. I have set them to "full access." When it says "remove all duplicate drop-down lists" - does that mean any lists that are the same in database A & B?? That doesn't make sense.
I have tried logging into the database as an administrator and as a specific user (as a manager...trying to export just a single user's accounts).