Forms

It is possible to design forms in many different languages and scripts. If your language has non-roman characters, you should make sure your database must be set-up to handle the storage of your character set. UTF8 works well.

To enable support for other encoding formats, the OPENDATA_SETTINGS.properties file has to be changed to reflect the desired encoding format the user wishes to use.

The OPENXDATA_SETTINGS.properties file, found under your webapp directory, can be changed like this.

  • hibernate.connection.url=jdbc:mysql://localhost:3306/openxdata?autoReconnect=true&useUnicode=true&characterEncoding=UTF8
  • hibernate.connection.createdb.url=jdbc:mysql://localhost:3306/?autoReconnect=true&useUnicode=true&characterEncoding=UT8

Please note that we are appending/changing these two parameters in each URL:

  • &useUnicode=true
  • &characterEncoding=UTF8

That will enable the system to run with the specified character encoding.

With table settings set to utf8_unicode, urdu characters have been successfully downloaded onto a phone, entered as free text data, uploaded to the database and viewed in dashboard.

Important to Note

Some MySQL database versions might not be able to support the specified encoding format. Be sure to cross check that the version of MySQL supports the encoding format specified or else the system will not start.

Mobile client

It is also possible to translate the mobile client using the menu_forms.properties text file. This has been tested in spanish and found to work, but did not work when briefly tested in Urdu (similar to the Arabic character script).