Skip to main content

How to Bulk Upload User Templates

This article provides a step-by-step guide for administrators on how to bulk upload shifts using a roster template in HosPortal.

Ammar Alsatrawi avatar
Written by Ammar Alsatrawi
Updated over 2 weeks ago

Navigation

To begin, you will need to access the staff import tool from the HosPortal dashboard.

  1. From the main menu, navigate to the Staff section.

  2. In the top right-hand corner of the screen, select the Import button.

  3. This will take you to the Staff Import page.

Preparing Your Template

Before you can upload, you need to prepare your roster template spreadsheet with the required data.

  1. On the Staff Import page, you will see a link to download the hosportal_user_template.xlsx file. Use this as a guide for formatting your data, but note that the bulk add process for rosters requires specific information.

  2. Fill in your template with the details of the shifts you wish to add.

  3. Save the completed spreadsheet in a location you can easily access.

Note: Ensure your data is accurate before uploading. Incorrect data can cause errors or issues with the roster.

Uploading the Roster Template

Once your template spreadsheet is ready, you can upload it to the system and populate the roster.

  1. Select the Template type you are using for the upload.

  2. Select the Roster group you want to add the shifts to.

  3. Select the required Days of the week and Sessions.

  4. By default, Skip holiday is checked. Uncheck this if you wish to include shifts on holidays.

  5. Select the Choose File button and locate your completed spreadsheet.

  6. Select the file and click Open.

  7. A confirmation prompt will appear. Review the details and then click OK.

  8. A success message will appear, and the shifts will be added to the roster.

Screenshot

Did this answer your question?