You have information in a CSV or Text Delimited file that you want to import in to an existing ACT! database.
Note: Before proceeding, it is strongly recommended that you perform a backup of the destination database. For detailed information on backing up your ACT! database, refer to the following Knowledge Base Answer
Note: The import process was changed in Sage ACT! 2011. For instructions for Sage ACT! 2011, refer to the following Knowledge Base Answer
Sage ACT! 2011 & Sage ACT! 2012
For instructions specific to Sage ACT! 2011 and Sage ACT! 2012, please refer to the following Knowledegbase article:
Important note regarding mapping contact names:
If you are intending to map to the Contact name field in ACT!, but your file is formatted to list contacts by First Name and Last Name in separate columns, you can map to the First Name and Last Name fields in ACT! during the mapping process, and the Contact field in ACT! will be populated automatically with the data from both of these fields. To do this, you must name the columns in your .csv file exactly as "First Name" and "Last Name", so that they will be automatically matched during the mapping process. This same rule applies to "Middle Name", "Name Prefix" (Mr., Mrs, Dr.,etc), and "Name Suffix" (PhD, Jr., Sr., etc.).
Note Regarding Secondary Contacts
When importing into an ACT! database from a .csv or .txt file, you will not be able to import Secondary Contacts. This is because Secondary Contact fields are not available when mapping data. More information on mapping fields is provided in the instructions below.
Important note regarding Groups and Companies:
If you do not see Group or Company Name fields in the mapping screen when importing Group or Company records, you may need to format the column in your file exactly to the name of that field in ACT! and it will automatically map itself:
Before importing the data, it is imperative to verify the duplicate matching criteria in the database you will be importing to in order to avoid unwanted duplication of contact data. Follow the steps below:
Duplicate Matching Criteria:
Note: To import a Comma Delimited text file into ACT!, each field is required to be marked with quotation marks. If you were to open a standard Comma Delimited file in Notepad it would look similar to this (each line is one contact):
ACT! import also requires that any Text Delimited file have either a .txt or .csv file extension. If necessary, change the file extension to .txt. For example, if the original file name is named Data.dat, change the file name to Data.txt.
Importing Text Delimited Contacts:
After verifying the duplicate matching criteria you are ready to begin the import process.
Follow the steps below to import Text Delimited Contacts into an ACT! database:
Note: The amount of time required for an import depends upon the amount of data being imported (Contacts, Activities, Notes/History, Opportunities, and so on), the speed of the computer performing the import, and the available network bandwidth if accessing a databases stored on a network drive. Please do not interrupt the process.
Note: Before proceeding, it is strongly recommended that you perform a backup of the destination database. For detailed information on backing up your ACT! database, refer to the following Knowledge Base Answer
How To Back and Restore and ACT! Database
Answer ID: How to back up and restore an Act! database
Answer ID: How to back up and restore an Act! database
Note: The import process was changed in Sage ACT! 2011. For instructions for Sage ACT! 2011, refer to the following Knowledge Base Answer
How To Import Contact Data from an Excel®, Comma Delimited (CSV), or Text Delimited (TXT) File into Sage ACT! 2011
Answer ID: How to Import Contact Data from an Excel®, Comma Delimited (CSV), or Text Delimited (TXT) File into Act!
Answer ID: How to Import Contact Data from an Excel®, Comma Delimited (CSV), or Text Delimited (TXT) File into Act!
Sage ACT! 2011 & Sage ACT! 2012
For instructions specific to Sage ACT! 2011 and Sage ACT! 2012, please refer to the following Knowledegbase article:
How to Import Contact Data from an Excel®, Comma Delimited (CSV), or Text Delimited (TXT) File into Sage ACT!
Answer ID: How to Import Contact Data from an Excel®, Comma Delimited (CSV), or Text Delimited (TXT) File into Act!
Answer ID: How to Import Contact Data from an Excel®, Comma Delimited (CSV), or Text Delimited (TXT) File into Act!
Important note regarding mapping contact names:
If you are intending to map to the Contact name field in ACT!, but your file is formatted to list contacts by First Name and Last Name in separate columns, you can map to the First Name and Last Name fields in ACT! during the mapping process, and the Contact field in ACT! will be populated automatically with the data from both of these fields. To do this, you must name the columns in your .csv file exactly as "First Name" and "Last Name", so that they will be automatically matched during the mapping process. This same rule applies to "Middle Name", "Name Prefix" (Mr., Mrs, Dr.,etc), and "Name Suffix" (PhD, Jr., Sr., etc.).
Note Regarding Secondary Contacts
When importing into an ACT! database from a .csv or .txt file, you will not be able to import Secondary Contacts. This is because Secondary Contact fields are not available when mapping data. More information on mapping fields is provided in the instructions below.
Important note regarding Groups and Companies:
If you do not see Group or Company Name fields in the mapping screen when importing Group or Company records, you may need to format the column in your file exactly to the name of that field in ACT! and it will automatically map itself:
- To map to the Company name, title the column "Company" on the file.
- To map to the Group name, title the column "Group Name" on the file
Before importing the data, it is imperative to verify the duplicate matching criteria in the database you will be importing to in order to avoid unwanted duplication of contact data. Follow the steps below:
Duplicate Matching Criteria:
- Click the Tools
menu, and then click Preferences. The Preferences dialog box appears:
- Under the
General Tab, click the Duplicate Checking button.
The Duplicate Checking dialog box appears; prompting you to verify the
fields and the field order that will best distinguish duplicate contacts in
the databases you will be merging.
Note: Browse users will not have access to this feature.
- Click OK to close the Duplicate Checking dialog box and save the settings.
Note: To import a Comma Delimited text file into ACT!, each field is required to be marked with quotation marks. If you were to open a standard Comma Delimited file in Notepad it would look similar to this (each line is one contact):
"Chris Huffman" , "Cordoba Coffee" , "400 Madison
Avenue" , "New York" , "New York"
"Bob Smith" , "Smith Bakery" , "1300 Quaker Street" , "Springfield" , "Oregon"
"Robert Actman" , "Active Roasters" , "20 Hidden Lane" , "Savannah" , "Georgia"
A Tab Delimited file uses Tabs to separate fields and rows. "Bob Smith" , "Smith Bakery" , "1300 Quaker Street" , "Springfield" , "Oregon"
"Robert Actman" , "Active Roasters" , "20 Hidden Lane" , "Savannah" , "Georgia"
ACT! import also requires that any Text Delimited file have either a .txt or .csv file extension. If necessary, change the file extension to .txt. For example, if the original file name is named Data.dat, change the file name to Data.txt.
Importing Text Delimited Contacts:
After verifying the duplicate matching criteria you are ready to begin the import process.
Follow the steps below to import Text Delimited Contacts into an ACT! database:
- Open the database that you will be using as the destination database.
- Click the File menu, and then click Import. The Import Wizard launches.
-
If the
Welcome to the Import Wizard dialog box appears, enable
the Check to hide in the future option (if desired), and then click
Next. The Specify Source dialog box appears:
- Ensure that Text Delimited is displayed in the What type of file do you want to import? field.
- Click the browse button to the right of the File name and location field. An Open dialog box appears.
- Navigate to (if necessary), click the text delimited file (.txt or .csv) you would like to import, and then click Open.
-
Click Next.
The Specify record type(s) dialog box appears:
-
Enable the radio
button for the kind of records you would like to imported from the source file;
Contact Records, Group Records, or Company Records,
and then click Next. The Specify Import Options dialog box appears:
-
Enable
the appropriate field separator in the text file (CSV
is usually Comma separated).
Important Note: If the Yes, import the first record option is enabled while importing a Text Delimited file, the Contact Map will NOT display correctly. This is a known issue that is under investigation. Please be sure to clear this option.
-
Click Next, the Contact Map,
Group Map, or Company Map dialog box appears depending which option
you choose in the Specify record type(s) window:
-
The Map from this field
column represents the fields in the Text Delimited (source) file you are importing.
The To this field column represents the fields in the current (destination)
ACT! database. Complete the mapping by ensuring the To this field column
has an entry for each field that you wish to receive data into. If a field is
not mapped in the To this field column, any data in the source field
will not be imported into the ACT! database. To change the mapping of a particular
field, click in the To this field column, and then click the desired
field from the drop-down.
If the source column does not list entries as expected, click the advance buttonto advance to the next record in the source file. You may need to click this button several times to find a record from the source file that will give you complete mapping information.
NOTE: If you find that no fields appear in the list, the solution is to remove the blank line(s) in the text-delimited file and try importing again. -
When all fields have been mapped
as desired, click Next. The Specify Merge Options
dialog box appears:
Note: you can only map a field to one other field, selecting the field again in this list will remove the first selection.
Note: Enabling the Confirm each match option will create a warning for any Contact that matches on two or more duplicate checking criteria fields, if you have many records in either database that will match your duplicate criteria, you will be prompted to manually confirm every match. This can cause delays importing a large number of matching records.
-
Click the
Merge Options button that correspond to the type of records
(Contact, Group or Company) that you are importing. The
Merge Options dialog box appears.
If source records match destination records (according the your Duplicate Matching Criteria), merge options allow you to combine the data in duplicate records, replace with the newest data, replace with the source data or leave the data unchanged. This applies only to duplicate records:
Merge - Imports data only into fields that are blank in the destination record
Replace with the newest contact - Populates all fields with the newest data from either record. This option does not appear as Text Delimited File import option in Act! by Sage 2010 and newer versions.
Replace with the source contact - Replaces all fields with source data
Do not change - Leaves all data in destination record unchanged
Note: If these merge options are not adequate, you may create new fields in the destination database, and map these for the import of your data. Once the data is in the destination database, you can use the Replace feature in ACT! to copy (or swap) data between two different fields in your ACT! database. For information in using the Replace feature, refer to the following document:
Refer to your merge option(s) below:
-
The Contact Merge Options provide options
on how records will be merged for, Contact records. Click OK
to return to the Specify Merge Options dialog box.
-
The Contact Merge Options provide options
on how records will be merged for, Contact records. Click OK
to return to the Specify Merge Options dialog box.
-
When the options have been set,
click Next. The Completing Import Wizard dialog
box appears:
-
Review your settings,
and then click Finish to begin the import process. A progress
indicator appears as the text file is imported:
Note: The amount of time required for an import depends upon the amount of data being imported (Contacts, Activities, Notes/History, Opportunities, and so on), the speed of the computer performing the import, and the available network bandwidth if accessing a databases stored on a network drive. Please do not interrupt the process.