How to Import Act Database to an Act Vertical Database

Congratulations on the purchase of an Act Vertical Database customized for your industry. To get started if you have an existing Act database you will need to import it to the Act Vertical Database. Below are some guidelines to using the import Act database feature and the import must be performed using the Act for Windows program as the import Act database feature is not currently available in the cloud product.

Importing a single user database that hasn’t been customized is a relatively simple process, similar to importing a text file. Importing a multi-user database or if your existing database has been customized is a more complex process. Below are four scenarios with general guidelines for the import of your existing database (source database) to an Act Vertical Database (target or destination database).

OPTION 1: Single User With No Customizations – From the Act Vertical Database go to the File Menu and select Import, the Import Wizard displays. On the Specify Source dialog select Act! Database, click the Browse Button to select your existing database and enter your log on information. Import the Record Types (Company, Contact, Group, Opportunity) where you have created records and since your database has not been customized you will not need to map your fields – they will automatically map. For your Merge Options for each Record Type Replace with Source or Merge if existing match to clean up any duplicates and if there isn’t an existing match select Add. Be sure to select the checkboxes of Include attachments if you had attached files and Include others users public activities if you were scheduling activities. For more information, please review the knowledgebase article How To Import Contact Data From an Existing ACT! Database Into Another ACT! Database.

OPTION 2: Single User With Customizations – If your existing database has customized fields that are not in the Act Vertical Database you will need to create the fields in order to retain the data. For more information, please review the knowledgebase article How To Manage Fields in ACT!. Once you have added the fields to the Act Vertical Database, import your data by following the knowledgebase article in Option 1.

OPTION 3: Multi-User No Customizations – If you have a multi-user database you will want to move the users to retain Record Manager information to the Act Vertical Database. For more information, please review the knowledgebase article How to Import a Multi-User Database and Retain the Record Manager in ACT!.

OPTION 4: Multi-User With Customizations – First create the custom fields in the Act Vertical Database by following the knowledgebase article in Option 2. Next create the users in the Act Vertical Database by following the knowledgebase article in Option 3. Then import in your data to the Act Vertical Database.

For more tips and information to use the Import Act Database Feature see the knowledgebase article Best Practices for Import and Exporting Data from One ACT! Database to Another ACT! Database.

If you would rather have Platinum CRM Consulting take on the task of importing your Act database (or other data sources) for you please contact us for an estimate. We have been importing Act Databases for over 15 years and will bring over your existing database to your new Act Vertical Database.