Link to home
Start Free TrialLog in
Avatar of choldsworth
choldsworth

asked on

Migrating Salesforce data to CRM 4

I've been working on a migration from Salesforce to CRM4 for the last few days and have run into a problem with contact lookups.  Some background:

- I am not able to use the API to do a migration using a tool like CRMMigrate (due to our Salesforce version), nor does our company want to spend the money on CRMMigrate.
- I've been using the CRM Data Migration Tool, as well as the Advanced Map Editor.
- I've been able to migrate accounts/contacts with appropriate lookups/hooks without problem using the built in Salesforce map BUT,
- We have custom Salesforce forms (Training forms) to migrate which have fields that do lookups on account and contact that I haven't been able to move over.  I can move all data w/o problem except the account/contact lookups.

I've been trying to use the Advanced Map Editor to create the appropriate transforms to accomplish this, but I haven't been able to get it to work properly.  I'm fairly sure I need to use the 'Replace' Transform, but I must be messing something up.  Can anyone give any advice as to how to get this to work?

Any help is appreciated.  If I've forgotten to give any key information please ask.  We're trying to get this moved as soon as possible.  Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Aftab_Khateeb
Aftab_Khateeb
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of choldsworth
choldsworth

ASKER

What I ended up doing was creating a custom field for the GUIDs used by Salesforce, and then used that w/ the Transform to input data like Contact, Account, Product.  Everything works great now... thanks!