Using Room List Import

Prerequisites for Room List Import

An xls or xlsx spreadsheet file can be setup and used to import profile and reservation details as a rooming list.

Note:

For optimal performance it is recommended to limit an XLS / XLSX file to a maximum of 1,000 records.

Consider the following when setting up the group rooming list import file:

• Files must be in Microsoft Excel .xls or .xlsx formats.

• Begin each column with headings at cell A1. Upon import, the spreadsheet's column headings map to corresponding rooming list field names.

• Only columns with data import.

• Only mapped columns import.

• Create columns for Line and Sharer and reference the line number of the row for the first (primary) reservation in the Sharer column of the secondary reservation(s).

Figure 3-1 Rooming List Spreadsheet

Figure 3-2 Field Mapping

Importing and Mapping a Rooming List File

When importing a rooming list, OPERA Cloud attempts to map the spreadsheet columns to their corresponding rooming list fields. You can manually map the column if a column does not map automatically.

Note:

Room cannot be mapped for import. Once reservations are imported a Room can be assigned to each reservation. For more information, see Creating Reservation Using the Rooming List.

When mapping rooming list columns:

• The Map Columns section shows the Rooming List fields.

  • The drop-down lists next to the fields show the column headers from the spreadsheet.

• The Preview pane shows the columns ready to import.

1. From the OPERA Cloud  menu, select Bookings, select Blocks, and then select Manage Block.

2. Enter search criteria and click Search.

3. Select the block in the search result, click I Want To... and then click Rooming List.

4. Click Import Rooming List.

5. Click Choose File and browse folders and select the Microsoft Excel .xls or .xlsx file, and click Open.

6. Click Import File.

   Note:

   If you need to re-import a corrected data file, click Clear and repeat the Choose File and Import File steps.

7. The Map Columns panel expand:

   1. If there are data errors to be corrected in the data file an X  displays in the column with the error in the preview panel. The rooming list import process is halted until errors are corrected.

   2. Click  next to a field in the Mapping panel to view a list of values for a specific field - ensure values in data file match the configuration.

   3. Click the list button below a field to select the column name from the xls or xlsx  file that corresponds to rooming list field.

8. In the Preview panel click Refresh.

   1. The spreadsheet data populates the columns in the preview panel.

   2. Review the mapped columns and make any adjustments. 

9. Click Add Reservations to import the reservations from the file.

10. The imported reservations are added to the Rooming List page.

11. Update reservations with any additional details. For more information, see Creating Reservation Using the Rooming List.