Blocks How To - How do I import a Rooming List?
Importing a Rooming List:
1. In the Block Reservations jump, select the Rooming List link. Alternatively, select Actions > Go to Rooming List from the Manage Blocks > Search results for the block.
2. In the Manage Rooming List screen, select Import Rooming List.
3. Select Choose File. File formats .xls and.xlsx (Microsoft® Excel®) are accepted. The topic How should my rooming list file be set up? provides additional information.
4. Select Import File. If the file selected has multiple sheets, select the sheet to import.
As the file is imported, OPERA Cloud maps the rooming list fields to matching spreadsheet columns.
5. Review the mapped columns and make any necessary adjustments. If OPERA Cloud does not find or map a column, you can manually map it.
6. Select Add Reservations. The rooming list fields populate with the information from the mapped columns.
7. In the Manage Rooming List, enter additional information, and then select Save.
The Rooming List, Reservations, and the Reservation Summary update with the new reservations.
If there is any incomplete information, a red error icon appears at the line number. Select the icon for instructions on how to resolve the error. After the error is resolved, select Save to update the reservation.
Example of mapped columns
