Start this import process by selecting Room Reservations as the type of data to import on Accommodation > Import. This import process enables importing Attendees’ accommodation reservations into the event from an Excel or CSV file. The import process supports adding new reservations. The import process supports updating existing reservations.
After import, attendees’ accommodation records show these details. Attendees’ accommodation records allow editing these details. Manage > Registrations > Accommodation
After import, these details are visible and can be edited on attendees' accommodation records: Manage > Registrations > Accommodation.
Pre-Requisites
The event must include the following items before importing new room reservations:
- The Attendees for whom the rooms are being reserved.
- The Blocks or Sub-Blocks from which the room-nights are to be drawn.
Import file requirements
The import file requirements include file type. The import file must be an Excel file (.xls or .xlsx). The import file can be a CSV file (.csv).
The import file requirements include international characters and special characters. If the import includes international or special characters, best practice is to use a .CSV file.
The import file requirements include the first row. The first row must be column names. Column names are used when mapping fields.
Required fields when adding new registrations
The import file requirements include required fields for adding new registrations.
- Registration Code – The attendee.
- Hotel Code – Must be as specified in the relevant accommodation block or sub-block.
- Room Type Code – Must be as specified in the relevant accommodation block or sub-block.
- Arrival Date and Departure Date –
- Must be valid dates in mm/dd/yyyy format.
- If a Sub-Block Name is included in the import, the dates must be between the Sub-Block Name’s Start and End dates.
- If no Sub-Block Name is included in the import, inventory comes from a Block.
- If no Sub-Block Name is included in the import, the dates must be between the Start and End dates of a block for that hotel and room type.
- Guest 1 Name
Required fields when updating existing registrations
The import file requirements include required fields for updating existing registrations.
- Unique ID – to identify the records to update
- Registration Code
- Arrival Date and Departure Date
- Must be valid dates in mm/dd/yyyy format.
- Must be between the Start and End dates of the relevant block or sub-block.
- Guest 1 Name
> Note: Only columns with values in them will update the records concerned. > Columns with no values (or not included in the file) will leave the existing data unchanged.
Other data requirements
Other data must be valid.
- Date Confirmed – If entered, must be a valid date in mm/dd/yyyy format.
- Tip: Format all date cells as mm/dd/yyyy in Excel, to help avoid errors.
- Smoking, Sharing and Overbook must be Yes, No, or blank.
Steps to follow to import Room Reservations
1. Select whether to import new reservations or update existing ones.
2. Best practice: In the first step of the wizard you can click a link to download a template Excel file to populate.
- If you're adding new room reservations, download the first Excel template.
- If you're amending existing room reservations, download the second Excel template.
- The second Excel template starts with a Unique ID column.
- The Unique ID column identifies the reservation to be updated.
- (Note: You can run a Room Reservations report to find the Unique IDs of existing reservations.)
3. Once you have a file ready to import, click Next in the first step.
4. Drop a file into step 2, or click Choose File and select the file to upload.
5. In the next step, map the columns in your import file to the Instance Field in Certain.
6. Click Complete Import to start or schedule the import process.
7. You receive an email advising that the import is complete, with details of any rows that failed to import.
- An import will fail if it includes invalid data.
- Invalid data includes incorrectly formatted dates (see above).
- Invalid data includes an incorrect Registration Code.
- Invalid data includes an incorrect Hotel Code.
- Invalid data includes an incorrect Room Type Code.
- Invalid data includes an incorrect Sub-Block Name.
- Invalid data includes an incorrect Unique ID.