A reservation import is a convenient method of transferring historical, current, and future reservations into RMS.
Import Information
Information on the requirements for the Reservation Import is available in RMS.
- You can only import reservations after you have imported or created Categories, Areas, and Clients in RMS.
- The import file must be in a comma-delimited .csv format (Field Delimiter) and match the required format; see the template at the bottom of the article.
- If a data field within this file contains commas, you should surround it with "double quotes" (Text Delimiter).
- You should replace line returns 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.
- Enter the Arrival and Departure fields as a date and time, for example 2027-12-06 14:00:00. See Date Formats below.
- Following a successful import of reservations, run the Update Housekeeping Schedules Utility once Housekeeping has been configured.
Each row must have exactly 67 fields, in the order shown in the Field Order table below. A row with more or fewer fields stops the file with the error Record Length MisMatch: Expecting 67 Fields Got followed by the number of fields found. Start from the downloadable template at the bottom of this article, which has all 67 columns.
Please Note! RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. For more information, see Understanding RMS Help Centre Articles.
Legacy IDs
There are multiple Legacy ID fields available within the reservation import; these IDs are unique identifiers for each record. Some Legacy IDs are required, while others are optional depending on the desired import.
Important! Each line must have both a Legacy Res ID & a Legacy Guest ID. If either is missing, the file will not import.
- Legacy Res IDs are saved to Res Spare Field 10 and used by subsequent imports to look up reservations.
- Legacy Group Res IDs are saved to Res Spare Field 8 and used by subsequent imports to look up reservations.
- Legacy Guest IDs must match those imported during the Guest &/or Owner Import (Saved to Guest Spare Field 2).
- Legacy Company IDs must match those imported during the Company Import (Saved to Company Spare Field 1).
- If both Legacy Company ID and Company (Name) are provided, Legacy Company ID will be used.
- Legacy Agent IDs must match those imported during the Travel Agent Import (Saved to Travel Agent Spare Field 1).
- If both Legacy Agent ID and Travel Agent (Name) are provided, Legacy Agent ID will be used.
Tip! You can create spare fields in the Labels section of RMS.
Import Field Order
| Order | Field Name |
Field Type |
Required |
Reference Field |
Max Characters |
RMS Equivalent |
|---|---|---|---|---|---|---|
| 1 | Legacy Res ID |
Alpha Numeric |
Y |
N |
50 |
Legacy System ID. |
| 2 | Legacy Group Res ID |
Alpha Numeric |
N |
N |
50 |
Legacy System ID. |
| 3 | Legacy Guest ID |
Alpha Numeric |
Y |
N |
50 |
Legacy System ID imported to Guest Spare Field 2 during Guest &/or Owner Import |
| 4 | Status |
Numeric |
Y |
N |
1 |
Reservation Status. |
| 5 | Arrives |
Y |
N |
|
Reservation Arrival Date |
|
| 6 | Departs |
Y |
N |
|
Reservation Departure Date |
|
| 7 | Adults |
Numeric |
N |
N |
No Max |
Number of Adults |
| 8 | Children |
Numeric |
N |
N |
No Max |
Number of Children |
| 9 | Infants |
Numeric |
N |
N |
No Max |
Number of Infants |
| 10 | Category |
Alpha Numeric |
Y |
N |
50 |
Type of accommodation booked. Must match RMS. |
| 11 | Area |
Alpha Numeric |
N |
N |
25 |
Area Description (Eg. Room Number) Must match RMS. |
| 12 | ETA |
Alpha Numeric |
N |
N |
10 |
Estimated Time of Arrival |
| 13 | Company |
Alpha Numeric |
N |
Y |
50 |
Name of Debtor or 3rd Party paying the Account |
| 14 | Travel Agent |
Alpha Numeric |
N |
Y |
50 |
Name of Travel Agent associated to the Reservation |
| 15 | Voucher No |
Alpha Numeric |
N |
N |
No Max |
Voucher Number field |
| 16 | Res Type |
Alpha Numeric |
N |
Y |
25 |
Type of Guest E.g. Corporate, Leisure |
| 17 | Sub Res Type |
Alpha Numeric |
N |
Y |
25 |
Sub Grouping of Res Type |
| 18 | Booking Source |
Alpha Numeric |
N |
Y |
25 |
Source of Reservation E.g. Internet, Magazine |
| 19 | Total Rate |
Numeric |
Y |
N |
|
Total Amount to be charged for the Reservation. |
| 20 | Rate Type |
Alpha Numeric |
Y |
Y |
50 |
Charge Type Must match RMS |
| 21 | Long Term |
Yes/No Field |
N |
N |
3 |
Long Term field which defines a reservation as a long stay rental which must calculate a paid to date for rent. |
| 22 | Fixed |
Yes/No Field |
N |
N |
3 |
Fixed flag which tells RMS this reservation cannot move rooms |
| 23 | ResSpare1 |
Alpha Numeric |
N |
N |
50 |
Reservation Spare Field 1 |
| 24 | ResSpare2 |
Alpha Numeric |
N |
N |
20 |
Reservation Spare Field 2 |
| 25 | ResSpare3 |
Alpha Numeric |
N |
N |
20 |
Reservation Spare Field 3 |
| 26 | ResSpare4 |
Alpha Numeric |
N |
N |
20 |
Reservation Spare Field 4 |
| 27 | ResSpare5 |
Alpha Numeric |
N |
N |
20 |
Reservation Spare Field 5 |
| 28 | ResSpare6 |
Alpha Numeric |
N |
N |
50 |
Reservation Spare Field 6 |
| 29 | ResSpare7 |
Alpha Numeric |
N |
N |
20 |
Reservation Spare Field 7 |
| 30 | ResSpare8 |
Alpha Numeric |
N |
N |
- |
Reservation Spare Field 8. Leave this column blank: RMS fills Reservation Spare Field 8 with the Legacy Group Res ID. |
| 31 | Legacy Account ID |
Alpha Numeric |
N |
N |
50 |
Legacy System ID. |
| 32 | Notes |
Alpha Numeric |
N |
N |
No Max |
Reservation Notes |
| 33 | Online Confirmation No. |
Numeric |
N |
N |
|
Online booking reference number. |
| 34 | Reservation Creation |
N |
N |
|
Date Made |
|
| 35 | Made By |
Alpha Numeric |
N |
N |
20 |
Matches to Username field in RMS. |
| 36 | Reservation Last Modified |
N |
N |
|
Last Modified Date |
|
| 37 | Modified By |
Alpha Numeric |
N |
N |
20 |
Modified By will match to the Username field in RMS. |
| 38 | Reservation Cancelled |
N |
N |
|
Cancelled Date |
|
| 39 | Cancelled By |
Alpha Numeric |
N |
N |
20 |
Cancelled By will match to the Username field in RMS. |
| 40 | Reservation Confirmed |
N |
N |
|
Confirmed Date |
|
| 41 | Confirmed By |
Alpha Numeric |
N |
N |
20 |
Confirmed By will match to the Username field in RMS. |
| 42 | Legacy Company ID |
Alpha Numeric |
N |
N |
50 |
Legacy System ID imported to Company Spare Field 1 during Company Import. |
| 43 | Legacy Agent ID |
Alpha Numeric |
N |
N |
20 |
Legacy System ID imported to Travel Agent Spare Field 1 during Travel Agent Import. |
| 44 | Housekeeping Note |
Alpha Numeric |
N |
N |
200 |
Housekeeping Notes |
| 45 | Discount |
Alpha Numeric |
N |
N |
20 |
Discount Name must Match |
| 46 | TotalDiscount |
Numeric |
N |
N |
20 |
The total amount of the discount |
| 47 | Business Lost |
String |
N |
N |
250 |
The Business Lost reason |
| 48 | Wholesaler |
Alpha Numeric |
N |
N |
50 |
|
| 49 | Legacy Wholesaler ID |
Alpha Numeric |
N |
N |
20 |
Legacy System ID imported to Travel Agent Spare Field 1 during Travel Agent Import. |
| 50 | Bill Category |
Alpha Numeric |
N |
N |
50 |
|
| 51 | Upgrade Reason |
Alpha Numeric |
N |
N |
50 |
|
| 52 | Payment Mode |
Alpha Numeric |
N |
N |
20 |
|
| 53 | Market Segment |
Alpha Numeric |
N |
N |
20 |
|
| 54 | Sub Market Seg |
Alpha Numeric |
N |
N |
20 |
|
| 55 | Legacy Room Move ID |
Alpha Numeric |
N |
N |
20 |
|
| 56 | Spare 11 |
Yes/No |
N |
N |
|
|
| 57 | Spare 12 |
Yes/No |
N |
N |
|
|
| 58 | Spare 13 |
Yes/No |
N |
N |
|
|
| 59 | Spare 14 |
Date |
N |
N |
|
DD-MMM-YYYY |
| 60 | Spare 15 |
Date |
N |
N |
|
DD-MMM-YYYY |
| 61 | Spare 16 |
Numeric |
N |
N |
3 |
Leave blank. RMS uses this field for its own purposes: a value of 10 on a Cancelled reservation marks it as a cancelled Pencil booking, which reports leave out. |
| 62 | Billing Note |
Alpha Numeric |
N |
N |
50 |
|
| 63 | Cancellation Policy |
Alpha Numeric |
N |
N |
50 |
|
| 64 | Group Allotment |
Alpha Numeric |
N |
N |
50 |
|
| 65 | Rate on Group |
Yes/No |
N |
N |
3 |
|
| 66 | Event Name |
Alpha Numeric |
N |
N |
50 |
|
| 67 | OTA Note |
Alpha Numeric |
N |
N |
No Max |
Reservation OTA Note |
Important! Category & Area entries must match RMS exactly, or the file will not import.
Reference Fields
If the reference field has a Y, the import will validate that the description exists in a pre-defined master list in the RMS system. If the description does not exist, one of the following two options will occur:
- If the matching Automatically add new master list items option is ticked on the Data Import screen, RMS adds the description to the master list when you run Import. For the Reservation Import, these options cover Agent, Booking Source, Company, and Res Type (Res Type also adds Sub Res Types), and they are ticked by default when you choose the Reservation file type. Validate does not add anything.
- If the Automatically add new master list items option is not ticked, the record does not import until its value matches a description that already exists in the master list. The error names the missing value, for example, Specified Booking Source Is Missing From Database.
Please Note! In some cases, the Validate stage will flag a row as failing - for example, with the error Specified Rate Type Is Missing From Database - that the Import stage then accepts. If a Validate failure does not appear in the Import Results table after running Import, the row was imported successfully. Always confirm via the Import Validation steps below that all expected rows landed.
Reservation Status Values
The status of the reservation must be imported using one of the following numerical values:
- 0 = Unconfirmed
- 1 = Confirmed
- 2 = Arrived
- 3 = Departed
- 4 = Cancelled
- 5 = Maintenance
- 6 = Quote
- 7 = Stop Sell
- 8 = Owner Occupied
- 9 = No Show
- 10 = Pencil
Date Formats
- Use one of these formats for every date field: YYYY-MM-DD (2027-12-06), DD-MMM-YYYY (06-Dec-2027) or YYYY-MMM-DD (2027-DEC-06).
- For the Arrival and Departure fields, add the time as HH:mm:ss, for example 2027-12-06 14:00:00 or 06-Dec-2027 14:00:00.
- If you leave out the time, RMS uses the Category's default arrival and departure times.
- If RMS can't read a Reservation Creation date, or it is blank, RMS uses the date and time of the import instead. It does not show a warning.
Important! Don't use dates written only in numbers, such as 06-12-2027 or 06/12/2027. The import reads the first number as the month, so 06-12-2027 is imported as 12 June 2027 without an error. A date whose first number is higher than 12 stops the file.
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:
In the side menu of RMS Training, go to Reservations > Reservation Search for data review.
- Select a 'Search On' field.
- Input the Search Criteria.
- Select the 'Search' icon.
- Select the Reservation Number to open the reservation.
Please Note! To find an imported reservation, search by Guest Name or another standard field. Don't search a custom field, such as Res Spare Field 10, for a Legacy Res ID made up only of numbers. RMS treats a numbers-only value as a Reservation Number and opens or lists that reservation instead, which may be a different booking. Legacy Res IDs that include a letter, such as ABC123, search the custom field as normal. See Reservation Search.
- Review the Guest Details to confirm the correct guest assignment for the reservation.
- Confirm the Reservation Details to ensure the correct arrival & departure dates, category & area, rate type, and any additional fields included in the reservation import.
- Examine the Account Details to confirm the correct rate amount.
Tip! Repeat this process with additional reservations to verify that the entire import was successful. Ensure that all necessary data points, such as the number of occupants, are correctly populated.
Run the Reservation List Report (Reports > Daily > Reservation List > Group by Arrival Date > Build) as an additional layer of import verification.
Downloadable Import File
The attached import file below contains the required file format for a reservation import. Download the file and review the column headers. Populate the file with the reservation data, ensuring that each reservation field corresponds to the appropriate column.
Next article: Data Validation & Trial Imports
Comments
0 comments
Please sign in to leave a comment.