Using CSV import to capture attendance of past sessions

Using CSV import to capture attendance of past sessions

par Marcia Kitshoff,
Nombre de réponses : 4
Hi there

I would like to know if it's possible to use the CSV import option to capture the attendance of students that were all captured using manual paper registers? We have only just switched over to capturing attendance on Moodle, but all sessions for the year leading up to now are paper registers. Can that data be captured in a CSV and uploaded with student and session info? I can see that sessions can be created using the CSV import option, would I need to create all the sessions first and THEN capture attendance, or can it be done simultaneously? I'm a bit lost, TBH.

Thanks
Moyenne des évaluations  -
En réponse à Marcia Kitshoff

Re: Using CSV import to capture attendance of past sessions

par Dan Marsden,
Avatar Core developers Avatar Particularly helpful Moodlers Avatar Peer reviewers Avatar Plugin developers Avatar Plugins guardians Avatar Testers Avatar Translators
yes - you can import attendance using a csv file - if you hit the take attendance link for a session you should see an "upload attendance by CSV" button at the top of the page.
En réponse à Dan Marsden

Re: Using CSV import to capture attendance of past sessions

par Gaven Ferguson,
Hi there
I am trying to create attendance sessions using the import function but when i do it I am getting the following error.  Im not sure what is wrong with the dates or how to find out what is wrong.



En réponse à Gaven Ferguson

Re: Using CSV import to capture attendance of past sessions

par Jennifer Watson,
The date needs to be in US format. The way you have 20-Jan-2024 would need to be 01/20/2024.

Also, I wouldn't trust the repeating part of the import to work. Looking at other posts, it's something that needs work and I don't think it's been done yet. In the meantime, I'm just using a bit of code to generate multiple rows instead.

Here is some csv data from one of my previous imports:

Course,Groups,Date,from:,to:,Description,Repeat on,Repeat every,Repeat until,Allow students to record own attendance,Allow students to update own attendance,Student password,Random password,Subnet,Automatic marking,Automatically select highest status available,Absentee report,Prevent students sharing IP address,Time to allow re-use of IP address (minutes),Create calendar event for session,Include QR code,Rotate QR code,Open session early for marking
digitalsystems_2023_2024,Group 1 (Tue 11am - 1pm),2/13/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1
digitalsystems_2023_2024,Group 1 (Tue 11am - 1pm),2/20/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1
digitalsystems_2023_2024,Group 1 (Tue 11am - 1pm),2/27/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1
digitalsystems_2023_2024,Group 1 (Tue 11am - 1pm),3/5/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1
digitalsystems_2023_2024,Group 2 (Wed 11am - 1pm),2/14/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1
digitalsystems_2023_2024,Group 2 (Wed 11am - 1pm),2/21/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1
digitalsystems_2023_2024,Group 2 (Wed 11am - 1pm),2/28/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1
digitalsystems_2023_2024,Group 2 (Wed 11am - 1pm),3/6/2024, 11:00, 13:00,,,,,1,0,,1,,,,,,,1,1,0,1

Where I have left the values empty, it is using whatever the default is set as in site admin.