Supporting Open Source Software for Education

rSmart

 

Share |

conversion

November 13, 2009
Comments: 0

Avoiding Conversion Gotchas

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.