Differences between revisions 5 and 6
Revision 5 as of 2018-07-22 06:59:49
Size: 1491
Comment:
Revision 6 as of 2018-07-22 07:01:00
Size: 1493
Comment:
Deletions are marked like this. Additions are marked like this.
Line 36: Line 36:
   * Create a cronjob for the transfer every day with this command /home/give/stable/bin/gencronwebcms.sh    * Create a cronjob for the transfer every day with this command `/home/give/stable/bin/gencronwebcms.sh`
  • 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

  • From WebCMS3

    • Fields must be Open to be editable by tutors in WebCMS3

    • Setup/transfer marks from/to WebCMS3 with this command /home/webcms3/sms/sms_webcms3.sh

    • Create a cronjob for the transfer every day with this command /home/give/stable/bin/gencronwebcms.sh

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