Migrating from ACT! to Salesforce

From Starfish ETL
Revision as of 18:35, 17 August 2015 by Jkuehlthau (talk | contribs)
Jump to navigation Jump to search

This map will migrate ACT! to Salesforce.

This map is set up to use the SQL versions of ACT. If you have the older flat-file version of ACT, a simple upgrade process can get you on SQL for the migration. Duplicate companies are merged into a single Company record, with contact records underneath it, based on Company Name + City though this logic could be easily changed to fit your needs. This is done through use of a temporary database file, included with the download.

You will have to create 4 custom External ID fields in Salesforce, as defined in the included "instructions.txt" file, to allow for ID cross-referencing.

This map migrates Users, Accounts, Contacts, Opportunities, Notes, History, Activities and Attachments.

Download Now


Notes

  1. The initial "Accounts + Contacts Staging" job does not bring over phone number extensions. If you want this field, you will need to add it to the included Access Temporary Database and then add it to the final mapping to Salesforce.