Differences between revisions 1 and 2
Revision 1 as of 2018-07-21 11:51:32
Size: 1086
Comment:
Revision 2 as of 2018-07-21 11:55:33
Size: 1166
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
Line 29: Line 28:
   * Tell sms to import the marks, select ''Student Menu'' → '''''Update Student'''''.    * Tell sms to import the marks
     . interatively:
select ''Student Menu'' → '''''Update Student'''''
     
. commandline: smsupdate file.csv or smsupdate file.upd
  • Interactively
    • Under Student Menu, choose Modify Student.

    • If you have several marks to enter, a faster way is to use Bulk Entry.

  • From a file - Two types of file are accepted (.upd and .csv).

    • Format for .upd file, example:

      • 3123456|examA|18|
        3121212|examA|10|
        3123456|examB|15|
        3121212|examB|8|
        3123456|examC|6|
        3121212|examC|3|

        where first column is studentID, second column is mark field and third column is mark.

    • Format for .csv file, example:

      • StudentID,examA,examB,examC
        3123456,18,15,6
        3121212,10,8,3

        where the first line in the file must be comma separated sms field names.

    • The files must be copied to update_recs directory under $SMSDB, examples:

      • % cp file.csv $SMSDB/update_recs

      • % cp file.upd $SMSDB/update_recs

    • Tell sms to import the marks
      • interatively: select Student MenuUpdate Student

      • commandline: smsupdate file.csv or smsupdate file.upd

EnteringMarks (last edited 2020-08-17 15:01:13 by MeichengWhale)