Information on the Add Ons Import to RMS, and the data required.

Overview

Add-ons are a Category Class used to manage additional bookable items that can be added to an existing reservation. This article provides details on the requirements for the Add-On import in RMS.

Import Information

• The import file must be in a comma-delimited .csv format (Field Delimiter), see the template at the bottom of this article.
• Data fields including a comma should be surrounded by "double quotes"(Text Delimiter).
• Line returns should be replaced with the pipe character '|'.
• Microsoft Excel is able to save using a .csv format that should match these requirements.
• Header rows may be left in place as RMS can determine if there is a header row.

Field Order

Date Formats

All date fields must use the DD-MMM-YYYY format (25-JAN-2026).

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:

1. Navigate to Reservations > Reservation Search for data review.
2. Choose a 'Search On' field.
3. Input the Search Criteria.
4. Select the 'Search' icon.
5. Select the Reservation Number to open the reservation.
   
    
6. Navigate to the the Add On menu within the reservation screen.
7. Confirm the Add Ons Type.
8. Confirm the Add Ons number.
9. Confirm the From Date.
10. Confirm the To Date.
11. Confirm the Amount.
    
     

Downloadable Import File

The attached import file below contains the required file format for an add ons import. Download the file and review the column headers. Populate the file with the add on, ensuring that each line contains an existing Legacy ID in RMS.

Next Article: Data Validation & Trial Imports