INTEGRATED NATIONAL EDUCATION
INFORMATION SYSTEM
Online User's Guide


Upload Multiple Award Recipients

This function allows the users to upload a batch of award recipients.

Roles Involved: MOE Award Officer and School Award Officer

  1. Download the Award Recipients template from here.

  2. Open the Upload Award Recipients template in Microsoft Excel.


    3. The data in each column should follow the bellow format. The column separator is comma ‘,’.

    Column Header Example Remarks
    StudentID 100004988 StudentID should have 11 characters.
    Award code INTLPM Award Code should be refer from Honors/Awards Table
    Date 02-02-2015 Format: DD-MM-YYYY
    Career PRIM Refer Academic Structure Page in Online Help.
    Program PRMRY Refer Academic Structure Page in Online Help.
    Plan (level) PRMRYYR2 Refer Academic Structure Page in Online Help.
    Term 1510 Enter the term the student obtain the award
    Comments Distinction on the NSW Science Exam Enter comments on the Student's award.

  3. Fill up the Award Recipients Details in the Excel template.

    4. Note:
    User must make sure there is NO comma(,) in the Comments column.

  4. Save the Excel File to .csv (comma delimited) file.

    5. Note:
    User must make sure the data is separated by comma (,).

  5. Navigate to Main Menu > Records and Enrollment > Graduation > Upload Award Recipients

  6. Click Add a New Value tab.

  7. Fill in Run Control ID field and Click Add button. Format Example: Awards_Recipients.

    8. Note:
    Run Control Id must not be blank and has no space.

  8. Enter the Academic Institution.

  9. Select the External File from Selection Tool dropdown.

    10. Note:
    User must save the Excel template as .csv(comma delimited) and it is recommended to remain the csv file open.

  10. Click Upload File button and upload the file with .CSV format.

    11. Note:
    An error message will appear if you upload the wrong file format.

  11. The upload data file should be filled in as shown in the image.

  12. Select the File Mapping.

  13. Click onto Preview Selection Results to view the data uploaded.

  14. Click Return button to continue the process

  15. Click Run button to run the process.

  16. Click OK button at the process scheduler request page.

  17. Click Process Monitor.

  18. Click on Refresh button to refresh the process monitor status.

  19. Click on Details link when the Run status has changed to “Success” and Distribution Status changed to “Posted”.

  20. Click View Log/Trace link to display any corresponding error messages if the process fails.

  21. Click MOE_UPDAW_AE.log file to check the result of the uploaded data files.

    22. Note:
    Any corresponding error messages will be displayed in the log file.

Sample of reports that users will encounter,

No Scenarios Description Sample
1 User Upload the correct Award Recipients Details User will be able to view the report of the Award Recipients details uploaded successfully.

When user clicks on View Log/Trace link, the log file will show the no of records selected and the no of records with errors.
2 User upload duplicate values When user upload duplicate values, user will get a success for the process.

When user clicks on View Log/Trace link, the log file will show the no of records selected and the no of records with errors provided with Error Descriptions.
3 User upload file where the Comments column has comma(,) When user upload file where the Comments column has comma(,) Eg: Comments - "Test, for Comma", only the text before the comma will be entered into the system.

The text after the comma will be omitted.
4 User upload incorrect Award Code, Career, Program and Plan (Year). When user upload incorrect Award Code, Careerc Program and Plan(Level) column, user will get a success for the process.

When user clicks on View Log/Trace link, the log file will show the no of records selected and the no of records with errors provided with Error Descriptions.