How to Batch Upload PIRL Data

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

User Types: Regulators, Sponsors & Employer Administrators

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

 

If you have questions or need help, please submit a Support Ticket here