How to Batch Upload PIRL Data

Learn how to quickly upload large amounts of PIRL data to your Apprentice profiles.


Step 1: Navigate to the Apprentices > Overview tab


Screenshot 2023-03-15 at 9.52.07 AM


Step 2: Checkmark the Apprentices you want to upload data for

Note: Only apprentices you checkmark will be included on the CSV template. If you want to include more than the default 25 on a page, expand the Apprentices > Overview to show more apprentices.


Screenshot 2023-03-15 at 9.52.23 AM


Step 3: Click Actions, then Batch Upload


Screenshot 2023-03-15 at 9.52.42 AM


Step 4: Download the CSV Template


Screenshot 2023-03-15 at 9.52.53 AM


Step 5: Add PIRL information to the CSV Template

Keep the following in mind when populating the template:

  • Cells left blank will not change existing data
  • Populated cells will overwrite existing data
  • For multiple-choice fields, please enter the ID or number only
  • For dates, use the YYYYMMDD format
  • Ensure all commas are removed from the CSV


Click here to view PIRL Validation Rules


Screenshot 2023-03-16 at 9.42.28 AM


Step 6: Export the spreadsheet as a CSV

In Numbers, click File, Export to, then CSV.


Screenshot 2023-03-15 at 9.56.05 AM


Step 7: Upload the CSV in ApprentiScope and click Submit

Note: Only apprentices that are checkmarked (see Step 2 above) will have data uploaded for them. Ensure all applicable apprentices are check-marked before batch uploading the information.


Screenshot 2023-03-15 at 9.55.42 AM