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