Mapping Columns for an Imported Block Rooming List

After importing a rooming list, the system maps the spreadsheet columns to their corresponding rooming list fields. If a column does not map, you can map it manually. 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.

To map block rooming list columns:

  1. From the OPERA Cloud menu, select Blocks, and then select Manage Block.
  2. Search and select the block.
  3. From your search results, click I Want To... and from Go To click Rooming List.
  4. Click Import Rooming List.
  5. On the Import Rooming List screen, click the drop-down list next to the field you want to map.
  6. Select the column name that corresponds to the spreadsheet column you want to map.
  7. Click Refresh. The spreadsheet column data populates the column in the import preview pane.
  8. After mapping all columns, click Add Reservations.

Figure 3-1 Mapping a Spreadsheet Column


The figure shows how to map the columns by selecting the B-Last Name spreadsheet column in the Name field drop-down list.