LobbyCentral Import Layout Specifications (on-premise)
- One customer per row, comma delimited.
- Terminate each row with a carriage return.
- Do not include header names in the first row.
- If data is not supplied for a field, leave it empty. Do not use a single space. i.e. If not providing middle name: Test,,Customer vs Test,A,Customer
- Do not qualify text with double-quotation marks.
- Do not exceed the max field size shown in the spec layout.
| Fieldname
|
Type
|
Length of Format
|
| First Name
|
String
|
25
|
| Middle Name
|
String
|
20
|
| Last Name
|
String
|
20
|
| Account ID Number
|
String
|
50
|
| Account ID Type
|
Number
|
Use a valid account type as defined in the Account Types custom types table.
Account types are defined in the Look-up Table Administration.
Use 0 if an Account ID is not supplied or if you do not wish to specify a type.
|
| Address
|
String
|
100
|
| City
|
String
|
50
|
| State
|
String | 20 |
| Zip | String | 15 |
| Country | String | 20 |
| Company Name | String | 100 |
| Date of Birth
|
Date
|
mm/dd/yyyy Leave field empty if not supplied
|
| SSN
|
String
|
XXX-XX-XXXX
|
| Phone
|
String
|
XXX-XXX-XXXX
|
| Email
|
String
|
255
|
| Kiosk Scan ID
|
String
|
255
|
| mobilePhone
|
String
|
XXX-XXX-XXXX |
|
|