I can still take attendance, but its a white blank in the book...

Comments

AntiNSA’s picture

AntiNSA commented

Arrgghh../. I tried to uninstall and reinstall the attendance module and lost all of my attendance records. so terrible I have no back up........................ : ( : (

AntiNSA’s picture

AntiNSA commented

can you give me the correct mysql command to export the attendance table and then import it ?

I have a bacckup.mysql which contains all my site records from a week ago..

and please give me the command line syntax to import that table?

I know there are lots of whitespaces... But I have just lost 7 days of 6 classes per day attendance records... getting some back is better than none.

MGN’s picture

MGN commented
Status: Active » Postponed (maintainer needs more info)

Can you explain what you mean by "white spaces" ?

What are you using to do your backups? Are you using phpMyAdmin, another control panel, command line?

AntiNSA’s picture

AntiNSA commented

Hi! Thanks. I am not sure if it is because my students altered their names or not.It was a white blank, I dont have a screen capture of it... but it was whit blanks ... not intermittent

like this

Student A Present Present Present Present
Student B Present Present Blank Blank
Student C Present Present Present Present

Even though I could see the student B on the attendance recording form, and set it to present , it would be blank not absent or not anything, like an empty cell... it wasnt intermittent. This was for several students, and I did have several students chancge their student names.

to back up I do command line back up . I dont have any php my admin

I will mysql temp.mysql < mybackup.mysql and then hopefully mysql temp.mysql > to ???

I dont know how to command line back up and restore only table data into an existing database or export only a table from a database...

MGN’s picture

MGN commented

I haven't tried this, but found some good ideas on restoring a single table from a large mysql dump at

http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-m...

I think the easiest approach might be to create a new database to restore the entire dump to. Then extract just the gradebook_attendance table (and the gradebook_attendance_assignment table, if needed) to a file, delete the gradebook_attendance table (created by the reinstall) in the database for the production site, and finally import the gradebook_attendance table. Its outlined as method 3 in the link above. But as you read about it, you'll see that there are other ways of accomplishing the same.

MGN’s picture

MGN commented
Title: Attendance showing white spaces, I think it needs to be rebuilt like the roster. can you add a button? » Attendance record shows (null) white spaces that can't be edited for students recently added to roster
Component: User interface » Code
Assigned: Unassigned » MGN
Category: feature » bug
Status: Postponed (maintainer needs more info) » Active

Ok, I've been able to reproduce the white spaces that you mention. Do you see this on the attendance page for new students that have been added to a course after attendance has been taken for the rest of the class?

Changing status and title to better reflect the problem that I am seeing.

AntiNSA’s picture

AntiNSA commented

I will try the backup restore asap.
i saw the white spaces, but I could enter the recording of the attendence record, but when viewed I could onlyu see white blanks...

MGN’s picture

MGN commented
Status: Active » Fixed

I think I have fixed this problem now. When new students join a class (or are added to the roster) their (missing) attendance records will be marked as 'Not Set'. This can then be updated by the teacher. The fix has been committed to 6.x-2.x-dev. Feel free to reopen if you have any further problems related to this.

AntiNSA’s picture

AntiNSA commented

I cant wait to try this fix, I think it is when a student changes their name... because I have them on the first da of attendance present, but on the second it is a white blank, (I think after name change.).

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.