Intended Application
To insert or update locations in the database.
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.
- Location timezone will be set to the corporate timezone.
- 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 | ||
| 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|SQFEET|ALLOWANCE 1|Royal Casino|RC|The Royal Casino in Delaware|300 Creek View Rd|Suite 202||Newark|DE|19711|US|[email protected]||1-(302)-283-0200|DEFAULT|1500|10 |
* In the above example, the column names of SQFEET and ALLOWANCE refer to custom fields.
