NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
The locale portion (|en|GB|) of userenteredcoord was added in V5.06.00 but the existing geopoints were not given locale information by the database upgrade functionality. If the locale information was missing, it was added later when field reports were e.g. imported. However, then it was the regional settings of the user doing the import that was used. This created invalid combinations when the data entry was done with other regional settings.
The Locale fix tool will verify that there are no invalid combinations of decimal symbol and locale information in the database. If invalid combinations are stored the tool will try to fix them but there may be combinations that will require SQL updating. This '''[[Locale Pre-check SQL | query]]''' finds userenteredcoord that the tool cannot fix.
{{Note | You might need to run the tool with two different regional settings i.e. first with dot as decimal symbol and then with comma as decimal symbol.}}