Exporting SES files

To export SES files in Australia:

1. Update the method for identifying parents, if required. See SES parent extraction settings in the System maintenance manual.
2. 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.
   
3. If you have multiple campuses, update the DEST Client Number field, if required.
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. Change the default File Name, if required.
   
   Note: The file does not require a file extension.
   
   
6. Select the Year Level From and Year Level To for the year levels to export, inclusive.
7. Click .
   The following dialog is displayed.
   
8. Click .
   The SES Address Listing, Australian Addresses Crystal Report is displayed in preview mode.
   
   
   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.
9. Close the report.
10. Either:
    
    • No Errors are found.
    The following window is displayed.
    
    
    • Errors are found.
    The following window is displayed.
    
    
    
11. Click .
    The SES Address Listing, Overseas Addresses Crystal Report is displayed in preview mode.
    
    
    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.
    
12. Close the report.
13. Open the SES export file in Excel.
14. Check the error details listed in Columns AK and AL.
    
15. Either:
    
    • Errors are detected. Resolve the errors using the information provided and repeat Steps 7 through 14.
    • No Errors are detected. Copy the data from Columns A to AJ and proceed to the next step.
16. Download the Address Collection Data Upload Template.
17. Open the file and delete the sample data.
    
18. Paste the copied data into Cell A4 of the Address Collection Data Upload Template.
    
    

    Note: You need to manually enter values for Columns C through G for the first row.
    
    

19. Scroll to Column AK and check whether any additional errors are identified by the Address Collection Data Upload Template file.
20. Resolve any additional errors in Synergetic.
21. If you have multiple campuses and need to export again, repeat from Step 3.
    Exporting SES files is complete.