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.
