Device Import File

Intended Application

To insert or update kiosk profiles in the database.

Notes

No header. First record is processed.
Any delimiter, except for [tab], can be used to separate columns. The delimiter used is then specified at the time of file import.
Device Ids matching an existing kiosk profile will be updated. If Device Ids are not found, new kiosk profiles will be inserted into the database.
Device Categories are used to facilitate categorization of devices.

File Structure

DATA COLUMN	DATA TYPE	DATA REQUIRED?	NOTES
Kiosk Device Id	Numeric	Yes	Must be between 1000 and 6000
Device Category External Reference	Alphanumeric	Yes
Device Description	Alphanumeric	Yes
Location External Reference	Alphanumeric	Yes

Sample File

                        
                                1:
2:

                                1014|FLOOR1|Kiosk near the front door.|CASINO
1015|FLOOR2|Kiosk near the VIP entrance.|CASINO