Changes

Jump to: navigation, search

Data quality checks before upgrading to V6.0

120 bytes added, 17:50, 12 February 2014
no edit summary
The next level of check is to check if the value ‘ ‘ have been stored AND if all different data types are NULL. An old bug created empty strings for specially Auxiliary data CDFs. This bug created unnecessary many rows in the table ''cdfvalue'' and makes it impossible to delete CDFs that actually never have been used for data entry [[Empty CDF|(query)]].
===Duplicated values in allow_value_set (mandatory)===__NOEDITSECTION__Duplicates may have been by migration and import mistakes [[Duplicate allow value|(query)]]. This could be addressed when CDFvalues are moved to standard fields after upgrade.
===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__
One country had changed the name of the column ''Filedescription''. Note it that the name has to be start with capital F.
===Orphans in Country Structure (mandatory)===__NOEDITSECTION__
6,632
edits

Navigation menu