Import Customer File

If you need to import your customers to LobbyCentral Cloud, you may do so by following these guidelines. Please remember that your data file must conform to the file layout specifications detailed below.

Import Layout Specifications

  • All columns are required.  Pass an empty value for column field not used.
  • File must be formatted as a comma delimited or tab delimited file. Do not qualify text fields with quotation marks.
  • Fields may not contain ' (single quote).
  • Field data cannot exceed indicated field length.

Field Name Type  Max Length         Format or Comment
First Name  string  25 
Middle Name string  20
Last Name  string  20
Account Number string  50
Account Type Number   Use a valid account type as defined in the Account Type Look-up table or   pass 0 for no type.
Address string  100
city string  50
state string  20
zip string  15
country string  20
Company Name (visitor center only) string 100
Date of Birth string   mm/dd/yyyy
SSN string 20 000-00-0000
Phone string 15 000-000-0000
Email string  255
Mobile Phone String 20 000-000-0000
Should Delete Number   Indicates if the customer record should be marked inactive. Use 0 for no or 1 for yes.
Internal Customer ID string  50 Your Customer ID

The import process will create a customer record, for each record in the file that does not exist in the LobbyCentral database. If the option to create a callback request is selected, a request will be created for all customers in your data-file.

Note: Maximum number of records that can be imported at one time is 500. Files larger than 500 records, may be imported using the Data Tools program, which can be downloaded at http://www.lobbycentral.com/download/, under On-Premise Downloads. 

  • File to Import: Click the Choose File button to select the file to import.
  • Column Delimiter: Select whether it is comma or tab.
  • Create a Callback Request: Unless you are creating a Help Desk to be used in-house, leave this information blank.

Importing Customer Files

Once your file is created, go to  Tools > Administration > Import Customer File to upload the file.
  1. Select Choose File, and attach the file to import.
  2. Select Column Delimiter: Comma.
  3. Select Import File.

Still need help? Contact Us Contact Us