User-Device Mappings Import Guide

CSV Order Friendly Name Description Required for new record? Required for update? Other Requirements Sample CSV Data
1 Device ID The ‘Device ID’ that the below user is assigned to. YES YES Must be an exact match to an existing device in the database (case sensitive). WS1759105428
2 User ID The ‘User ID’ that the above device is assigned to. YES YES Must be an exact match to an existing user in the database (case sensitive). 18F98L1
3 Start Date The first (initial) date that the device is assigned to the user. This can be a future date, the current date or a historic date. NO NO Needs to be a valid date (DD/MM/YYYY). If blank, today’s date will be used. 17-11-2015
4 End Date The date that the device is unassigned from the user. This can be a future date, the current date, a historic date or blank. NO NO Needs to be a valid date (DD/MM/YYYY) or blank. 17-11-2015