Overview
A Boomgate is a type of barrier commonly used in traffic control systems, typically at entry or exit points such as parking lots, toll booths, or security gates. Boomgate access control defines the format for access codes. This article provides information on the requirements for the Boomgate Access Import in RMS.
Import Information
- The import file must be in a comma delimited .csv format, see template at the bottom of this article.
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- The fields within this file must not contain commas.
- RMS is able to determine whether the first record is a header record.
Field Order
| Order | Field Name | Field Type | Required | Max Characters | RMS Equivalent |
|---|---|---|---|---|---|
| 1 | Legacy Res ID | Alpha Numeric | If no Username | 50 | Legacy Reservation number code is attached to |
| 2 | User Name | Alpha Numeric | if no Legacy Res ID | 20 | User names for alternate user |
| 3 | Access No | Numeric | Y | 10 | |
| 4 | Rego | Alpha Numeric | N | 20 | |
| 5 | Expiry Date | Date | Y | 10 | See Date Format Below |
| 6 | Expiry Time | Time | Y | 10 | See Time Format Below |
| 7 | Note | Alpha Numeric | N | 100 | |
| 8 | Access Type | Numeric | Y | 1 |
|
| 9 | Property Name | Alpha Numeric | Y | 50 | |
| 10 | Zone | Alpha Numeric | N | 20 |
Date Format
All date fields must use the format DD-MMM-YYYY (25-JAN-2026).
Time Format
All time fields must use the format HH:MM:SS (10:00:00AM).
Import Validation
To ensure that your data is clean, consistent, and ready for the Live production environment after it has been validated and imported into the Training environment, follow these steps:
- Open a reservation and navigate to the 'Rego/Access Nos' menu.
- Confirm the 'Access No' imported.
- Confirm the 'Expiry' date and time.
Downloadable Import File
The attached import file below contains the required file format for the boomgate access import. Download the file and review the column headers. Populate the file with the data, ensuring that each line contains a Legacy Reservation ID, Access number, Rego number and Expiry specifics.
| > Next Article: | |
| Data Validation & Trial Imports |
Comments
0 comments
Please sign in to leave a comment.