Contact Import & Export
Contact Import & Export is where you are able to import, export, and delete bulk contacts for use in Agent Desktop. Note that this section replaces and removes the Bulk Export/Import Contacts feature from the Agent Desktop Search & Preview Records screen.
Contact Import & Export Tab
The Contact Import & Export tab is where you may initiate import, export, and deletion of bulk contacts. Additionally, the total number of contacts currently in your database is listed here.
Import
The Import option allows you to upload bulk contacts through an import dialog window.
Name and Source Tab
Data Source
Data Source allows you to select from the following options.
Upload
This option allows you to upload a .TXT or .CSV file.
FTP or SFTP
This option allows you to select either FTP or SFTP and then enter the access URL.
Username
This is the username of the FTP or SFTP site.
Password
This is the password of the FTP or SFTP site.
List format
If you previously saved a list format, you may choose to import your contacts in this format.
Format Options Tab
The Format Options tab allows you to customize the format of your import records.
File Input Encoding
First line contains field names
When enabled, this checkbox will recognize the first line or row of your upload as the names of the contacts fields.
Input file encoding
This option allows you to select the encoding for your import file; select the encoding type from the drop-down menu.
Field separator options
The field separator options are as follows: Comma, Tab, Semicolon, and Custom.
Fields Tab
The fields selector maps the fields from the import source to fields of contact and company objects. If your import source does not contain fields currently recognized in the database, this selector allows you to map them as needed. When you select a field in the field map, the following information will display.
Selected field
This is the field you have selected.
Mapped to
The Mapped to menu displays where the selected field is currently mapped to. To change where the field is mapped to, select a new field from the menu.
Save new list format as
After mapping your import fields, the Save new list format as dialog window will pop up. From here, you will have the option to save this import as a new format list. Note your import will not be affected if you choose not to save a new list format.
Results Tab
The Results tab displays the results from the attempted import as the following.
- Records read - The number of records read
- Contacts created - The number of contacts created
- Contacts updated - The number of contacts with updated information
- Companies created - The number of companies created
- Errors detected - The number of errors detected in the attempted import
Note: If your import contains errors, you will be able to download a .CSV file listing the errors.
Export
The Export action allows you export contacts from your database in two ways: All Contacts or Modified since.
Note that you may choose the Export action to download a template of what the current contact and company fields are.
All Contacts
The All Contacts option will export all contacts in your database.
Modified since
The Modified since option allows you to export contacts that have been modified from a set date; you may select the date in the calendar.
Delete
The Delete option allows you to remove bulk contacts from your database through a dialog window similar to the one for Import. The Name and Source, Format Options, and Results tabs are the same as those for the import dialog; however, the Fields tab determines how you match contacts in a .CSV file with contacts in the database. Additionally, when you delete contacts, you may delete/update other objects.
Name and Source Tab
Data Source
Data Source allows you to select from the following options.
Upload
This option allows you to upload a .TXT or .CSV file containing the records you wish to delete.
FTP or SFTP
This option allows you to select either FTP or SFTP and then enter the access URL.
Username
This is the username of the FTP or SFTP site.
Password
This is the password of the FTP or SFTP site.
List format
If you previously saved a list format, you may choose to delete your contacts in this format.
Format Options Tab
The Format Options tab allows you to customize the format of your delete records.
File Input Encoding
First line contains field names
When enabled, this checkbox will recognize the first line or row of your upload as the names of the contacts fields.
Input file encoding
This option allows you to select the encoding for your delete file; select the encoding type from the drop-down menu.
Field separator options
The field separator options are as follows: Comma, Tab, Semicolon, and Custom.
Fields Tab
The Fields tab determines how you match contacts marked for deletion in a .CSV file with contacts in the database. Additionally, when you delete contacts, you may delete/update other objects.
Selected field
This is the field you have selected.
Mapped to
The Mapped to menu displays where the selected field is currently mapped to. To change where the field is mapped to, select a new field from the menu.
Results Tab
The Results tab displays the results from the attempted bulk delete as the following.
- Records read - The number of records read
- Contacts deleted - The number of contacts deleted
- Errors detected - The number of errors detected in the attempted delete
Note: If your delete attempt contains errors, you will be able to download a .CSV file listing the errors.
Log Tab
The Log tab displays the following data from bulk imports, exports, and deletes.
Date
Date is the date and time the transaction took place.
Who
Who shows the user who initiated the transaction.
Operation
Operation displays the type of transaction that occurred; the types are Import, Export, and Delete.
File
File displays the name of the Import or Delete file.
Rows
Rows displays the number of rows in the File.
Added
Added displays the number of new contacts added to the database.
Changed
Changed displays the number of contacts already in the database that were altered by the transaction.
Deleted
Deleted displays the number of contacts removed from the database.
Errors
Errors displays the number of records that were not added, changed, or deleted due to missing or incompatible information.
Notes
Notes is where you may enter notes about the transaction.