Ignition 7.5.5 - Reporting Module and unicode strings

Hi,

When using a dataset returning strings with accents (ie Février, Août…), the report module cannot interpret this.
A workaround is to use unicodedata library to get the dataset without accents, but it’s not acceptable by our customers (SI and end users).

Any tricks ?

Regards,

Those characters work for me. Can you export a small window that illustrates the problem and upload it here?

Hi Travis,
Sure, here it is.

cgb_2013-03-07_2238_partial.proj (83.8 KB)

Ok, I see. It is not the data to display but the column names that have accent characters. You can’t use accent characters as the column names with the report. It needs basic ASCII. The query should return simple column names like:

SELECT col1, col2 …

If your columns in the database have accent characters you can alias the names:

SELECT août AS aout …

removing the accent characters. In your table you can always override what the header says by using the customizer and changing the header name.

Yes, it’s what we did with a function with replace etc. But in these unicode days…
By the way, the unicodedata library is working on some pc (tested 6 pcs) but not on some other. All in 7.5.5 and some Java 6, some Java 7…

def sans_accents(chaine): import unicodedata chaine = unicodedata.normalize('NFKD', chaine).encode('ASCII', 'ignore') return chaine