Upgrade from 5.08.04 to 6.0 process: Difference between revisions
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
The user-entered format of the coordinates is stored in the database in this format: | The user-entered format of the coordinates is stored in the database in this format: | ||
X | Y | language | country | e.g. 474522|4615907|en|GB| in the column | X | Y | language | country | e.g. 474522|4615907|en|GB| in the column ''userenteredcoord'' in the table ''geopoint''. | ||
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 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. | ||
| Line 18: | Line 18: | ||
Note that 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. | Note that 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. | ||
=== | ===Run V5.08.04 tools - Re-calculation of area/length===__NOEDITSECTION__ | ||
===Interacting with Panes===__NOEDITSECTION__ | ===Interacting with Panes===__NOEDITSECTION__ | ||
Revision as of 18:22, 10 February 2014
Data Quality SQL queries
There are several SQL queries that should be run before starting the upgrade process, see xxx link.
Run V5.08.04 tools - Locale fix
This tool was created for the upgrade to 5.08.04 and addresses old issues. Many countries did not run it and import scripts may have created new records with issues. This tool has to be run before re-calculation the area/length and upgrading to V6.0.
The user-entered format of the coordinates is stored in the database in this format: X | Y | language | country | e.g. 474522|4615907|en|GB| in the column userenteredcoord in the table geopoint.
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.
Start the tool by clicking on C:\IMSMAng\ext\LocaleUpdater\run.bat.
Note that 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.