Changes

Jump to: navigation, search

Data quality checks before upgrading to V6.0

194 bytes added, 15:10, 20 May 2014
no edit summary
Having duplicates on name (on the same level/node) in the country structure e.g. two villages called “Berg” in the one municipality creates a lot of problems when importing data and creating statistics. Note that the duplicates are not shown in the GUI [[Country structure duplicates|(query)]].
===Saved searches Data quality queries - Duplicates===__NOEDITSECTION__The upgrade script will add some of these [[SQL Saved search Duplicate ID|queries]] to the database as saved searches. You may run them now as SQL queries or later as Saved searches.
===Saved searches Data quality queries - No geographical data===__NOEDITSECTION__
The upgrade script will add these [[SQL Saved search No geo data|queries]] to the database as saved searches. You may run them now as SQL queries or later as Saved searches.
===Saved searches Data quality queries - No links===__NOEDITSECTION__
The upgrade script will add these [[SQL Saved search No links|queries]] to the database as saved searches. You may run them now as SQL queries or later as Saved searches.
===Saved searches Data quality queries - Different Location===__NOEDITSECTION__
The upgrade script will add these [[SQL Saved search Different Location|queries]] to the database as saved searches. You may run them now as SQL queries or later as Saved searches.
===Saved searches Data quality queries - Task===__NOEDITSECTION__
The upgrade script will add these [[SQL Saved search Task|queries]] to the database as saved searches. You may run them now as SQL queries or later as Saved searches.
===Saved searches Data quality queries - Mine Action quality===__NOEDITSECTION__The upgrade script will add these [[SQL Saved search MA quality|queries]] to the database as saved searches. You may run them now as SQL queries or later as Saved searches. There are more Saved Searches than these mentioned here added to the database but they are referencing to tables/fields that do not exist in 5.08.04.
[[Category:NoPublic]]
{{NavBox Upgrade}}
6,632
edits

Navigation menu