ERN files

To import class lists from ERN requires three csv files that must be named:

• ERN-TEACHER.CSV
• ERN-CLASS.CSV
• ERN-ROLL-CLASS.CSV

These three files are imported with the Import School Data command.

The three csv files are made in ERN using the Excel export facilities of the "ERN – Enrolment and Registration Number" application of the NSW DET Web Portal.

Creating ERN Teacher File

1. Open the DET Web Portal and click on the "My Applications" tab, and the "ERN – Enrolment and Registration Number" application.

2. Click on "ERN School Enrolment"

3. Click on the "Place Management" menu item at the left and the "Student Group Offers" tab.

4. Select the "Scholastic Year" required for example "Year 12" and select "Course Class" in the "Activity Type "list.

5. Click on the "Go" button.

6. Click on the small Excel icon to left of "Group Offer Name" to export the data to an Excel csv file.

7. Use Windows to re-name the exported file to ERN-TEACHER.CSV.

Creating ERN Class File

8. Click on "Reports" menu item at the left, and the "Student Details Report" tab.

9. Tick "Student Group" check box and do not write in the line.

10. Tick the "Scholastic Year" check box and select the same "Scholastic Year" as in step 4.

11. Tick the "Activity Type" check box and select "CCL Course Class" in the "Activity Type " list.

12. Scroll down and expand the "Student Criteria" box.

13. Tick the "Gender" check box.
14. Scroll down and expand the "Report Schedule" box.
15. Enter a report name, for example Classes.
16. Select "CSV" in the "Report Format" list.
17. Select "Exclude All Criteria" in the "Report Header Criteria" list.

18. Click on the "Schedule Report" button.
19. Write down report number.

20. Click on "My Reports" menu item at the left and wait until report is COMPLETED, to refresh the screen click on the "Go" button occasionally if the report is not complete.

21. Click on the "Download" link and click on the Save button to store the report as an Excel csv file.

22. Use Windows to re-name the exported file to "ERN-CLASS.CSV".

Creating ERN Roll Class File

These steps are similar to making the ERN Class File, except the roll classes are exported.

23. Click on "Reports" menu item at the left, and the "Student Details Report" tab.
24. Tick "Student Group" check box and do not write in the line.
25. Tick the "Scholastic Year" check box and select the same "Scholastic Year" as in step 4.
26. Tick the "Activity Type" check box and select "ROL - Roll Class" in the Activity Type list.
27. Expand the Advanced Student Criteria box.
28. Expand the Student Display Fields box.
29. Tick the Preferred Student Name check box.
30. Scroll down and expand the "Report Schedule" box.
31. Enter a report name, for example "Roll Classes".
32. Select "CSV" in the "Report Format" list.
33. Select "Exclude All Criteria" in the "Report Header Criteria" list.
34. Click on the "Schedule Report" button.
35. Write down report number.
36. Click on "My Reports" menu item at the left and wait until report is COMPLETED, to refresh the screen click on the "Go" button occasionally if the report is not complete.
37. Click on the "Download" link and click on the Save button to store the report as an Excel csv file.
38. Use Windows to re-name the exported file to "ERN-ROLL-CLASS.CSV"

Problems importing

If the imported data is not correct or complete, it is recommended that you open each of the text files in Windows Notepad and check that the first line of each file is as follows.

• The lines may be shown over two lines, but if the word wrap is off would appear as one. In both files, the quotations are optional and are not required.

ERN-TEACHER.CSV

Group offer name,Academic Period,Curriculum Offer Scholastic Year,Curriculum Offer,Activity Type,Scholastic Years,Staff,Size


ERN-CLASS.CSV

SRN,First Name,Family Name,Student Group Offer,Activity,Scholastic Year,Gender


ERN-ROLL-CLASS.CSV

SRN,First Name,Family Name,Student Group Offer,Activity,Scholastic Year


 

Contents
Search