You have a multi-user ACT! database and you wish to move the users and their associated contacts into a different ACT! database.
When using the Import or Export process to transfer data between two ACT! databases with ACT! by Sage 2006 and ACT! 2005, files attached to the Notes, History or Documents tabs will NOT transfer and must be re-attached. This functionality returned in ACT! by Sage 2007 (9.0).
The original database with multiple users will be referred to as the 'source' database in this document while the database that you wish to export the information and Record Managers to, will be referred to as the 'destination' database. The destination database can be either a New database or an Empty copy of the database you are exporting from. If you have modified the field structure in your source database, it is recommended that you use an Empty Copy for the destination database.
Important Note for Single-User licensed copies of ACT! for Windows and ACT! Premium for Workgroups
If you own a single-user licensed copy of ACT! and your database users are Sync users, this procedure will not work. This procedure requires that a temporary user be created that can be later deleted and this cannot be done in an ACT! installation licensed for a single-user.
If you are sharing a database from a single-user installation of ACT!, you will be able to delete the temporary user after one of the share users logs in as an Administrator and contributes another license to the database.
Importing to an Empty Copy:
An Empty Copy of your database retains the same field structure as the source database and can be useful to repair a database through the import process. This process will be described in three parts:
I - Creating the Empty Copy and Exporting the User Records:
Important Note for ACT! 2007 Users: You must set all fields security levels to Full Access in the source database before creating the empty copy. This setting will carry over to the empty copy as well as no data could transfer when you attempt to import from fields that are not set to Full Access.
II - Creating the Users in the Empty Copy:
III - Delete the Temporary User:
If you wish to transfer all records from the source database, click the File menu, click Import, and then follow the prompts in the Import Wizard.
As you proceed through the Import (or Export) Wizard, it is VITAL that you examine the Contact Merge Options dialog box. The If source records match destination records section must be configured to Merge for all options.
Configure the Group Merge Options for If source records match destination records section as follows:
Group records: Replace with source group
Notes: Replace with source
History: Replace with source
Configure the Company Merge Options for If source records match destination records section as follows:
Company records: Replace with source
Notes: Replace with source
History: Replace with source
For detailed information regarding Importing from another ACT! database, refer to the following Knowledge Base document:
I - Creating the Destination Database and Exporting the User records from the Source Database:
II - Creating the Users in the Destination Database:
If you wish to transfer all records from the source database, click the File menu, click Import, and then follow the prompts in the Import Wizard.
As you proceed through the Import (or Export) Wizard, it is VITAL that you examine the Contact Merge Options dialog box. The If source records match destination records section must be configured to Merge for all options.
Configure the Group Merge Options for If source records match destination records section as follows:
Group records: Replace with source group
Notes: Replace with source
History: Replace with source
Configure the Company Merge Options for If source records match destination records section as follows:
Company records: Replace with source
Notes: Replace with source
History: Replace with source
For detailed information regarding Importing from another ACT! database, refer to the following Knowledge Base document:
When using the Import or Export process to transfer data between two ACT! databases with ACT! by Sage 2006 and ACT! 2005, files attached to the Notes, History or Documents tabs will NOT transfer and must be re-attached. This functionality returned in ACT! by Sage 2007 (9.0).
The original database with multiple users will be referred to as the 'source' database in this document while the database that you wish to export the information and Record Managers to, will be referred to as the 'destination' database. The destination database can be either a New database or an Empty copy of the database you are exporting from. If you have modified the field structure in your source database, it is recommended that you use an Empty Copy for the destination database.
Note: Images in your version of ACT! may differ slightly from the ones used in this Answer.
Caution: It is strongly recommended that you have a current back up of each database involved in this procedure before continuing. It is strongly recommended that you create a current back up of your ACT! e-mail database. Please see the following documents for assistance:
Title: How to Back Up and Restore an ACT! Database
Answer ID: How to back up and restore an Act! database
Answer ID: How to back up and restore an Act! database
Title: How to Back Up and Restore an ACT! 2006 Database
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
Title: How to Back Up and Restore an ACT! 2005 Database
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
Title: How to Back Up and Restore Your ACT! E-mail Database
Answer ID: How to Back Up and Restore Your ACT! E-mail Database
Answer ID: How to Back Up and Restore Your ACT! E-mail Database
Title: How to Back Up and Restore Your ACT! 2006 E-mail Database
Answer ID: How to Back Up and Restore Your ACT! 2006 E-mail Database
Answer ID: How to Back Up and Restore Your ACT! 2006 E-mail Database
Title: How To Back Up or Move Your ACT! 2005 E-mail Messages
Answer ID: How To Back Up or Move Your ACT! 2005 E-mail Messages
Answer ID: How To Back Up or Move Your ACT! 2005 E-mail Messages
Important Note for Single-User licensed copies of ACT! for Windows and ACT! Premium for Workgroups
If you own a single-user licensed copy of ACT! and your database users are Sync users, this procedure will not work. This procedure requires that a temporary user be created that can be later deleted and this cannot be done in an ACT! installation licensed for a single-user.
If you are sharing a database from a single-user installation of ACT!, you will be able to delete the temporary user after one of the share users logs in as an Administrator and contributes another license to the database.
Importing to an Empty Copy:
An Empty Copy of your database retains the same field structure as the source database and can be useful to repair a database through the import process. This process will be described in three parts:
- Creating the Empty Copy and exporting the user records
- Creating the users in the Empty Copy
- Delete the Temporary User
- Importing/Exporting the contacts from the source database while retaining the Record Manager
I - Creating the Empty Copy and Exporting the User Records:
Important Note for ACT! 2007 Users: You must set all fields security levels to Full Access in the source database before creating the empty copy. This setting will carry over to the empty copy as well as no data could transfer when you attempt to import from fields that are not set to Full Access.
- From the source database, click the File menu, and then click Save Copy As. The Save Copy As dialog box appears:
- Enter a Database Name, ensure that the Share this database with other users and the Create an empty copy of this database options are enabled.
- Click the Browse button and browse to the shared folder. and then click OK. Another Save Copy As dialog box appears:
- Click into the Choose Contact field, and enter Temp for the temporary user. Do NOT enter a password for this user.
- Click OK. When the Empty Copy has been successfully created, the following ACT! message appears.
- Click OK to return to the source database.
Note: When an Empty Copy is created, it is not attached to the SQL Server and must be opened independently before you can export the user records to it. - Click the File menu, and then click Open Database. An Open dialog box appears.
- Open the empty copy by logging in as the temporary user (Temp) established in step 3 above. The following ACT! message appears.
- Click OK to verify the database. A Working progress indicator appears as the database is attached. When the process is complete, the following ACT! message appears.
- Click OK. The Empty Copy database opens.
- Once the Empty Copy has been fully opened, click the File menu, and then click Open Database again to return to the source database.
- From the source database, click the Lookup menu, point to Advanced, and then click Users. The Contact List View appears with all users listed.
- If you wish to export all users, skip ahead to step 13.
- If you wish to export selected users; click the Enable Tag Mode option, and then click each user that you wish to be a Record Manager in the destination database. Once all desired users are selected, click the Lookup Selected button. A lookup is created of these user records.
- Click the File menu, and then click Export. The Export Wizard - Welcome to the Export Wizard dialog box appears.
- Enable (if desired) the Check to hide in the future option, and then click Next. The Export Wizard - Specify Destination dialog box appears.
- Ensure that the What type of file do you want to export to? field displays ACT! Database 9.x, ACT! Database 8.x, ACT! Database 7.x.
- Click the Browse button at the Filename and location field. An Open dialog box appears.
- Browse to (if necessary), and Open the Empty Copy of your database. The Export Wizard - Specify Destination dialog box reappears with the Filename and location field now populated with the file path to the destination database.
- Enter the User Name as Temp for the Empty Copy, and then click Next. The Export Wizard - Specify record type(s) dialog box appears.
- Ensure that Contact records is enabled in the What kind of records would you like to export? section and that Current lookup is enabled in the Which records do you want to export? section, and then click Next. The Export Wizard - Contact Map dialog box appears.
Note: The left (Map this Field) column of the contact map displays the fields in the source database while the right (To this Field) column displays the fields in the destination database. When exporting to an Empty Copy of the source database, the fields in the left column will match the fields in the right column.
- Click Next. The Export Wizard - Specify Merge Options dialog box appears.
- There is no need to modify Contact Merge Options when exporting to an Empty Copy with only a single temporary contact/user. Click Next. The Completing Export Wizard dialog box appears.
- If the displayed export options are not correct, click Back to correct the settings, otherwise click Finish. An Exporting Data... progress indicator appears. You can then return to the destination database and create users from the records that were exported.
II - Creating the Users in the Empty Copy:
- Open the destination database (If prompted to login, you must login with the temporary contact/user name from step 3 above), click the Tools menu, and then click Manage Users. The Manage Users - Select a User dialog box appears.
- Click the Create New User option. The Create New User dialog box appears.
- Ensure that the Create User from Contact - Create a new User from an existing Contact option is enabled, and then click Next. The Choose Contact dialog box appears with the first contact/user selected.
- Click Next. The Enter User Information dialog box appears with this name displayed in both the Contact Name and User Name fields.
- Enter and confirm a password (if desired) for this user, change the Security Role to either Manager or Administrator, and then click Next. The Specify Access dialog box appears.
- Ensure that the Logon Access is set to Active - Pending log on: and disable options for handheld sync and/or accounting link tasks as appropriate and then click Finish. (it is not appropriate to add users to teams at this time) The Select a User dialog box re-appears with the new user information displayed.
- Repeat steps 2 - 6 for each user. When all users have been created as Active Managers or Administrators, close the Select a User dialog box.
- Restart your computer.
Important Note: In order for the Notes, History and Activity information to be associated with the correct Record Manager; you must now log in to the destination database as one of the new users and delete the temporary user. This step will delete all note, history and activity information from the records in the destination database. When you import the records from the source database, these tabs will be repopulated with the appropriate Record Manager associations.
III - Delete the Temporary User:
- If your copy of ACT! is licensed for a Single-User, login across the network to the database from a uniquely licensed copy of ACT! (so that this unique license will be added to the shared database), and then proceed to step 1 below:
-otherwise-
- Click the File menu, and then click Open Database. Open the destination database again, and this time login as one of the Administrator users created in the procedure above, and then follow the steps below:
- Click the Tools menu, and then click Manage Users. The Manage Users - Select a User dialog box appears.
- Select the temporary user, and then click the Delete User option. The Delete User dialog box appears. This is needed in order for the Notes, History and Activity information to be associated with the correct Record Manager. This step will delete all note, history and activity information from the records in the destination database. When you import the records from the source database, these fields will be repopulated with the appropriate Record Manager associations.
- Ensure that the Delete records belonging to this user option is enabled, and then click OK. The following ACT! dialog box appears.
- Click Yes to confirm the deletion. The Retain as Contact? dialog box appears.
Note: It does not really matter whether you retain this user as a contact or not, provided you intend for this contact to remain in the database and you ensure that Contact Merge Options are set to Merge for contacts that match.
- Click No. (or Yes - see the note above) The temporary user is deleted. Close the Select a User dialog box. The Notes, History, Activities and Opportunities tabs will be blank and you are ready to Import the records from the source database.
If you wish to transfer all records from the source database, click the File menu, click Import, and then follow the prompts in the Import Wizard.
As you proceed through the Import (or Export) Wizard, it is VITAL that you examine the Contact Merge Options dialog box. The If source records match destination records section must be configured to Merge for all options.

Configure the Group Merge Options for If source records match destination records section as follows:

Group records: Replace with source group
Notes: Replace with source
History: Replace with source
Configure the Company Merge Options for If source records match destination records section as follows:

Company records: Replace with source
Notes: Replace with source
History: Replace with source
For detailed information regarding Importing from another ACT! database, refer to the following Knowledge Base document:
Title: How to Import Contact Data From an Existing ACT! Database into Another ACT! Database
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
If you wish to transfer only some of the records from source database, you must re-open the source database and then create a lookup of the records that you wish to transfer, before proceeding to the Export Wizard. For detailed information regarding exporting records and creating lookups, refer to the following Knowledge Base documents:
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
Title: How to Export Your ACT! Database to Another ACT! Database
Answer ID: How do I export data from one Act! database to another
Answer ID: How do I export data from one Act! database to another
Title: Advanced Lookup Features in ACT! 2006
Answer ID: Advanced Lookup Features in ACT! 2006
Title: Advanced Lookup Features in ACT! 2005
Answer ID: Advanced Lookup Features in ACT!
Answer ID: Advanced Lookup Features in ACT! 2006
Title: Advanced Lookup Features in ACT! 2005
Answer ID: Advanced Lookup Features in ACT!
Importing to a New Database:
This process will be described in three parts:
- Creating the destination database and exporting the user records
- Creating the users in the destination database
- Delete the Temporary User
- Exporting/Importing the contacts from the source database while retaining the record manager
I - Creating the Destination Database and Exporting the User records from the Source Database:
- When logged into the source database as an Administrator, click the File menu, and then click New Database. The New Database dialog box appears.
- Enter a Database name, ensure the Share this database with other users option is enabled and enter a user name as temp, for the temporary user. Do NOT enter a password.
- Click OK. A progress indicator appears as the new database is created. The New database will open with this single temporary user displayed.
- Click the File menu, click Open database and re-open the source database. Login as a database administrator.
- Click the Lookup menu, point to Advanced, and then click Users. The Contact List View appears with all users listed.
- If you wish to export all users, skip ahead to step 6.
- If you wish to export selected users; click the Enable Tag Mode option, and then click each user that you wish to include as a Record Manager in the destination database. Once all desired users are selected, click the Lookup Selected button. A lookup is created of these user records.
- Click the File menu, and then click Export. The Export Wizard - Welcome to the Export Wizard dialog box appears.
- Enable (if desired) the Check to hide in the future option, and then click Next. The Export Wizard - Specify Destination dialog box appears.
- Ensure that the What type of file do you want to export to? field displays ACT! 13.x Database, ACT! Database 12.x, ACT! Database 11.x, ACT! Database 10.x, ACT! 9.x Database, ACT! Database 8.x, ACT! Database 7.x in the file type field.
- Click the Browse button at the Filename and location field. An Open dialog box appears.
- Browse to (if necessary), and Open the database that you wish to export your data to. The Export Wizard - Specify Destination dialog box reappears with the Filename and location field now populated with the file path to the destination database.
- Enter the User Name as Temp, and then click Next. The Export Wizard - Specify record type(s) dialog box appears.
- Ensure that Contact records is enable in the What kind of records would you like to export? section and that Current lookup is enabled in the Which records do you want to export? section, and then click Next. The Export Wizard - Contact Map dialog box appears.
Note: The left (Map this Field) column of the contact map displays the fields in the source database while the right (To this Field) column displays the fields in the destination database. When exporting to a new database from an unmodified database, you can expect the fields in the left column to match the fields in the right column. However, it is strongly recommended that you scroll through the entire list to ensure that the data in all fields of the source database are being directed to the correct field in the destination database. If you find a field in the left column that does not match the entry in the right column or if you wish to change the location of data in the destination database, you can click into the right column and change the destination field from the drop-down.
Note: you can only map a field to one other field, selecting the field again in this list will blank or remove the first selection.
- When you are sure that all fields are mapped correctly, click Next. The Export Wizard - Specify Merge Options dialog box appears.
- There is no need to modify Contact Merge Options when exporting to a new database with only a single temporary contact/user. Click Next. The Completing Export Wizard dialog box appears.
- If the displayed Export options are not correct, click <Back to correct the settings, otherwise click Finish. An Exporting Data... progress indicator appears. When the export is complete, the next step is to open the destination database and create users from the records that were exported.
II - Creating the Users in the Destination Database:
- Open the destination database (you must login with the temporary user name, Temp), click the Tools menu, and then click Manage Users. The Manage Users - Select a User dialog box appears.
- Click the Create New User option. The Create New User dialog box appears.
- Ensure that the Create User from Contact - Create a new User from an existing Contact option is enabled, and then click Next. The Choose Contact dialog box appears with the first contact/user selected.
- Click Next. The Enter User Information dialog box appears with this name displayed in both the Contact Name and User Name fields.
- Enter and confirm a password (if desired) for this user, change the Security Role to either Manager or Administrator, and then click Next. The Specify Access dialog box appears.
- Ensure that the Logon Access is set to Active - Pending log on: and disable options for handheld sync and/or accounting link tasks as appropriate and then click Finish. (it is not appropriate to add users to teams at this time) The Select a User dialog box re-appears with the new user information displayed.
- Repeat steps 2 - 6 for each user. When all users have been created as Active Managers or Administrators, close the Select a User dialog box.
- Restart your computer.
Important Note: In order for the Notes, History and Activity information to be associated with the correct Record Manager; you must now log in to the destination database as one of the new users and delete the temporary user. This step will delete all note, history and activity information from the records in the destination database. When you import the records from the source database, these tabs will be repopulated with the appropriate Record Manager associations.
- If your copy of ACT! is licensed for a Single-User, login across the network to the database from a uniquely licensed copy of ACT! (so that this unique license will be added to the shared database), and then proceed to step 1 below:
-otherwise-
- Click the File menu, and then click Open Database. Open the destination database again, and this time login as one of the Administrator users created in the procedure above, and then follow the steps below:
- Click the Tools menu, and then click Manage Users. The Manage Users - Select a User dialog box appears.
- Select the temporary user, and then click the Delete User option. The Delete User dialog box appears. This is needed in order for the Notes, History and Activity information to be associated with the correct Record Manager. This step will delete all note, history and activity information from the records in the destination database. When you import the records from the source database, these fields will be repopulated with the appropriate Record Manager
- Ensure that the Delete records belonging to this user option is enabled, and then click OK. The following ACT! dialog box appears.
- Click Yes to confirm the deletion. The Retain as Contact? dialog box appears.
- Click No. The temporary user is deleted. Close the Select a User dialog box. The Notes, History, Activities and Opportunities tabs will be blank and you are ready to Import the records from the source database.
If you wish to transfer all records from the source database, click the File menu, click Import, and then follow the prompts in the Import Wizard.
As you proceed through the Import (or Export) Wizard, it is VITAL that you examine the Contact Merge Options dialog box. The If source records match destination records section must be configured to Merge for all options.

Configure the Group Merge Options for If source records match destination records section as follows:

Group records: Replace with source group
Notes: Replace with source
History: Replace with source
Configure the Company Merge Options for If source records match destination records section as follows:

Company records: Replace with source
Notes: Replace with source
History: Replace with source
For detailed information regarding Importing from another ACT! database, refer to the following Knowledge Base document:
Title: How to Import Contact Data From an Existing ACT! Database into Another ACT! Database
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
If you wish to transfer only some of the records from source database, you must re-open the source database and then create a lookup of the records that you wish to transfer, before proceeding to the Export Wizard. For detailed information regarding exporting records and creating lookups, refer to the following Knowledge Base documents:
Answer ID: The article that was linked here is no longer available, try searching our knowledgebase for similar terms.
Title: How to Export Your ACT! Database to Another ACT! Database
Answer ID: How do I export data from one Act! database to another
Answer ID: How do I export data from one Act! database to another