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 |
