Signup time slots can be imported in bulk by uploading a spreadsheet.
Notes:
- Use the downloadable import template file provided in the admin module. Do not change the column headers.
- The second worksheet in the file contains a list of acceptable Location Codes. Valid codes from this list must be used in the “Location Code” column of the time slot list on the first worksheet. These codes correlate to locations that can be marked on a map to help the user arrive at the correct location. “Zoom” is in the list as a valid virtual location. The “Location Detail” column can be used to identify the location within the building (or the room ID for Zoom). If there is not a Location Code for a time slot location, leave the Location Code” column blank in the time slot list and enter the location description the the “Location Detail” column.
- If you want to do a second import of additional time slots, only include the new time slots in the file. Including the original time slots along with the new ones will create duplicates of the existing time slots.
- The file cannot be an Excel macro file (indicated by a .xlsm file extension). If your file is in this format, do a “Save As…” to convert it to a regular Excel document (indicated by a .xlsx file extension).