Using a script to automatically import attendance into database

Using a script to automatically import attendance into database

by Mike Worth -
Number of replies: 1
Our attendance is taken using an online system which is separate from moodle, it is all fed into our MIS from which it can be exported as CSV. My plan is to import this into the mysql database with a custom script; I have nearly done this but am having issues with the exact time to use. It only seems to recognise it if the time is midnight (although adjustments need to be made for BST). Is there a reason why it can't be fiddled to use actual times and then have several sessions per day (Some courses are run as full time but registers are taken each period)

Thanks,
Mike
Average of ratings: -
In reply to Mike Worth

Re: Using a script to automatically import attendance into database

by Mike Worth -
Just done a bit more fiddling and it seems that my problems were caused by the sessions being before the course start date.

I now have it creating sessions and taking attendance even for days with multiple sessions (I guess this will cause problems if the automatic attendance feature is used but it won't be). I now just want to add the time to the list of sessions displayed- it is something to do with the following line:

<td><?php echo strftime(get_string('strftimedmyw', 'block_attendance'), $sessdata->sessdate); //userdate($sessdata->sessdate,'%d.%m.%y&nbsp;(%a)', 99, false); ?></td>

from manage.php What is the syntax to add hh:dd after the date?

Thanks,
Mike