Home Inspire Application File Imports Release Notes Sync Web Services FAQ Search

Location Import with Timezone File

Intended Application

To insert or update locations in the database with location-specific timezone information.

 

Notes

  • A header record is required.  The first line is skipped when processing.
  • Any delimiter, except for [tab], can be used to separate columns.  The delimiter used is then specified at the time of file import.
  • If an existing location is found, the provided information will be updated.  If not, a new location will be created.  Locations are matched based on the Location External Reference.
  • Accepted values for "Daylight Savings Time" column are -1, TRUE, T (if DST is observed) and 0, FALSE, F (if DST is not observed).
  • If location custom fields are used, the column names must be in the header, in the proper position, and must match the associated custom field external references.

 

File Structure

DATA COLUMN

DATA TYPE DATA REQUIRED? FORMATTING NOTES

Business Unit External Reference

Alphanumeric

No

   If not entered, the business unit entered at time of import will be referenced.
Location Name Alphanumeric Yes   Must be unique systemwide. 
Location External Reference Alphanumeric Yes   Must be unique systemwide.
Location Description Alphanumeric No    
 Location Address Line 1  Alphanumeric   No    
Location Address Line 2  Alphanumeric No    
Location Address Line 3 Alphanumeric No    
Location City Alphanumeric No    
Location Region/State/Province Alphanumeric No    
Location Postal/Zip Code Alphanumeric No    
Location Country Alphanumeric No   Use the ISO recognized two-character abbreviation.
Location Primary Email Alphanumeric No    
Location Secondary Email Alphanumeric No    
Location Phone Number Formatted Numeric No See Article  
POS Category External Reference Alphanumeric Yes    
Standard GMT Hour Offset Decimal Yes   When DST (if applicable) is not being observed.
Daylight Savings Time Boolean Yes   See notes
Location Custom Fields Varies No   A column must be present for each location custom field cited.  The column name must match the location custom field external reference.

 

 

Sample File

1:
2:
BUNIT_EXTREF|LOC_NAME|LOC_EXTREF|LOC_DESC|LOCADD1|LOCADD2|LOCADD3|LOCCITY|LOCREG|LOCPOST|LOCCNTRY|LOCPRIMEMAIL|LOCSECEMAIL|LOCPHONE|POSEXTREF|GMT|DST|SQFEET|ALLOWANCE
1|Royal Casino|RC|The Royal Casino in Delaware|300 Creek View Rd|Suite 202||Newark|DE|19711|US|support@kognitivloyalty.com||1-(302)283-0200|DEFAULT|-5|TRUE|1500|10

* In the above example, the column names of SQFEET and ALLOWANCE refer to custom fields.

Kognitiv Logo

Please note: All external Kognitiv Loyalty links and references are directed to US datacenter unless specifically noted.

Tags:
Home: Kognitiv Loyalty © 2023 Kognitiv Corporation. All Rights Reserved.