Home Inspire Application File Imports Release Notes Sync Web Services FAQ Search

Prospect File

Intended Application

To insert new unverified, nonmember accounts into the database.

Notes

  • Header record is expected.  The first record will be skipped.
  • Any delimiter, except for [tab], can be used to separate columns.  The delimiter used is then specified at the time of file import.

File Structure

DATA COLUMN

DATA TYPE DATA REQUIRED? FORMATTING NOTES

Reference Number

Alphanumeric

No

 

 Unused - for future use.
Name Prefix Alphanumeric

No

  Allowed Values (Blank, Mr., Mrs., Miss, Master, Dr.) 
First Name Alphanumeric

Yes

   
Middle Name Alphanumeric No    
Last Name Alphanumeric Yes    
Name Suffix Alphanumeric No    
Birthdate Date/Time No YYYY-MM-DD  
Gender Alphanumeric No   Allowed Values (Blank, M, F, Male, Female)
Address Line 1 Alphanumeric No   This data must be included in order for all address components to be stored.
Address Line 2 Alphanumeric No    
Address Line 3 Alphanumeric No    
City Alphanumeric No   This data must be included in order for all address components to be stored.
Region/State/Province Alphanumeric No   This data must be included in order for all address components to be stored.
Postal/Zip Code Alphanumeric No   This data must be included in order for all address components to be stored.
Country Alphanumeric No   This data must be included in order for all address components to be stored.
Phone Formatted Numeric No See Article  
Email Address Alphanumeric No email@address.com  

Sample File

1:
2:
HEADER
34109||Jason|C|Smith||1984-11-11|M|100 Main St|APT 4||Newark|DE|19711|US|1(302)555-1212|jsmith@kognitivloyalty.com|charlie|54321

Kognitiv Logo

Please note: All external Kognitiv Loyalty links and references are directed to US datacenter unless specifically noted.

Tags:
Home: Kognitiv Loyalty © 2023 Kognitiv Corporation. All Rights Reserved.