Changes

Data quality checks before upgrading to V6.0

270 bytes added, 16:37, 23 June 2014
no edit summary
In V5.xxx it was possible to enter MGRS with wrong format. The first [[MGRS coordinates|query]] checks for coordinates written with lower-case letters e.g. 4qfj12345678 and the second query checks for blanks e.g. 4 QFJ 1234 5678.
===Coordinates display rules(mandatory)===__NOEDITSECTION__
In IMSMA NG there are 3 rules on how to handle and display coordinates, based on how they were entered;
* MGRS,
When data has been migrated or imported it is possible that the column userinputformat in the table ''geopoint'', which controls coordinate display, has not been set correctly. When the display field is set correctly the columns are high-lighted with yellow. If the user tries to edit a row which does not have one of the rules set, the coordinates will not be populated in the Point window. This issue only affects the edit of Auxiliary data coordinates and Data Entry Forms in the Workbench [[Coordinate display rules|(query)]].
 
The three fields coordsys, coordformat and userinputformat must be in a valid combination '''and''' must be consistent with the value of userenteredcoord e.g. (WGS 84, Degrees:Minutes:Seconds, X and Y) with 17.2345|25.5678|en|UK is not a valid combination.
===Length of Point ID===__NOEDITSECTION__
6,632
edits