Maintain Student Numbers for General Documents {SLLL5-2}


This option is used to specify student numbers to process when generating documents and has two Blocks. 
Block 1 is used to select student numbers that fall within a specified range.
Block 2 is used to process a list of students. The list can be imported from a csv file.


Note: When Exporting and Importing files the latest version of Excel must be used.


Fields in the option:

Block 1:  Create Range

Field Type
&
Length		 Description
Start Student Number N9 Start student number for generation.
End Student Number  N9 End student number for generation.
Reference Code  A4 This code will identify the group of students that will receive a particular letter.


Processing
Rules		  
  When start and end student number are entered, the user executes <NEXT BLOCK>.  All existing students with numbers within this range will be displayed.
The user can delete the ones that are not applicable and <COMMIT> the student numbers of  students that should receive the documentation.


Block 2:  Individual Student Numbers

Field Type
&
Length		 Description
Student Number N9 Enter student number to be used in generation of the letter.  The student name will be displayed.
Reference Code A4 This code will identify the group of students that will receive a particular letter.

Example:

Example of General Document


Right click on background, then select Import or Export

Example of General Document



Processing
Rules
for Import

a) Create a file for upload and save the completed file on local pc as a .csv file.

  • The spreadsheet headings must be the same as on the system (tip: use export first and use exported file as template)
  • File Extension displays correct format, i.e. .csv
  • Directory on Server path is correct.
b) Select Import from the menu

c) Select the file using Browse from local pc, which will display in File(s) area.

    d) Commit the changes on the screen using the Save button.


    Example of General Document

    Processing

    Rules

    for Export

    a) Query the Ref Code.  If you do not use the ref code it will give you all the information in the database.

    b) Execute the query

    c) Right click and select Export

      d) User should confirm the file name to be exported

      • File Extension displays correct format, i.e. .csv, and
      • Directory on Server path is correct.

      e) User selects Save File(s) to place the files on the pc in a .csv format.

       


      See Also:

      History Of Changes

      Date System Version By Whom Job Description
      08-Apr-2007 v01.0.0.0 Bea Swart t133415 New manual format.
      29-Jun-2007 v01.0.0.0 Magda van der Westhuizen t133415 Edit manual
      12-Aug-2020
      		 v04.1.0.0
      		 Sizeka Nyandeni
      		 T244727
      		 Adding Export and Import function