Updating Related Records

Hi Annie,

You can Export and Import Accounts and Contacts, but Emails are somewhat problematic.  I believe the relationship between the Account and Contact isn't maintained since the ID for the record is unique and the Account Import will create a new ID since it isn't already there.  The folks that are more familiar with the internals will be able to confirm that.  As you know, Emails can be exported, but there isn't an Import function for that module.  Again the relationship may not be maintained.

The Sugar folks can clone your installation if you're in the on-demand environment and you can do that if you're on-site.  You'll just need to sort out the licensing. 

 FYI: I also have separate "companies" but instead of making new Account and Contact Modules I've kept everything together and keep things separated by using custom fields and Teams (and some roles).  My "Company Code", "Sales Territory Code" Roles and Teams allows the separation.  Yes, I have duplicate Account Names and Contact Names for "shared" accounts and contacts, and the Emails are related to both (or all three) when the email address is the same.

Best wishes...

Hi Annie Kielian,

As Bud touches on, there is no direct way to migrate relationships from one module to another in Sugar. My recommendation is that this would be best achieved by taking a backup of the database and building out the set of SQL queries needed to move the desired relationships over to their corresponding records in your new module. Once you have the SQL queries prepared and tested, you would then provide those queries to Sugar Support to run against the database to complete the migration.

Chris

I am curious as to why you chose to duplicate the Accounts record instead of adding a qualifier to the Accounts record to distinguish the various divisions of your company, or leveraging Teams to segment the Accounts between divisions and segment the visibility of the Accounts.

FrancescaS