[OA] Global Enrollment

Les Richardson les at celery.richtech.ca
Thu Nov 23 18:05:05 EST 2006


Hi Methodius,

On Thu, 23 Nov 2006, Methodius Dusyk wrote:

> Hi
>
> When I try to enroll a student into a school from another school in our 
> division I get a "Column count doesn't match value count at row 1" The 
> script in use is entry/globenrol.pl
>
> The cause of the problem is that I have added an extra field to the 
> student table at one of the schools so that the count of values from the 
> first school does not match the number of fields in the second school.
>
> One solution is to make all student and studentwd tables in all schools 
> in the division identical or to have code in the globenrol.pl script 
> that would match the fields and values count.  We currently have 16 
> schools that use Open Admin in our division and two of the schools 
> wanted extra fields in the student tables.

This is pretty ugly to contemplate (changing table structures in multiple 
schools). I think it would be easier just to make the script a 'little 
smarter' in how it handles things.

However, in the longer term, it might make sense to have all schools in 
the division with the same structures since then customization and 
rollouts become a big issue (and pain).

Les




> Methodius
>
> _______________________________________________
> Openadmin mailing list
> Openadmin at pananix.com
> https://www.pananix.com/cgi-bin/mailman/listinfo/openadmin
>


More information about the Openadmin mailing list