Start by preparing a CSV file containing the data to be imported.
Ensure that the columns contain all the required fields.
A file cannot be imported if any of the required fields are not included.
The import of a record will fail if any of the required fields have no value.
Best practice: Keep the columns in the same order, and use the same or similar names as used in the mapping step.
This makes the mapping step quicker and easier, since those fields are more likely to be mapped by default.
Save the file as a CSV file, where the first row contains the column headings (the field names).
The usual way is to save an Excel file as "CSV (Comma delimited)".
B. Import Your Data
Once you have a CSV file of Blocks to import, step through the Accommodation Import Wizard to import it.
Select Blocks as the type of accommodation to import.
Browse to select a file to upload.
Upload it.
In the pop-up window, map the columns in the import file to the data fields, which are listed below.
See the Blocks help topic for full details of these fields.
Fields to map
Hotel Code – Required.
The Hotel Code must be for an existing hotel already set up on Accommodation > Hotels.
The Unique Code for the hotel can be seen by clicking the pencil icon to edit the Supplier record.
Room Type Code – Required.
The Room Type Code must be for an existing Room Type already set up on Accommodation > Room Types.
Start Date – Required.
Format mm/dd/yyyy.
End Date – Required.
Format mm/dd/yyyy.
Rate – Optional. If included, must be a positive number (with up to two decimal places).
Inventory – Required. Must be a positive integer.
Contracted Inventory – Optional. If included, must be a positive integer.
Click Import.
Your import is queued, and you receive an email as soon as it is processed.
The blocks are then available for use, and can be seen and edited on Accommodation > Blocks.
After the Import is Complete
When you are setting a block up on Accommodation > Blocks you can restrict the attendee types with access to it, but not when you are importing it.
You can do that manually on Accommodation > Blocks at any time after the import is complete.
Attendee Types that Can Select this Block
Initially, all the attendee types are listed in the Allowed column, so by default all attendee types would be able to see and select the block on the registration form.