Changes

Data quality checks before upgrading to V6.0

12 bytes added, 18:53, 12 February 2014
no edit summary
* X and Y.
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)]].
===Length of Point ID===__NOEDITSECTION__
===CDF never used for Data Entry===__NOEDITSECTION__
Note that a CDF may be included in Data Entry templates, Summary templates, Saved searches, etc. but have no values in table ''cdfvalue''. This is not an error but if they have many non-used CDFs it is an indication that IM procedures may be improved [[CDF not used|(query)]].
===Records with empty values in table cdfvalue===__NOEDITSECTION__
===Invalid date in link table (mandatory)===__NOEDITSECTION__
The date value 0000-00-00 00:00:00 is invalid and has been found in the table ''link '' [[Link invalid date|(query)]].
===Attachment table(mandatory)===__NOEDITSECTION__
6,632
edits