Teacher-Footnote Text Setup

From Online Grades Documentation

The teacher grade footnotes exported by Easy Grade Pro (see the documentation in the User Manual) require you as the administrator to complete setting up the footnote text in the database in order for the footnotes to be displayed. The default Easy Grade Pro foot note text is included, but your site may choose to use different footnotes if you choose. If you do this the only tricky thing will be making sure the footnote text is in sync between the user’s Easy Grade Pro and the server.

The text for the footnotes is kept in the COMMENTLIST table in the database. In order for the footnotes to be displayed the school (assuming you only have one school) needs to be set for the provided comments. We will do this from the MySQL command line, through it could be done via other methods. After logged in to mysql and you are at the MySQL prompt, switch to the Online Grades database using the "use" command. We will assume our Online Grades database is called "ogdb":

mysql> use ogdb;

You will get a "Database changed" confirmation from MySQL.

Show the current data in the COMMENTLIST table. You will see that while there are comments the school field is empty:

mysql> select * from COMMENTLIST;

You will get the following results:

Now we will manually update all the records so that they include the school code. We will assume the school code to be “school” for this example:

mysql> UPDATE COMMENTLIST SET schoolid = ‘school‘;

You will get a confirmation that seven rows where changed:

Query OK, 7 rows affected (0.02 sec)

Rows matched: 7 Changed: 7 Warnings: 0

Now if you do the same select statement that we did earlier you will see the updated information in the table. If you need the syntax for adding the same comments for additional schools review the onlinegrades_sql file in the docs/ directory. Look for the “Table data for commentlist” section for the file.