Access Number Import

Overview

This file allows the import of access numbers for boomgates or other access control systems from a standard Comma Delimited file into the RMS system.

Both guest access numbers (linked to reservations) and Alternate Users can be imported using this import type. Alternate users are not linked to a reservation and instead have a User Name such as 'Police', 'Cleaner', 'Staff Use' etc.

You must be able to provide a CSV file in the format as indicated below. It may be necessary to seek technical advice in order to create your file in the format that RMS requires.

Sample File - Pending

Important Information

• Guest Access Numbers can only be imported after Reservations have been imported or created in RMS.
• The file to be imported must be in a comma delimited CSV format (Field Delimiter).
• If a data field within this file contain commas, it should be surrounded with "double quotes" (Text Delimiter).
• Microsoft Excel is able to save using a CSV format that should match these requirements.
• RMS is able to determine whether the first record is a header record or not, thus it is not necessary to strip the header record (field names) prior to the import
• Each line should have either a Res Folio Number OR a User Name. If both are supplied then the file will not import.
• Reservation Folio Numbers must match those imported during the Reservation Import (Saved to Res Spare Field 10).
• Lines with a User Name specified will create an Alternate User record in RMS.
• All Date fields must be supplied in DD-MMM-YYYY format.​
• All Time fields must be supplied in HH:MM 24 hour format.