Information on the requirements for the Quoted Rate Import is available in RMS.
Import Information
- The file to be imported must be in a comma-delimited .csv format (Field Delimiter), see the template at the bottom of this article.
- If a data field within this file contains commas, it should be surrounded with "double quotes" (Text Delimiter).
- Line returns should be replaced with the pipe character '|'. (Usually found on the backslash key).
- 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.
⚠ Important: The Quoted Rate Import will override any existing rates on reservations and record the nightly breakdown. Reservation Stay Dates not covered by the import will display a value of $0.
✎ Please Note: RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.
Field Order
| Order | Field Name | Field Type | Required | Max Characters | RMS Equivalent |
|---|---|---|---|---|---|
| 1 | Legacy Res ID | Alpha Numeric | Y | 50 | Legacy Res ID |
| 2 | Date | Date | Y |
Date Rate Applies See Date Format |
|
| 3 | Total_Rate | Numeric | Y | Base Rate Amount | |
| 4 | Charge Type | Alpha Numeric | Y | Rate Type Name | |
| 5 | MarketSegment_ID | Numeric | N | Market Segment ID |
Date Format
All date fields must use the format DD-MMM-YYYY (25-JAN-2025).
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:
- Navigate to an existing reservation for data review, Click 'Total Rate' to review the rates imported.
- Review the 'Base Rate' column to confirm the rate imported for each night.
★ Tip: Repeat this process with additional reservations to verify that the entire import was successful. Ensure that each night's base rate have correctly populated.
Downloadable Import File
The attached import file below contains the required file format for the Quoted Rate Import. Download the file and review the column headers. Populate the file with the data, ensuring that each line contains a Legacy ID, Date, Total Rate and Rate Type.
Comments
0 comments
Please sign in to leave a comment.