The Enrollment reports by Age and Date are fixed. The aging date was always today no matter what date you put in. These are updated and rewritten. The Waiting List scripts are updated to fix a problem where the transfer record wasn't correctly added and waiting list students weren't withdrawn from the list (although they were put into active students). These are all in the updates area for 6.75 and also in the new 7.00 distro.

I've rewritten the custom export version of student data to support multibyte languages like Arabic. The script (expstudent.pl) is located in the updated file area for OA 6.75 to the left.

Due to the prodding of Ashraf B in Egypt, I have worked on support for alternate languages in OA today. First of all I've updated the configuration of MySQL to support UTF-8 from Perl to the database and back.

These are the changes added to my.cnf in the [mysqld] section:
default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init_connect='SET collation_connection = utf8_general_ci; SET NAMES utf8;'
skip-character-set-client-handshake

Previous to these changes, the database was storing Arabic characters as HTML entities. After this update, the characters were stored as real utf-8 values. Editing of students now works correctly for Arabic values. I also changed the HTML headers to indicate the encoding was UTF-8. (charset and chartype vars in admin.conf)

Exporting values to CSV format required a script update and this update is now done (and I'll add to the file updates area for 6.75). Other export scripts will have to be done as well. PDF generation with Arabic characters will present more problems. Currently I'm looking at XeTeX (also present in the TeXLive distribution along with LaTeX).

The Alberta Education export scripts are now available in the 6.75 Updates area to the left.

I'm working on becoming 'Pasi Compliant' for schools in Alberta, Canada. This is work I'm doing for several First Nations schools in Alberta. I do have scripts for generating the SIS File (student demographics), SCM (Student Course Marks) files, and DER (Diploma Exam Registration) (Grade 12 Provincial exam registration) files. So if your school in Alberta wants to start testing OA (Open Admin), I can give you access to those scripts. I normally don't put these in the full distribution since they are only for a limited number of schools. Currently I'm testing OA in the PASI Sandbox, and want to move to Beta testing next. Any questions, please feel free to ask. ( openadmin AT Gmail.com )