Differences between revisions 2 and 3
Revision 2 as of 2018-07-21 11:55:33
Size: 1166
Comment:
Revision 3 as of 2018-07-21 11:56:48
Size: 1170
Comment:
Deletions are marked like this. Additions are marked like this.
Line 30: Line 30:
     . commandline: smsupdate file.csv or smsupdate file.upd      . 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)