Supporting Open Source Software for Education
November 13, 2009
Comments: 0
by
Sometimes it's the simple things that trip you up. This happened to us when we were converting San Joaquin Delta College's building codes during their migration to the Kuali Financial System (KFS).
At Delta and many other institutions, building codes can contain ampersands and other special characters. KFS doesn't accept these characters in the Building Code fields. (If you're manually entering data through the UI, the system performs a validation that prevents you from entering invalid characters.) Entering special characters in these fields directly in the database causes errors, such as a PO remaining in "en route" status after approval.