Customer Information Import

General

The customer information import allows you to import the main information for a customer. This import tool can also create a new customer within your company. The import system is not a real-time import. When you choose to import data, the import is queued and run when it gets to the front of the queue.

Importing a New Customer

In this example we will import a single new customer. To import customer information, start by navigating to Settings > Company > Import > Instructions & Samples.

Navigate the import section tree either using the “Search by keyword” field or by expanding areas of the tree.

Download the customer information sample file by clicking customerInfoSample.csv. Your sample file should contain only headers. Each row you add under the headers will contain import information for the customer.

These are the following headers for the file:

Headers

Description

action

This column will contain an action (i.e. add, update, remove) that will tell LoanPro what to do with the data.  In our case, we want to add a new customer so we will enter “add”.

customerId

This is the ID for the customer and since we are adding a new customer, we will leave this blank.

importId

This is an ID that we can set for the customer.  This is useful when doing other imports for this customer (e.g. importing a payment method).  Even though we are adding a customer we can set this ID so we will already know how to reference this customer for future imports.  If we don’t set an import ID, we will have to go into LoanPro to see what ID got assigned to this customer in order to do future imports.  We will leave this blank.

status

Customer statuses are customizable and so are referenced by ID in the import file. To find the ID of a customer status, navigate to Settings > Customer > Labeling > Status inside your company account. The ID of a status can be found in the ID column at the left of the status listing. We will enter 2 for a customer status of Active.

customerType

This is one of the three types of customer: individual, flooring customer, or company. The values we can enter are individual, flooring customer, or company. We will enter “individual” in this column.

firstName

This is the first name of the customer. We will enter “David”.

middleName

This is the middle name of the customer. We will leave this blank.

lastName

This is the last name of the customer. We will enter “Hicks”.

companyContact

This is only required if you chose a customer type of company or flooring customer and the name of your contact at the company. Since we chose individual, we will leave this blank.

companyName

This is also only required if you chose flooring customer or company as the customer type and is the name of the company. Since we chose neither type, we will leave this blank.

ssn

If individual was chosen as customerType, this is the social security number for US customers or social insurance number for Canadian customers. If company or flooringCustomer was chosen, this can be a social security number, social insurance number, or employer identification number. We will enter 999999999.

driversLicense

This is the driver license number of an individual borrower. Since this is not required, we will leave it blank.

idType

Enter the type of ID that will be used to identify the customer. The options are employerNumber and ssn.  We will enter “ssn”.

idNumber

This is either the EIN or SSN depending on your choice for idType. We will leave this blank.

creditLimit

This is the credit limit for a flooring customer. We will leave this blank.

birthday

This is the date of birth for individual customers formatted as YYYY-MM-DD. We will enter 1985-01-01.

gender

This is the date of birth for individual customers formatted as YYYY-MM-DD. We will enter 1985-01-01.

gencode

This is the date of birth for individual customers formatted as YYYY-MM-DD. We will enter 1985-01-01.

saleTransferPii

This field is used to identify if customer personal identifiable information can be sold or transferred to other entities.

email

This is the customer email address.We will leave this blank.

priPhone

This is the customer’s primary phone number and is required. We will enter 9876543210.

priPhoneType

This is the type of phone number that the primary phone number is. Options include: cell, fax, home, office, other, and cellSmartPhone. We will enter “cell”.

secPhone

This is the secondary phone number of the customer. We will leave this blank.

secPhoneType

This is the type of phone number that the secondary phone number is. Options include: cell, fax, home, office, other, and cellSmartPhone. We will leave this blank.

additionalPhone

This is an additional phone number for the borrower.  We will leave this blank.

additionalPhoneType

This is the type of phone or device that the additional phone number is pointed to. We will leave this blank.

password

If your company is subscribed for the customer website, this is that password the customer will need to be able to log into the website. We will leave this blank.

username

If your company is subscribed for the customer website, this is the username that the customer will need to log into the website. We will leave this blank.

creditScoreExperian

This is the customer’s Experian credit score. We will leave this blank.

creditScoreEquifax

This is the customer’s Equifax credit score. We will leave this blank.

creditScoreTransunion

This is the customer’s TransUnion credit score. We will leave this blank.

priAddress

This is the customer’s primary address. This field is required. We will enter “321 Oak Lane”.

priCity

This is the customer’s primary city. This field is required. We will enter “Schenectady”.

priState

This is the customer’s primary state or province. This field is required. We will enter “NY”.

priZipcode

This is the customer’s primary ZIP or postal code. This field is required. We will enter 12345.

priCountry

This is the customer’s primary country. This field is required. We will enter “usa”.

mailAddress

This is the customer’s mailing address. This field is required. We will enter “321 Oak Lane”.

mailCity

This is the customer’s mailing city.  This field is required.  We will enter “Schenectady”.

mailState

This is the customer’s mailing state or province.  This field is required.  We will enter “NY”.

mailZipcode

This is the customer’s mailing ZIP or postal code.  This field is required.  We will enter 12345.

mailCountry

This is the customer’s mailing country. This field is required. We will enter “usa”.

employerName

The name of the company the customer works for. We will leave this blank.

employerTitle

The customer’s job title. We will leave this blank.

employerPhone

The phone number of the customer’s employer. This will preferably be for the customer’s supervisor. We will leave this blank.

employerIncome

This is the amount the customer earns from their employer. We will leave this blank.

employerIncomeFreq

This is the frequency with which the customer earns the amount enter for employer income. For example, if you entered the customer’s monthly income, you would enter monthly for employerIncomeFreq. Options include: monthly, semimonthly, biweekly, weekly. We will leave this blank.

employerHireDate

This is the date the customer was hired by the employer. We will leave this blank.

employerPaydayFreq

This is the frequency with which the customer gets paid. Options include: monthly, semimonthly, biweekly, weekly. We will leave this blank.

employerNextPayday

This is the date on which the customer will next get paid. We will leave this blank.

employerAddress

This is the address of the employer. We will leave this blank.

employerCity

This is the city in which the employer is located. We will leave this blank.

employerState

This is the state or province in which the employer is located. We will leave this blank.

employerZipcode

This is the ZIP or postal code in which the employer is located. We will leave this blank.

employerCountry

This is the country in which the employer is located. Options include USA or Canada. We will leave this blank.

At this point, our import file looks like this:

Uploading the File

Now we can import the file by navigating to Settings > Company > Import > Upload & History inside your company account.

To upload, click 'Add'.

Select 'Customer' and 'Information' from the drop-downs provided. Either click the drop files to upload your import file, or drag and drop it in.

Click 'Save' to finish uploading the file.

Now click 'Validate' to verify your file. This tells the system to check the file for mistakes.

If mistakes are found, click E to see what the problems are. Fix any issues and then click 'Add' again to start the process over with the updated file. If there are no errors, click the import icon.

Once the data has been imported, you can check the customer manager to make sure the new customer is there. Navigate to Users > Customer Manager inside your company account.

Search for your customer to verify that they are in the system and then you're done.

Import Fields

Field

Description

Expected Values

Data Format

Requirements

action

Command Action instructions. What are you trying to do?

add, update, remove

Text

Required

customerId

Identifier for Customer. This is created by the system in an “add” action. If you wish to assign an independent value to the customer use the importId field. After the customer is created you can use the custom “importId” value as the customerId for all associated entities add actions (Payment methods, references, etc..). You also will be able to use the importId as the customerId field for subsequent “update” or “remove” actions.

Alpha/Numeric

Ignored/Omit on Add. Required on Update, Remove

importId

Custom identifier for Customer to be set by the Client. Please make sure this value is unique. It will cause confusion & issues with updates if you have duplicated importId’s, as import & other commands using that duplicated value may apply to any account with that value. If this is the case we recommend to use the system id for the customerId.

Alpha/Numeric

Recommended on Add, Not Required

status

This is the Status of the Customer. These are customizable & can be found in Settings>Customer>Labeling>Status.

Text

Not Required (if omitted company defaults will apply)

customerType

The type of the customer, as selected from the list.

individual, flooringCustomer, company

Text

Not Required (if omitted company defaults will apply)

firstName

Customer’s first name

Text

Required

middleName

Customer’s middle name

Text

Not Required

lastName

Customer’s last name

Text

Required

companyContact

If “customerType” is Company or Flooring the Contact Person’s Name

Text

Required if Company or Flooring customerType

companyName

The customer if a customerType of Flooring or Company is used, then this is the name of the Company that is the customer.

Text

Required if customerType is Flooring or Company

ssn

This is the SSN for US Clients & SIN for Canadian Clients

Number: 9 digits

Not Required

driversLicense

Photo Identification number

Number

Not Required

idType

specify if using the EIN, or SSN by selecting (EIN, SSN)

employerNumber, ssn

Text

Required

idNumber

Social Security Number (SSN) or Employer Identification Number (EIN)

Number

Not Required

creditLimit

If Flooring then the credit limit amount; ex. $100,000

100000

Number

Required if Flooring Customer

birthday

Date of Birth

Date: MM/DD/YYYY

Not Required

gender

Gender of the Customer

male, female, unknown

Text

Required

gencode

Generation Code

none, ii, iii, iv, ix, jr, sr, v, vi, vii, viii

Text

Not Required. If omitted then “none” will default

saleTransferPii

This field is used to identify if customer personal identifiable information can be sold or transferred to other entities.

1 (yes), 0 (no)

Number

Not Required. If omitted then "1" will default

email

Email address

Text

Not Required

priPhone

Primary Phone Number

Number: 10 digits

Required

priPhoneType

Type of phone associated with the primary phone number

cell, fax, home, office, other, cellSmartPhone

Text

Required

secPhone

Secondary Phone Number

Number: 10 digits

Not Required

secPhoneType

Type of phone associated with the secondary phone number

cell, fax, home, office, other, cellSmartPhone

Text

Required if secphone is provided

additionalPhone

To add additional phone numbers to the customer you must provide a list separated by a semi-colon. There must also be an equal number of phone type descriptions in the next field with the header name of “additionalPhonetype” : e.g. : 2031235254;8016300000

Number: 10 digits

Not Required

additionalPhoneType

cell;home

cell, fax, home, office, other, cellSmartPhone

Text

Required if additionalPhone is provided

password

Password for customer to access customer website, must follow the password requirements. [At least 1 uppercase letter, At least 1 lowercase letter, At least 1 number, At least 6 characters]

Alpha/Numeric

Not Required

username

Username to log into customer website. This must be unique.

Alpha/Numeric

Not Required. If omitted will automatically be set

creditScoreExperian

manually enter the credit score for Experian

Number

Not Required

creditScoreEquifax

manually enter the credit score for Equifax

Number

Not Required

creditScoreTransunion

manually enter the credit score for Transunion

Number

Not Required

priAddress

Primary Address

Text

Required

priCity

Primary Address City

Text

Required

priState

Primary Address State (2 digit)

state abbreviation codes

Text: 2 digits

Required

priZipcode

Primary Address Zip Code

Alpha/Numeric

Required

priCountry

Primary Address Country (2 digit) usa, can

usa, can

Text: 3 digits

Required

mailAddress

Mailing Address

Text

Required

mailCity

Mailing City

Text

Required

mailState

Mailing State

state abbreviation codes

Text: 2 digits

Required

mailZipcode

Mailing Zip Code

Alpha/Numeric

Required

mailCountry

Mailing Country (2 digit) usa, can

usa, ca,

Text

Required

employerName

Employer Name

Text

Not Required (can contain text)

employerTitle

Customers Job Title

Text

Not required (can contain text)

employerPhone

Employers Phone Number

Number: 10 digits

Not required

employerIncome

Customer Income on the frequency selected below i.e 36000.00

Number

Not required

employerIncomeFreq

The frequency Customer gets paid the employer income above

monthly, semimonthly, biweekly, weekly

Text

Required

employerHireDate

Date customer was hired at employer

Date: MM/DD/YYYY

Not Required (must be a date)

employerPaydayFreq

Frequency of payroll

monthly, semimonthly, biweekly, weekly

Text

Not Required (monthly, semimonthly, biweekly or weekly)

employerNextPayday

Customer’s next payroll date

Date: MM/DD/YYYY

Not Required (must be a date)

employerAddress

Employer Address

Text

Not Required (can contain text)

employerCity

Employer City

Text

Not Required (can contain text)

employerState

Employer State

state abbreviation codes

Text: 2 digits

Not Required (can contain text)

employerZipcode

Employer Zip Code

Alpha/Numeric

Not Required (can contain alphanumeric characters and the ‘-‘ character)

employerCountry

usa, can

Text: 3 digits

Not Required (can be either ‘US’ or ‘Canada’)


How did we do?


Powered by HelpDocs (opens in a new tab)