Changes

Data quality checks before upgrading to V6.0

63 bytes added, 23:30, 12 November 2016
no edit summary
===Missing Local ID (DEF, items, Auxiliary data and Task)(mandatory)===__NOEDITSECTION__
In some database also Form ID and the items' local ID have been missing. If Form ID is null then the [[Empty Reconciliation Tab#Case 2 The tab is highlighted and no error message in the log | '''Reconciliation tab will be empty''']] and it is not possible to see which ''Action'' was used. The On this page you find [[Missing Local ID|MySQL queries]] also include for checking if you need to populate IDs including Auxiliary data and Task.
This '''[[Fieldreport ID and Dates | page ]]''' provides an overview of the fields in the table ''fieldreport''.
6,632
edits