Importing leads

You can import leads into NexJ CRM.

Import data is typically prepared by a business administrator, who loads it into a staging area in the system. Advisors can then review and correct the information, check to see if it matches any existing leads, and complete the import.

Lead import data is often prepared and imported directly by advisors, without involving an administrator. This is particularly true when importing from CSV files without using an import package.

Before business administrators can import lead records from outside data sources onto a staging area in NexJ CRM, they must prepare the information for import.

Preparing lead data

When you are importing leads, you have two possible ways to format your data. The simplest way is to create a Comma Separated Value (CSV) file that captures basic contact information for the leads, along with optional information about the market segment and sales concepts that you want to associate with the leads. Alternatively, you can create a full import package to import more complicated data, such as leads with multiple phone numbers.

Lead data must minimally contain the first and last names for each lead. Each lead must have contact information in the form of an email address or phone number. You can also associate each lead with a market segment and sales concept, or include information about the lead's company and position.

Sales and marketing classification

You can classify leads by the market segment to which they belong and to the sales concept with which they are most closely associated.

NexJ CRM includes a number of default marketing segments and sales concepts that you can use to classify your leads before and after you import them into the system. Your organization may also include additional classifications for each of these areas.

Market segments

You can associate leads with the following market segments:

• Starting Out
  Leads in this segment are just getting into the market. They are typically just out of post-secondary education, or buying their first home.
• Pre-Retirement
  Leads in this segment are established in the workforce.
• Retirement
  Leads in this segment are retired or semi-retired.

Sales concepts

You can associate leads with the following sales concepts:

• First-Time Home Buyer
  Typically associated with leads in the Starting Out market segment, this concept focuses on products that pertain to people purchasing their first home.
• Mortgage Needs
  Typically associated with leads in the Pre-Retirement market segment, this concept focuses on products that pertain to the securing, negotiation, and renegotiation of mortgages.
• Retirement Income
  Typically associated with leads in the Pre-Retirement market segment, this concept focuses on products to help people plan and prepare for retirement.
• Survivor Needs
  Typically associated with leads in the Pre-Retirement and Retirement market segments, this concept focuses on products to provide benefits to surviving relatives.
• Wealth Transfer Planning
  Typically associated with leads in the Retirement market segment, this concept focuses on products to transfer funds between accounts or parties in order to maximize benefit.

Creating import packages

When you are importing leads, creating import packages is optional, but the CSV file for your leads data must follow the default structure described in Preparing lead import CSV files.

An import package is a ZIP archive that contains the following files:

• One or more CSV files containing the leads data that you want to import into NexJ CRM.
• One mapping file for each CSV file. You create the mapping files using the NexJ Data Mapping Tool. The mapping file allows NexJ CRM to map your CSV file columns to lead attributes in your database.

Import packages must be smaller than 10MB. Packages larger than 10MB cannot be imported.

The creation of an import package involves the following steps:

1. Creating import package CSV files. For more information see, Creating import package CSV files.

2. Creating mapping files and generating import packages. For more information, see Creating mapping files and generating import packages.

Creating import package CSV files

Your legacy leads data must be in CSV format before it can be imported into NexJ CRM. Depending on your legacy contact-management system, you might have one large CSV file containing all the data or several CSV files, one CSV file for each table you export. The first row in each file must be a header row, which contains the names of the columns.

Using your old contact management system, export the data from existing legacy system into CSV format. The exact directions for creating the CSV files vary depending on your legacy contact-management system.

Before you generate CSV files, verify that you have an empty directory for storing these files on your file system and note its location.

Example CSV files for importing leads

Use a format similar to the one shown in the following CSV file: Leads.csv

Preparing lead import CSV files

You can carry out a simple lead import, which imports leads directly from a CSV file into NexJ CRM.

A simple lead import allows you to create a set of leads with the following information:

• First name
• Last name
• Email address
• Phone number
• Market segment
• Sales concept
• Company name
• Position at the company
• Zip code

It is mandatory that every lead has a value provided for the Last Name and First Name fields. In addition, each lead must have a value for the Email field, the Phone field, or both.

Even though you can create the CSV file directly in a text editor, it is best to create it using a spreadsheet program. The following instructions assume that you already have a file containing leads data and that it is in a format that can be opened by a spreadsheet program.

If you receive your data as a CSV file from a third party, you should still open it to ensure that the contents meet the requirements for import.

To create the CSV file:

1. Open your data in a spreadsheet program.
   The file should be organized so that each row of the spreadsheet represents a different lead, and each column represents a field of information about that lead.
2. Edit the first row of the spreadsheet. It can contain the following column titles:
   • ID
   • First Name
   • Last Name
   • Email Address
   • Phone
   • Market Segment
   • Sales Concept
   • Company
   • Position

   • Zip Code

   
   

3. Review the data in the spreadsheet to ensure that it meets the following restrictions for each column:
   Data requirements for simple lead import
   

   Column	Data requirements
   ID	A unique value. The recommended practice is to populate the column with a series of ascending numbers. Values are not imported into NexJ CRM. Values can be alphanumeric.
   First Name	Maximum 25 characters.
   Last Name	Maximum 60 characters.
   Email address	Maximum 80 characters.
   Phone	Maximum 80 characters.
   Market Segment	Must be one of the following values: STARTINGOUT PRERETIREMENT RETIREMENT
   Sales Concept	Must be one of the following values: HOMEBUYER MORTGAGENEEDS RETIREMENTINCOME SURVIVORNEEDS WEALTHTRANSFER
   Company	Maximum 60 characters.
   Position	Maximum 100 characters.
   Zip Code	Maximum 15 characters. This field does not have format restrictions and can be used for both zip and postal codes.

   

   Fields that exceed the maximum lengths specified in this table will be truncated during import. Invalid values in the Market Segment or Sales Concept columns will be ignored.
4. Save the file as a Comma Separated Value (CSV) file.
5. In the majority of cases, the default values for saving as a CSV file are sufficient. However, if you are given a choice of delimiters when saving your file, you should select a comma (,) as the field delimiter and a double-quotation mark (") as the text delimiter.

The leads contained in the CSV file are now ready to be imported into NexJ CRM.

Creating mapping files and generating import packages

Once you have obtained a set of CSV files containing the leads data you want to import and the target definition file, you must create mapping files. The mapping files allow NexJ CRM to load leads data into the appropriate columns in the database. You need one field mapping file for each CSV file and one file mapping file that lists all the CSV and XML files included in the package.

Use the NexJ Data Mapping Tool to generate the file mapping and field mapping files and to create the import package containing all the files used by NexJ CRM during the import process.

For assistance with installing the NexJ Data Mapping Tool, contact your system administrator.

To create the mapping files using the NexJ Data Mapping Tool:

1. Open the NexJ Data Mapping Tool.
2. Click Create/Modify Mapping.
3. In the dialog that appears, browse to find the following information:

   Data Location
   The directory where the CSV files containing your data are stored.
   Target Definition File
   The definition file you generated in NexJ CRM using the Contact Import > Generate Definition File command.

   

   When you are importing leads, you can ignore the Target Definition File field.

   Mapping Template
   If you have been provided with a mapping template file or if you are continuing work on an existing mapping file, specify the name and location of the file. Otherwise, leave this field blank. To ensure the mapping template file appears in the drop-down list, place the file in the directory specified in the Data Location field. Otherwise, use the Browse button to navigate to the mapping template location.

4. Click OK. All CSV files you generated are listed in the Source Files in Data Location column and all possible target field categories are listed in the Type of Data in File column. The number of columns in each CSV file is listed in the Mapping Fields column.
5. For each CSV file, select the target field category in the Type of Data in File drop-down. If you only have one source file or if there is no likely equivalence between a CSV file and any target category, assign the All field category. Assigning a field category limits which fields are displayed when you are assigning a source field to a target field. After you have selected the target field category, the Source Field drop-downs and Target Field names display.
6. Specify how null fields are treated. By default, any null field is converted into a null field. If you want to specify a different value for null fields, select Use Null Converter. The Null Converter column appears below. You can specify the default value which will be used for all null fields in the Value field and click the Apply Null Converter button. Otherwise, you can specify the value to be used for each field in the Null Converter column. To remove the default value from all fields, click the Erase Null Converter button.

7. Using the drop-down lists, map a column name from the Source Fields column to a field in the Target Fields column. When a source column has been assigned to a target field, a green check mark appears next to the column name in the drop-down list. In addition, the plug icon next to the field name appears plugged in. For details, see Mapping one-to-one fields and Mapping many-to-one fields.

   

   The drop-down lists contain the column name as well as a sample value for that column. The sample value is populated with an available value from within the first 1,000 records in the import package.

   For any field in your legacy data that has no equivalent in the NexJ CRM data structure, create a new User Field subcollection attribute. Assign the source field to this new User Field. To unmap a source field, click the Unmap Field button. You do not need to map every column in a source file to a target field. However, any columns not mapped to a field will not be imported into NexJ CRM.

8. If you want to save the mapping information, either to share it with other users or to continue working later, click Save Mapping Template. In the Create Mapping Template dialog, specify where you want to save the mapping file and click Save.
9. When you have completed all mapping work, click Generate Import Package. In the Create Import Package dialog, specify where you want to save the package and click Save.

After creating your import package, verify its size and contents.

The import package must be less than 10MB. If it is greater than 10MB, you will not be able to import the package. If this is the case, you should split the data into multiple data sets and rerun the package generation for each data set separately.

The generated package should contain the following files:

• One or more CSV files containing your legacy data.

• One file mappings file called fileMappings.xml. It lists all the CSV files containing the legacy data and the related XML field mapping files.

  

  You can specify the encoding character set to be used for the import process in fileMappings.xml by adding the encodingType property to the source code:

  <mapping encodingType="<characterSet>">   <fileMappings>... </mapping>

  where <characterSet> is the value you provide for the encoding character set. For example, specify CP-1252 to indicate that the import package data is using the CP-1252 encoding. By default, the UFT-8 encoding is used. The character set for the generated package must match the character set you specified.

• One field mapping file for each CSV file. The mapping file names are based on the names of the CSV files. For example, if the CSV file is called TBL_CONTACT.csv, then the mapping file is called TBL_CONTACT_mappings.xml.

Mapping one-to-one fields

Most columns in the source CSV files are associated with a single field in NexJ CRM. Mapping a source field to a target field depends on the format of the target field.

• For fields in string format, choose whether text in Rich Text Format (RTF) should be converted to plain text. NexJ CRM currently supports only plain text in all fields. In the Text Converter field, if you select rtf2plain, then all RTF formatting codes will be removed during import. Otherwise, the RTF formatting codes will be included in the field.
• For fields in date format, specify the date format in the Format field. Choose one of the formats available in the drop-down list or enter a new format by typing it in the field.
• For fields in the timestamp (date and time) format, specify the format in the Format field. Choose one of the formats available in the drop-down list or enter a new format by typing it in the field. Specify the location for determining the time zone in the Unit field.
• For fields in the boolean format, the complete list of values in the column appears below the source field name. For each possible value, specify whether it should be imported as True or as False.
• For other fields with a limited set of possible values, such as Activity Type or Gender, the complete list of values in the column appears below the source field name. For each possible source field value, specify the equivalent target field value.

Mapping many-to-one fields

Several fields in NexJ CRM are actually subcollections of information.

For example, your legacy contact information system might have the following fields:

• Business Address Line 1
• Business Address Line 2
• Business City
• Business Zip Code
• Home Address Line 1
• Home Address Line 2
• Home City
• Home Zip Code
• Vacation Address Line 1
• Vacation Address Line 2
• Vacation City
• Vacation Zip Code

However, in NexJ CRM, there are only fields for Address Line 1, Address Line 2, City, and Zip Code. You can create as many addresses as required. Each complete address becomes a subcollection of fields. For each address, you would indicate whether it is a business, home, or vacation address.

Addresses, Telcoms, Categories, Custom Fields, and User Fields are all subcollections. These subcollections have a Copy Row button and a Delete Row button in the Target Field column. Rather than a one-to-one correspondence between a column in a source CSV file and a field in the target definition file, you can create any number of subcollections for each of these fields.

To map a column to a subcollection:

1. Select a source field (such as BUSINESSPHONE) for the target subcollection. For example, Telcom.
2. Select a target field name in the Sub Collection Attribute column. For example, Communication Value.
3. Select the Type Name to indicate which subcollection the field belongs to. For example, Business.
4. Depending on the Sub Collection Attribute value, specify the Type/Text Converter details.
5. If you want to add another field to the subcollection or if you want to add another subcollection, click the Copy Row button.

Importing packages

Before you can import leads data on the Import workspace, you must have been granted the ImportProcessView and ImportProcessManage privileges.

Once you have obtained an import package containing the CSV files and mapping files, import it to the staging server using the Import workspace.

An example of the Import workspace is shown in the following screen capture:

To import the package on the Import workspace:

1. Navigate to the Import workspace and click the Import button

   

   in the Import data table toolbar.
2. Select Import Leads.
3. In the Import Package field, click the Select button

   

   , browse to find the required import package on your system, and click Open.
4. Select a select a source type, enter a source name, and select an owner who is the user assigned to the leads.
   

5. Click OK and wait for the import job to complete. The Start Time column in the data table shows when you started the import.

   

   You can sort your import jobs by when they started in the data table by clicking on the sort arrows beside the Start Time column title.

   The data table shows the following information in the Stage and Status columns in the following consecutive order as the import job progresses:

   Order	Stage	Status
   1	Import into Staging	Queued
   2	Import into Staging	Running
   3	Review Match Results	Waiting on User

   The Stage column changes to display "Review Match Results," and the Status column displays "Waiting on User," proceed to reviewing the match results, as described in Import contacts and leads data.

If the import job fails, the status of the import job changes to "Failed" in the Import data table.

To see the error log for a failed job, select the job in the data table on the Import workspace, click the View reports button

Searching for import jobs and filtering the data table

To find your import job in the Import data table on the Import workspace, you can enter your job's name in the search field or use the following filter chips that are provided by NexJ:

• End Time - The end date and time for your job.
• Import Type - The type of import (for example, contact import or lead import).
• Stage - The stage for your job (for example, Review Match Results).
• Start Time - The start date and time for your job.
• Status - The status of your job (for example, Failed, Completed, or Waiting on User).

You can also add additional filter chips. For more information about searching for and filtering records, see Searching and filtering in NexJ CRM.

Deleting import jobs

You can delete an import job before it is completed from the Import workspace and if it has one of the following statuses: Failed, Completed, or Waiting on User. Select the job that you want to delete and click the Delete button 

The following table describes what happens when you delete an import a different stages:

This action cannot be undone. The import job is permanently deleted.

Reviewing imported data

Business administrators and end users can review the imported data to verify that all data is provided and accurate, and then complete the import. For more information about this process, see Import contacts and leads data.