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 |
|
|