This function to batch upload student records to ALAN applications is available to CSNSW, AIS and Independent schools only. You must be an ALAN_ADMIN user to access this function.


Upload new students via the staging facility

  1. Log in to the ALAN portal. We recommend using Chrome web browser when accessing the ALAN Administration.
  2. In the ALAN homepage, click the 'Administration'. This will open the ALAN Administration page.
  3. In the ALAN Administration page, click the  'Add new student/s' button.



  4. In the 'Add new student/s' page, click the  New students spreadsheet template link to download the spreadsheet template file. The file will download to your computer.



  5. Use the spreadsheet template to enter your new student records. Please follow the instructions and data formatting specified in the spreadsheet template.



  6. Save a copy of your updated spreadsheet in your computer.
  7. Once your spreadsheet file is ready for upload, go back to ALAN ‘Add new student/s’ page then click the ‘Choose file’ or ‘Browse’ button. This will prompt you to browse and select your spreadsheet file from your computer.



  8. Select and double click the correct spreadsheet file from your computer.
  9. Click the 'Upload' button.




  10. Wait for the upload process to complete. Do not close or refresh the page.
  11. A message will display on the page to confirm whether the upload process was successful.  Note: if the Choose file (above) is 'greyed out', this indicates that students that are in the staging data base have not yet moved into production. Please notify your diocese office. .



  12. If the upload was unsuccessful: A message will display on the page to provide you with information about the upload errors. You will need to amend your spreadsheet before uploading again. An example of an error message:



  13. Once the upload process is completed, you will see the list of your new records in the 'View/Edit students in staging' screen. Click the 'View/Edit the uploaded student records' button to view your recently uploaded student records, or click 'Upload another file' to go back to the 'Add new student/s' screen.


  14. All student records uploaded to the ALAN staging area will be validated by the ALAN Support Team and will be transferred to the ALAN Production. After the records have been transferred to ALAN Production, you will be able to view your new students in PLAN2 and ALAN assessments (e.g. Best Start Kindergarten, Phonics screening check, etc.)