Bulk Hotel Property Upload

A company may have an extensive list of preferred, excluded, and display-only hotel properties. Rather than create them one by one, you can upload them via any spreadsheet saved as a tab-delimited .txt file. To do so, click the Bulk Hotel Property Upload link on the Property Criteria screen. The Bulk Hotel Preferred Property Upload screen appears.

The spreadsheet to upload must be saved as a tab-delimited .txt file. An example spreadsheet is shown below. The first row contains the headers for each column. The data are in the second row on. Enter the data in the predefined format. Green shaded headers indicate that the data in that row is required.

In the Property Criteria column, enter one of the following values for each property:

• P: Preferred property
• E: Excluded property
• DP: Display-only property with the non-preferred indicator not checked
• DNP: Display-only propertywith the non-preferred indicator checked

Note: The TRM Property ID code is a required field. If your agency is not provisioned for TRM content, enter N for all properties.

Take the following steps to upload a spreadsheet:

1. In the E-mail Address field, enter your email address to receive notification of the success or failure of the upload.
2. Click the Browse button and locate the Microsoft Excel file you wish to upload.
3. Click the Upload button to begin the upload.

After you upload files, the top of the Property Criteria screen displays the upload logs.