Create Multiple Rotations with Spreadsheet

Skip to content

Create Multiple Rotations with Spreadsheet content

Search
Contact Us
Login
Create Multiple Rotations with Spreadsheet
Member Types:

ACEMAPP allows School Coordinators to create and upload rotations from a CSV file. Additional rotations can be added after the CSV file has been uploaded.

NOTE: When Bulk uploading rotations, they should have the same Partner, Experience Type, and Program.


Step 1:

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

Arrow pointing to the Rotations button

Step 2:

At the top of the rotation table, select "Create", then click on "Create Multiple" in the drop-down menu.

Arrows point to the "Create" drop-down and "Create Multiple" buttons on the Rotation Table.

NOTE: If you are included in a consortium, please 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.

Bulk rotations form highlighting Generate CSV template button and required field Partner, Experience type, and Program

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

Bulk rotations from highlighting Download template button

NOTE: We recommend downloading a new CSV template to enter your data before uploading. This will ensure that all columns are current in the system. If you use an outdated template, you may encounter an error when uploading 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 delete or change the order of the columns. This will cause an error when attempting to re-upload the spreadsheet into the system.
  • When entering Shift Start and Shift End times, use the 24-hour format, aka "Military Time".
  • When finished, 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 enter the same Partner, Experience Type, and Program you did previously when generating the CSV file for your rotations.

Click the "Browse..." button to upload the CSV file. Click the "Submit (CSV)" button to finish the upload process.

Bulk Rotations form highlighting browse and submit CSV buttons

Step 6:

Ensure all required fields are complete on the Bulk Rotation Edit screen.

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.

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.

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

Bulk Rotations page highlighting Row, Status, Days of the Week fields, and Submit and optional Add Row button

Optional: If needed, add additional rotations by clicking on the "Add Row" button.

NOTES:

  • Rotations can be entered using the Pending or Bulk Statuses. Rotations uploaded using the Bulk Upload method are placed into a Bulk status and are not visible to the clinical partners. Based on your region's agreed rotation submission schedule, these rotations will be automatically moved to active. If your area 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.
  • 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.

A rotation is a scheduled clinical experience.

A rotation is a scheduled clinical experience.

A rotation is a scheduled clinical experience.

A rotation is a scheduled clinical experience.

A rotation is a scheduled clinical experience.

Related Articles


Create Multiple Rotations in Bulk
Create multiple rotations at one time using the same Partner, Experience Type, and Program
Replicate Rotations
The Replicate Rotations tool allows you to re-request rotations previously created in ACEMAPP. When replicating rotations, you will have the opportunity to change the details of the rotation and add new rotations based on your current needs.