Page Comparison

...

1. Update the method for identifying parents, if required. See SES parent extraction settings in the System maintenance manual.
2. Ensure the Location AGEID number is populated into the MCEETYASchoolCode field of the luCampus lookup table for each campus at your organisation. See luCampus lookup table.
3. Open the SES tab of the Import/Export Student Data window. See Import/Export Student Data - SES tab.
   The SES tab of the Import/Export Student Data window is displayed.
   Image RemovedIf you have multiple campuses, update the DEST Client Number field, if required.
   Image Added
   
   
4. Select the output type using the Output Type field. You can select:
   
   • Comma Delimited to create a csv file
   • Tab Delimited to create a txt file.
   
   
5. Select the Year Level From and Year Level To for the year levels to export, inclusive.
6. Change the default File Addresses File Name, if required.
   
   Note: The file name does not require a file extension.
   
7. Select the Year Level From and Year Level To for the year levels to export, inclusive.
8. 
   Click Image RemovedNote: The Locations File Name is automatically updated based on the value of the Addresses File Name field.
9. Click Image Added.
   The following dialog is displayed.
   
10. Click .
    The SES Address Listing, Australian Addresses Crystal Report is displayed in preview mode.
    Image RemovedImage Added
    
    Important: Scan the report to briefly check whether the number of Australian addresses is correct. When the number is much lower than expected it could indicate that the Code field of the luCountry lookup table and the Value field of the CountryCode configuration setting do not match exactly. When this occurs the students with mismatched addresses are reported as overseas students. See luCountry lookup table and CountryCode configuration setting.
    
    
11. Close the report.
12. Either:
    
    • No Errors are found.
    The following window is displayed.
    Image RemovedImage Added
    
    
    • Errors are found.
    The following window is displayed.
    Image RemovedImage Added
    
    
13. Click .
    The SES Address Listing, Overseas Addresses Crystal Report is displayed in preview mode.
    Image Removed
    
    Important: Scan the report to briefly check whether the number of Overseas addresses is correct. When the number is much higher than expected it could indicate that the Code field for the Australia record of the luCountry lookup table and the Value field of the CountryCode configuration setting do not match exactly. When this occurs the students with mismatched addresses are reported as overseas students. See luCountry lookup table and CountryCode configuration setting.
    
    
14. Close the report.Open the SES
15. Download the Address Collection Data Upload Tool from the Schools Hub website.
16. Open the Address Collection Data Upload Tool in Microsoft Excel.
17. Open the Locations export file in Microsoft Excel.Check the error details listed in Columns AK and AL.
    Image Removed.
18. Copy the data from Columns A to I of the Locations export file.
19. Paste the copied data into Cell B9 of the Locations sheet of the Address Collection Data Upload Template.
    
    Note: You need to manually enter values for Columns E through I for the first row.
    
    
20. Click Image Added.
21. Either:
    
    • Errors are detected. Resolve the errors using the information provided and repeat Steps 7 through 14 18.
    • No Errors are detected. Copy the data from Columns A to AJ and proceed Proceed to the next step.
22. Download the Address Collection Data Upload Template.
23. Open the file and delete the sample data.
    Image RemovedOpen the Statement of Student Addresses export file in Microsoft Excel.
24. Copy the data from Columns A to AB of the Statement of Student Addresses export file.
25. Paste the copied data into Cell A4 of B9 of the Statement of Student Addresses sheet of the Address Collection Data Upload Template.
    Image Removed
    Note: You need to manually enter values for Columns C through G for the first row.
    
26. Scroll to Column AK and check whether any additional errors are identified by the Address Collection Data Upload Template file.
27. Resolve any additional errors in Synergetic.
28. 
    If you have multiple campuses and need to export again, repeat from Step 3Note: Values with leading zeros may not paste correctly.
    
    
29. Click Image Added
30. Either:
    
    • Errors are detected. Resolve the errors using the information provided and repeat Steps 7 through 23.
    • No errors are detected. Proceed to the next step.
31. Click Image Added.
32. Upload the file as per instructions from the Department of Education.
33. If you are running the process for individual campuses, repeat the process as required.
    Exporting SES files is complete.