Lifestyle Member Import

 

Back Office > Touch Settings > Touch POS Terminals > Lifestyle > Lifestyle Member Import

 

Description

 

This menu item provides the ability to import Members as well as update existing Members and assign them to specific LifeStyle Groups (Interest Groups). The data imported can be sourced from 3rd party systems, as long as it in a format that is compatible with the requirements outlined below.

 

 


Import File Format

 

The file must be a TAB separated .TSV file type, and must be in the correct format and the data must be in the order as shown. Note :  Field size limits are strict.  Do not exceed the size or the import will fail.

 

Field

Type

Size

Description

EmployeeID

STRING

32

Unique identifier for the Member and used to identofy a Member when updating data from a 3rd party system.

Member_Surname

STRING

30

Employee's surname, eg: Day.

Member_Firstname

STRING

30

Employee's first name, eg: Grahame.

Member_Address1

STRING


Employee's address, eg: 135 Ferny Way.

Member_Address2

STRING

30

Second Address Line

Member_Address3

STRING

30

Employee's suburb, eg: Ferny Hills.

Member_Postcode

STRING

8

Employee's postcode, eg: 4055.

Member_Home_Phone

STRING

20

Employee's home phone, eg: 0733518777.

Where possible remove spaces and/or international + prefixes.

Member_DOB

DATE

-

Employee's birthday
 eg: 1948-03-15 (yyyy-mm-dd).

Member_State

STRING

20

Employee's state, eg: QLD.

Member Photo Filename

STRING

255

Filename of the employee photo.  The path is relative to the import file.

 eg:  Day_Grahame.jpg or 1234567.jpg

 

Example:

 

1002 Cage Nicolas 38 Windsor Avenue 7003 08 9342 3432 1974-05-05T00:00:00.000 WA
1004 Pitt Brad 14 Residence Ave Shelley Beach 4022 1962-07-15T00:00:00.000 QLD
1006 Farrell Colin 1 Davey Rd Kallangur 4523 1969-07-15T00:00:00.000 QLD
1007 Dench Judy 1942-09-10T00:00:00.000
1009 Hawn Goldie 1 Davey Rd Kallangur 4523 2014-07-29T00:00:00.000 QLD


Photo's

 

Employee photos should be provided in JPEG format (JPG extension) filename is Surname_Firstname.jpg or EmployeeID.jpg no larger than 500 pixels height/width.  We do scale on import the size limit is to help with transporting files between sites.

 

Example:

 

1001.jpg
1002.jpg

 


Related Topics

 

  1. Accounts
  2. Customers/Members
  3. POS Configurations
  4. POS Operation
  5. POS Operations
  6. Reception/Kiosk And Access Control Features
  7. Reports - Lifestyle
  8. Touch Settings