Create Rotations Using a Spreadsheet

Skip to content

Create Rotations Using a Spreadsheet content

Search
Contact Us
Login
Create Rotations Using a Spreadsheet

Create Rotations Using a Spreadsheet

ACEMAPP allows School Coordinators to create and upload rotations from a CSV file. If needed, you can also add additional rotations once the CSV file has been uploaded.

NOTE: When bulk uploading rotations, please make sure that they have the same Partner, Experience Type, and Program.


Step 1:

From your home screen, select "View Rotations" to go to your rotation table.

image users nav-bar highlighting View Rotations button

Step 2:

Across the top of the rotation table, select "Create". Then, click "Create Multiple" from the drop-down menu.

image with arrows pointing to create and create multiple tabs

NOTE: If you are included in a consortium, please be sure to check the bulk submission schedule.

Step 3:

Select the Partner, Experience Type, and Program for your rotations. Then, click the blue "Generate Template" button under CSV Template.

image with arrows pointing to partner, experience type, and program fields. another arrow pointing to the generate csv template button.

This button will turn into a green "Download Template" button. Click the button to download the template.

image with an arrow pointing to the generate template button

NOTE: We recommend downloading a fresh CSV template to enter your data prior to uploading. This will ensure that all columns are current in the system. If you are using an outdated template, you may encounter an error when trying to upload the spreadsheet.

Step 4:

Enter the data into the spreadsheet. Please be aware of the following points:

  • When entering the data into the spreadsheet, DO NOT reorder the columns. This will cause an error when attempting to reupload the spreadsheet into the system.
  • When entering Shift Start and Shift End times, be sure to use a 24-hour format, aka "Military Time".
  • When finished, be sure to save the file to your device as a .CSV file, or the system will not accept the file and produce an error.

Step 5:

To upload the spreadsheet, repeat steps 1 - 3 to get back to this screen and select the Partner, Experience Type, and Program for your rotations.

Click the "Browse..." button to browse your device for the file. Then, click the "Submit (CSV)" button to finish the upload process.

image with arrows pointing to the browse and submit csv buttons

Step 6:

On the Bulk Rotation Edit screen, make sure all required fields are complete.

Rotations and fields that are incomplete will be highlighted in red. Use the slider bar at the bottom of the table to look through the rotations in the list and update the highlighted areas.

image with arrows pointing to missing fields, highlighted in red

NOTE: The "Submit" button at the bottom of the page will also be unclickable if there are any errors.

Step 7: (optional)

If needed, you can add additional rotations from this screen. Click the "Add Row" button to insert a blank row.

Add Row for additional rotations

Step 8:

Once all rotations have been updated, the highlighted Row column will change from red to blue. Click the green "Submit" button at the bottom of the page to submit the rotations.

Once all rotations are listed click submit

NOTE: Rotation information will take time to populate into the Rotation Table and may take up to 24 hours. To view the details of the rotation(s), use the "Edit" (pencil) icon to access the Rotation Request Form.


NOTE: Rotations entered using the Bulk Upload method are placed into a Bulk status and are not visible to the clinical partners. These rotations are set to active based on your region's agreed rotation submission schedule. If your region does not have a set rotation submission schedule, please contact ACEMAPP Customer Support at 844-223-4292 or email support@acemapp.org to have your rotations released into a Pending status.

Related Articles


Scheduling Rotations
To access your rotations, click “View Rotations” from your home screen. Your rotations are organized by their status.