Rates cannot be uploaded with resources. Instead, manage and bulk-import rates using the rate management utility, accessible via Administration > Resources > Rates.

Getting Started

To begin, click the Upload toolbar button in Administration > Resources > Rates. From here, you can download a CSV template to get started or, if you have already added rates to your site, you can use the Download toolbar button to access your existing rates in CSV format to update or append. Your CSV file supports a wide array of columns that are documented below.

Rates that have several variations must be entered into your CSV file on separate lines. For example, if you have different rates for several user groups, then each user group and its associated rate must be on its own line in your template.

Once your rates have been added to your site, they can be modified as needed using the bulk importing feature. First, click Download to get a copy of your existing rates. Import this file into a spreadsheet application for easier editing, and then make your changes. Be sure to leave the Rate ID and Resource ID fields intact so that the existing rates are modified, and new rates are not created. If you would like to remove a rate, then set the Delete column to Yes. You can also add new rates into the same file to be created along with updating any existing rates - just leave the Rate ID field blank.

Troubleshooting

When uploading data your CSV file will first be parsed by the QReserve platform for any initial problems. Once upload has begun, additional issues may arise for invalid or conflicting data values. These errors are typically returned to your upload window with information about the row and the column where the error occurs. If you encounter any issues with uploading your data please contact us.

Supported Columns

When uploading a CSV spreadsheet, rates without a Rate ID will be considered new and will be created. All columns are optional except for Resource Name, Resource ID, and Rate  - required when updating a resource. Supported properties are constantly being updated and thus this list may not contain all supported properties at a given time. If you are looking for a property not listed below, please contact us and we would be happy to provide further guidance.

General Properties

Important Notes:

• User groups must be defined in your site prior to uploading rates associated with them
• If there are no rates available for a given user, the reservation will be free. If there are any rates available to a user, the user will be required to select one of them
• Weekly blocks can be implemented as 24-hour time slots in the format ##:##-##:##, semi-colon separated. For example, a block spanning 9:00 AM to 11:00 AM along with a block spanning 12:30 PM to 3:30 PM would be formatted as 09:00-11:00;12:30-15:30 . If you want the block to extend to the end of the day, enter 23:59 as the end time.
• If rates have time restrictions then you must define rates to cover all possible times or else a reservation will not be possible at times when no rate is available.
• Duration times must be defined in seconds. Use this chart to help determine the number of seconds:
  

Time-to-Seconds Conversion Reference Chart

Use this quick reference to convert everyday facility time rules into native CSV input values: