Setting Up an Import Data Source

This article was developed to describe the steps in setting up an imported data source for use in Forth CRM.

An Import Data Source allows you to import leads via a .csv file (unformatted spreadsheet). You may do this to transfer leads from an old CRM or import leads purchased from a lead vendor.

This article includes the following topics:

• Setting up an Import Data Source
• Configuring the .csv file
• Selecting Additional Options
• Uploading the .csv file and mapping the fields

Setting up an Import Data Source

1. From the Contacts tab, click Data Source.
2. Do the following in the Name / Field Assignment section:
   
   * Required     ** Recommended
   
   
   1. *Source Name - Enter a name for the data source. We suggest naming the data source after the marketing company or using the web URL for the website the leads will be importing from.
   2. *Type - Select Import to accept the import file. We will review this in the next step. Web Form Data Sources are discussed here.
   3. *File Type - Select the type of program from the File Type menu you wish the contact to be created as.
   4. **Stage and Status - Select the workflow stage and status you want the contact to be placed into on creation.
   5. Campaign - Select an option from the Campaign menu that leads should be assigned to.
   6. **De-Dupe Field - The de-duplication feature is used to identify OR prevent duplicate leads from being created. Select the field you wish to check for duplicates. We recommend the "Email" address as "Phone" could be a shared number and possibly still separate leads from the same household. You would use "My ID" when purchasing leads from a lead vendor and you want to be sure they are not importing duplicate leads to your account.
   7. De-Dupe Action - What do you want to happen to the duplicate?
      
      • Reject means the lead will be rejected and no contact will be created. There will be no record of this contact attempting to be imported.
      • Flag as Dupe allows the system to create the contact but will flag it as a possible duplicate. You will find a link on the Client Dashboard to view and compare the possible duplicates and decide if you will merge them or leave them separate.
   8. De-Dupe Status - If you are flagging duplicates, you can also have the new possible duplicate contacts placed in a separate workflow status so they can be sorted through later.
   9. De-Dupe Type - Who will this affect? You may choose All Contacts, Enrolled, or Not Enrolled.

IMPORTANT
DO NOT SAVE YET! Saving a Data Source prior to uploading the .csv file will prevent the system from being capable of reading the file, and you'll need to start over by creating a new Data Source.

Configuring the .csv file

NOTE
It is VERY important the CSV file is setup correctly.

1. To start, the file to be imported should be the file type "CSV (Comma Delimited)". Any spreadsheet software should be able to Save (or Save As) the file in this format. If not in this format, the data source will not work. In the example below are a few things needed for the data source to import the file properly. Pay attention to the Header Row.
2. The first row of the spreadsheet should always be a Header Row. If you plan to use the data source to import several files of leads, make sure the Header Row is the same every time. The system will look for this row to properly map the fields later.
   
   NOTES
   • Special fields that contain functions and characters such as ($,&,/,?, etc...) can prevent the file from importing correctly.
   • Use only lowercase letters with no spaces, to minimize the possibility of problems during import.
   • Do not use duplicate headers. If the file contains two "phone" headers, you want to change the duplicate to "phone2" or maybe change them to "homephone" and "cellphone".
     
3. View the .csv file in Excel or other software if you still have issues importing the .csv file (preferably in a Notepad editor). This may reveal issues not easily visible in Excel. For example, in the item below you may notice a 'space' in front of the "phone" column header. This will cause the import to fail and you may not have noticed it when viewing in Excel.
   
4. Do either of the following:
   • Click Save Data Source; or 
   • Go to Selecting Additional Options.

Back to top

Selecting Additional Options

The following options are not required for the data source to function but can be used to apply additional automation when creating contacts.

• Assignment Options
• Send Notifications
• Creating an Auto-Responder
• WebHooks

Assignment Options

The assignment options allow you to assign leads on creation to users and companies. This will allow leads to be worked as soon as they are received into the CRM.

1. Assigning On - Check the box to activate the further assignment options you will set in this section.
2. Public - Check this box to make all leads created through this data source "Public". Public leads are viewable within the entire company and do not follow the other sharing options that may limit what contact users can see. The contact can be made "Private" again from the edit contact page (Client Dashboard).
3. Company - Select the company to assign the lead to. This will affect what users are displayed in the next option; Assigned To.
4. Assigned To - Select the user you want leads to be assigned to. You can select multiple users by holding down 'CTRL' while clicking on the users. If multiple users are selected the leads will be distributed evenly.
5. Additional Company Assignment - You can add secondary company assignments by company type. To set a company's type. go to the Admin Tab > Companies > Select the company to edit and change the option set for "Company Type".
6. Role Assignment - Assigned users secondarily by role. For the user role to be available, you need to make it assignable. See our article on Role Assignments here for more information.
7. Team Assignment - Select the team(s) (data source) you want the leads assigned to.
8. Notification - Select an email template to be sent to the assigned to rep on creation. The email template must have the Category set to "Notification" to appear in this menu.

Send Notifications

The send notification section can send email messages notifying parties when a contact is created. First, select the template. Then select users you wish to receive notifications. You can also add other email addresses in the "More People" box to notify someone who may not be a user within the CRM. You could use this to send a confirmation email to lead vendors to confirm you have received a lead they've provided.

Creating an Auto-Responder

The Auto-Responder can send a message to the newly created contacts upon file import.

IMPORTANT
Although this is available for Import Data Sources, you would really only set up an Auto-Responder on a Web Form Data Source to let a client know that their form submission has been received. Enabling the Auto-Responder on an Import Data Source will immediately email all contacts on the Import file.

1. Select the On checkbox to activate the feature, and then select an option from the E-Category dropdown menu. This is the email template type that has been applied to a template from the E-Marketing tab.
2. Select a campaign from the Template menu.
3. Select a sender you wish the message to come from the Sender menu.
   

WebHooks

Webhooks can be set to post lead information upon creation. You may do this as part of the Data Source to post leads into a phone dialer campaign so new leads can be contacted as soon as possible. For more information on setting up WebHooks,  visit our article here.

IMPORTANT
DO NOT SAVE YET! Saving the Data Source prior to uploading the CSV file will prevent the system from being capable of reading the file, and you'll need to start over by creating a new Data Source.

The next step is to upload the CSV file and map the data fields.

1. In the Import New Contacts from CSV section, click the Choose File button and select the .csv file from your local drive.
2. Leave the remaining items as is. If the CSV file has been set up correctly you should not need to change the other options here.
3. Click Save Data Source.
   
4. After saving the data source, the Import New Contacts from the CSV section will be replaced with the Import Another File section and an Import Fields section.

IMPORTANT 
DON'T CLICK "Start Merge" yet! Merging before fields have been mapped will cause all contacts to be uploaded with no data and you'll be left with blank contacts.

Mapping the Fields

1. Now you will select the fields from within the CRM you wish to map the column headers from the CSV file to. In the example below, we are mapping "fname" to "First Name", "lname" to "Last Name", "phone" to "Home Phone" and "email" to "Email".
   
   The dropdown menu starts with Standard (system) fields, if you continue to scroll you will find your CRM's Custom Fields and other additional options. TAdding the data as a note on the contact is an option if you do not wish to save the information to a field.
   
2. Now that you have mapped the fields, click "start merge" to import the contacts. However, you may activate some additional options discussed in the next section of the article before doing so. Now that the field mapping is set up, you can reuse this data source as long as the CSV file you are trying to upload is set up the same. Trying to upload a file containing a CSV file in a different format will not work. If you are working with a lead vendor, it is in both of your best interests to agree on a format for the file to be submitted, so that you do not have to repeat this process every time you wish to upload a file of leads from them.
   
3. Click Starts Merge. The contacts will be created and a push notification will appear in the bottom right confirming the process has started. Depending on the number of contacts and fields included in the CSV file you are attempting to upload, the process will take varying amounts of time. You should see the contact filter in the All Contacts list or a list setup to display leads coming in from the Data Source.
4. Once finished you will see a push notification in the bottom right, confirming the process has been completed.
   
   

NOTE
It is not possible to map Co-applicant fields. This is because the system cannot create the Primary contact and Co-applicant contact at the same time. If you have Co-applicant data that you would like to import, you may instead use Custom Fields.

Back to top

Article Version History: