Sort order to attendance register

Hi,

We have always organised our student data alphabetically by first name (we are a small school!). It would be great to organise the attendance registers this way too, so we can avoid confusion for staff as we move over to Gibbon. Is there any way to do this?

Thanks in advance for your help!

Hi Dorian,

There is no global switch for this I am afraid. The closest you can come at the moment is to edit the roll order value for each student (under People > Students > Student Enrolment), which impacts the ordering of students in the Markbook, and also for attendance taking.

This is the kind of feature we will be in a better position to offer in v18 or v19, once we are further forward in our efforts refactoring the code base here. At the moment there is a lot of repeated code, making such changes harder.

Thanks,

Ross

Hi Ross,

Thanks for the info. I think we’ll wait until v18 or v19 :smile:

Thanks!

Dorian

Hello Members

Are we still sorting attendance using the roll order (editing students one by one) or there’s a setup available. After setting up majority of the things I’ve realized the attendance list is not sorted in any order ( student’s are random under take attendance).

is the feature hidden in the settings?

Kindly assist. Thank you.

Students should be ordered by surname. I never used roll order though.

I have double checked and it’s not ordered by surname. But I went to my data import excel sheets and I realized I setup students of the same year group to have same Roll Order ( Y11- 3, y10- 2, y9- 1 ). How is this treated in DB to reflect this disorder in the attendance register?

Thank you

Hi Kelvin,

Roll order is different than roll group/form group, it’s the order of students within the group. As Roman mentioned, this defaults to the surname, unless the roll order is specifically defined. Roll order should be a numeric number, eg: 1 - 30 for a roll group of 30 students. If you’ve imported a non-numeric value, it likely got converted on import to something vaguely numeric, and I suspect this is why the roll order appears to be random. You can check the roll order by editing a student in the Student Enrolment page.

Kelvin, the roll order field controls ordering within a roll group, if you don’t want to use surname then preferredName. Please can you double check the roll order of the students involved to make sure it is blank? Thanks!

Thank you for the response,

I really understand the use of roll order now( while doing imports the understanding wasn’t clear). The current disorder is because in one roll group all students have same roll order number (like Year 10’s have 2 from the imports I made).
Editing under

I did double check and surname A-Z or Z-A is not followed.

Hi Kelvin, in this case it’s best to set those roll order’s back to blank, rather than the same value, to ensure the system falls back to using the surname. Many areas of the system check to see if the value is blank to determine which order to use.

Thank you, I guess that would be the solution for now though its the whole school affected, so I might use data import and set up import to “update” and probably skip some fields. would that be a solution to bulk editing?

Yes, a re-import with Update Only, and then set the Roll Order to null should help reset it. If you have MySQL access and know your school year ID (from the School Year table), the following command can also reset them:

UPDATE gibbonStudentEnrolment SET rollOrder = NULL WHERE gibbonSchoolYearID=026;`

Thank you so much :wink:
I will use MySQL that will be more quicker. good reset of Roll Order to NULL.

Hi,

We have always organised our student data alphabetically by first name (we are a small school!). It would be great to organise the attendance registers this way too, so we can avoid confusion for staff as we move over to Gibbon. Is there any way to do this?

Thanks in advance for your help!

I Quite agree. It is far better in alphabetical order and easier to find a name

Hello, to be clear, alphabetical is the default in all areas of Gibbon, unless you override it by using the Roll Order field in People > Student > Student Enrolment, which allows for custom enrolment. Cheers! Ross.