SalesTrack > Get Started > Inital Setup > Import Data > Import Contacts

Import Contacts

Prerequisite

Only the Agency Admin or Sales Manager can import data into your Vertafore Agency SalesTrack. Producers can import contacts only for the accounts that they own or the accounts that have been shared with them.

Whether your contacts are stored in an email program, a spreadsheet, or on your phone, you’ll probably want to import them into Vertafore Agency SalesTrack so you can keep track of the people you do business with all in one place.

Data Import Templates

To make the import process simpler, here are some .xml templates to Import Accounts, Import Leads, Import Contacts and Import Activities -Task, Meeting, Phone Call and Email.

We recommend that you first import Account, followed by Leads, then Contacts and finally Activities by type.
  1. Right-click on the template and select Save target as . The Save As page appears.
  2. Navigate to the desired location and then click Save.

The maximum file size allowed for .zip files is 32 MB. For the other file formats, the maximum file size allowed is 8 MB. You can import up to 5000 lines of data, in a single import.

Step 1: Get your import file ready

First, you export your contacts into a file.

The following file formats are supported:

  • Comma-separated values (.csv)
  • Text (.txt)
  • Compressed (.zip)
  • Excel Spreadsheet 2003 (.xml)

Remember to remove the dashes from phone numbers and ZIP Code.

 

The maximum file size allowed for .zip files is 32 MB. For the other file formats, the maximum file size allowed is 8 MB. You can import up to 5000 lines of data, in a single import.


Follow the procedure for the program or location where your contacts are stored:

Export contacts from an email program

  1. Export the contacts into a comma separated values file (.csv). To find specific steps to export contacts from your email program, open the program’s Help, and search for “export.” Look for topics that include “exporting contacts” or “exporting your address book” or “export wizard” in the title.
  1. Save the file in a location where you can find it easily later.

Export contacts from a spreadsheet

Open the spreadsheet. If necessary, edit any column name in the spreadsheet to match exactly with the corresponding name shown here.

If the spreadsheet doesn’t include all the column names listed, that’s okay. However, if a column name does exist, it must match exactly with the corresponding name in the list or the import won’t work. Spaces are required

 

Column Name in Spreadsheet (spelling must match exactly)

First Name

Middle Name

Last Name

Business Phone

Mobile Phone

Job Title

Business Street

Business City

Business State

Business Postal Code

Business Country/Region

Email Address
  1. Save the file.

Export contacts from your phone

Use a USB cable or an app to export your contacts from your phone to your computer.  To find an app, search your phone’s online store.Step 2: Run the Import Data wizard

You’ll use the Import Data wizard to import your activities. You can import from the records list page or from within Data Management.

Import data from the List page

  1. On the top navigation bar click on the Vertafore logo and select Sales.
  2. Click the Sales again and select the Contacts tile. The accounts or leads list page appears.
  3. On the top command bar click Import Data. The Import Data Wizard appears. Continue to the Import Data Wizard instructions.
  4. Browse to the folder where you saved the file that contains the import file. Select the file and then click Open. Then, click Next.

You can import only one file at a time. To bring in more files, run the wizard again later, or add all your contacts files to a single .zip file.
  1. Review the file name, and if the file is in .csv or .txt format, verify that the field and data delimiters are correct. Then, click Next.

In most cases, you can accept the default delimiters.

Import Data Wizard

  1. Select how the wizard determines which fields to use for the data.
  2. In the Select Data Map section, choose Default (Automatic Mapping) if you want the wizard to determine the corresponding fields in Vertafore Agency SalesTrack automatically. If the wizard can’t find a field, you’ll have the opportunity to “map” it yourself.
    1. Select For Generic Contact and Account Data if your import file contains contacts and accounts (and contacts are the main type of data).
    2. Select For BCM 2010 if your import file contains your contacts from Microsoft Outlook 2010 with Business Contact Manager.
    3. If available for your organization, select a custom data map. (You’ll see them in the list if they’re available to you.)
  3. Click Next.
  4. If prompted, from the Record Types drop-down list, select the type of records you are importing, for example Account or Lead. Then, click Next. The Map Fields page appears.
  5. For any record type with an alert icon, map the field from your import file to a corresponding field in Vertafore Agency SalesTrack. Scroll to see the whole list. Then, click Next.
  6. Review the summary, and then click Next.
  7. Select additional import settings. Select Yes or No for the Import Data wizard to import duplicate records.
  8. To set who owns the imported records, in the Select Owner for the Imported Records section, click the Lookup button. Select Look Up More Records, type the person’s name, and then click Add.
  9. To save these import settings so you can use them again, enter a name for the settings (called a “data map”).
  10. The next time you run the Import Data wizard, you’ll see the new data map listed under Custom Maps.
  11. Click Submit.
  12. To verify that the wizard was successful, click Imports, and then review the report. Otherwise, click Finish.

Step 3: Review Import Status

  1. On the top navigation bar click on the Vertafore logo and select theSettings tile.
  2. Click on Settings and then choose Data Management.
  3. Click on Imports. The my imports page appears.
  4. Verify that the files you want to import are listed. For .zip files, the list includes each file added to the .zip file.
  5. Review the status of the import.
  6. Click on the Import Name. The import details appears.
  7. On the side bar click ContactsFully Imported, Contacts Partially Imported and Failures.
  8. If there are any failures, review the error description to resolve.

 

If the import is Completed with the correct number of records in the Success column, check your list of accounts, leads or contacts to make sure they imported correctly.

  1. On the top navigation bar click on the Vertafore logo and select the Sales tile.
  2. Click on Sales and then choose Contacts. A list of all your contacts appears.
  3. Scroll through the list and ensure each contact from the template is here and verify the contents of the fields for accuracy.

 

 

© 2017 Vertafore