Set i18n localization for a particular record

Classic Servoy
1

Hello everybody,

I have a db where some of the contacts are English, and others are French (a language key is set in each record). Understandably, we want the correspondence (invoices, orders, etc.) for each one of these contacts to reflect their own language (the Servoy Client interface already adapts to the current user’s locale, so I’m talking about another level of customization). Is there a way to :

  • Set the locale to French to obtain the correct i18n values for labels
  • Print a French Invoice for a French client
  • Set the locale to English to obtain the correct i18n values for labels
  • Print an English Invoice for a English client
  • etc. :?:

I know that i18n.setLocale() will execute on all forms not yet loaded. Could I then unload a form, set the locale, load the form, print, then unload it again? If so, how? :?:

Using i18n would save me a lot of work - otherwise, I would have to completely recreate another db/relation structure for the multi-lingual labels I wish to make appear on my record-specific forms, and that would be a real bummer, seeing as we have the i18n tool right there at our fingertips already… :(

Thanks in advance for your help,

Ben

2

It’s not possible with the locale functionality provided in Servoy, it does not work on data level.
but having a script doing an text (right language) update for all you printable labels should be easy