Multilanguage database: how to manage display of docs in views?

Greetings All,

I am given a job to make an existing database multi-language. Looking at the topics in this subject, I figured the easiest way to do that for me is to create language profile documents that store the text for labels, msgboxes, etc…

A combo box at home page let’s user to select the language and stores that to a user profile.

Labels are computed texts that lookup the appropriate language profile based on what user selected for language.

Now, the problem is that there will be multiple translation of each document and the views should display only documents that are in language that user set in their profile. Creating one view for each language wouldn’t be idea because language profiles are created by database manager and are somewhat dynamic.

I am looking for ideas on how to manage the display of the documents in this situation?

I appreciate any help

Basir

Subject: Multilanguage database: how to manage display of docs in views?

You cannot base your selection of a view on a Notes.ini parameter using @GetProfileField, but you could set a hidden field in each document that is set during database open, to reflect the correct language.

Subject: RE: Multilanguage database: how to manage display of docs in views?

Thanks Rob, the problem with this method is that it may take a while if there are a lot of documents and creates a high volume of replication which is a bad thing in my context. The database is replicated to almost 100 servers worldwide some with quite slow connections. It also increases the amount of replication conflicts as different users may use different languages at the same time.

I was hoping somebody could suggest a more efficient mechanism.