Using Block Room List Import
Using Excel or equivalent software you can produce a .csv , .xls or .xlsx data file containing profile and reservation details for import as a Block rooming list.
Ensure the block has available rooms and that the block is in a status that allows for pickup, click View Room/Rate Grid to view the available rooms in the block.
-
Files must be in .csv or 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.
-
The following columns are mandatory:
-
Last name
-
First name (Initial)
-
Room Type
-
Email Type if an email address is supplied.
-
ID Type if an ID Number is supplied.
-
Rate Code if the Rate Code Mandatory Block Header OPERA Control is active.
-
-
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
![This figure shows the rooming list spreadsheet. This figure shows the rooming list spreadsheet.](img/rooming_list_spreadsheet.png)
Figure 3-2 Field Mapping
![This image shows Import Rooming List panel with column mappings. This image shows Import Rooming List panel with column mappings.](img/importing_rooming_list.png)
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.
If a column does not map, you can manually map the column.
-
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.
-
From the OPERA Cloud menu, select Bookings, select Blocks, and then select Manage Block.
-
Enter search criteria and click Search.
-
Select the block in the search result, click I Want To... and then click Rooming List.
-
Click Import Rooming List.
-
Click Choose File and browse folders and select the .csv or Microsoft Excel .xls or .xlsx file, and click Open.
-
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. -
The Map Columns panel expand:
-
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.
-
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.
-
Click the list button below a field you need to map to data file column.
-
Select the column name that corresponds to field.
-
In the Preview panel click Refresh. The spreadsheet data populates the column in the import preview pane.
-
-
Review the mapped columns and make any adjustments.
-
Click Add Reservations.
-
The imported reservations are added to the Rooming List page.
Parent topic: Creating Block Reservation Using the Rooming List