This page is part of the internal FileMaker Pro programming standards of Lutz Pietschker. No claims of any sort can be derived from the description of these standards. In particular, no claim can be made that these standards are complete and without errors, and that any of my software projects follow to these standards in part or completely.
The page content was last revised on (ca. 2008)
Go to start page
This document describes how the database design enables localisation of the database. This includes displayed language and graphics as well as setting of date and time format, currencies etc. This means we talk about display/GUI localization here, not about content localisation.
All language resources reside in the $lng file, i.e. all language-specific texts and graphics are defined there. The database always uses this file to get the language-specific texts and graphics. Other language files, named lang_<code>[.fp7], (symbolic name $lng_<code>) hold these resources for additional languages; <code> is the 2-letter ISO 639 code for the target language. The $lng_<code> files are only used to transport additional language resources.
The internal structure of $lng and all $lng_<code> files are identical. They contain one record per language.
The naming convention for language resource fields is designed to yield short field names which is convenient when texts are used for merge fields:
This is a somewhat loose convention, since it is only for internal use, and also since practical considerations sometimes overrule the intention.
Examples: BtQuit (the "Quit" button label), DtGBLUser (could be the user name, as stored in a global field), InADRWrongNbr (an error message indicating that a wrong number has been entered in a field of the ADDRESS table), BtADRPrt_c (graphics for the "Print" button of the ADDRESS table)
All files are set to use system-defined formats (File Options -> Text -> Data Entry).
If other special language-dependent formatting is required, the display of data shall be done through calculated fields that display different formatting for different language or locale settings.
This page is copyrighted by the author according to the
All rights reserved. Lutz Pietschker, Berlin/Germany, 2011 ff.
, last change 2011-03-12