Data quality checks before upgrading to V6.0

From IMSMA Wiki
Revision as of 18:35, 6 February 2014 by Alnaucler (talk | contribs)
Jump to navigation Jump to search

Invalid / space coordinates

How To

{{#if:Space coordinates |

|}}{{#if:MGRS coordinates |

|}}{{#if:Coordinate display rules |

|}}{{#if:Point ID Length |

|}}{{#if:Missing approval information |

|}}{{#if:Missing Date of Information |

|}}{{#if:|

  • {{{7}}}|}}{{#if:|
  • {{{8}}}|}}{{#if:|
  • {{{9}}}|}}{{#if:|
  • {{{10}}}|}}{{#if:|
  • {{{11}}}|}}{{#if:|
  • {{{12}}}|}}{{#if:|
  • {{{13}}}|}}{{#if:|
  • {{{14}}}|}}{{#if:|
  • {{{15}}}|}}{{#if:|
  • {{{16}}}|}}{{#if:|
  • {{{17}}}|}}{{#if:|
  • {{{18}}}|}}{{#if:|
  • {{{19}}}|}}{{#if:|
  • {{{20}}}|}}{{#if:|
  • {{{21}}}|}}{{#if:|
  • {{{22}}}|}}{{#if:|
  • {{{23}}}|}}{{#if:|
  • {{{24}}}|}}{{#if:|
  • {{{25}}}|}}{{#if:|
  • {{{26}}}|}}{{#if:|
  • {{{27}}}|}}{{#if:|
  • {{{28}}}|}}{{#if:|
  • {{{29}}}|}}{{#if:|
  • {{{30}}}|}}{{#if:|
  • {{{31}}}|}}{{#if:|
  • {{{32}}}|}}{{#if:|
  • {{{33}}}|}}{{#if:|
  • {{{34}}}|}}{{#if:|
  • {{{35}}}|}}{{#if:|
  • {{{36}}}|}}{{#if:|
  • {{{37}}}|}}{{#if:|
  • {{{38}}}|}}{{#if:|
  • {{{39}}}|}}{{#if:|
  • {{{40}}}|}}{{#if:|
  • {{{41}}}|}}{{#if:|
  • {{{42}}}|}}{{#if:|
  • {{{43}}}|}}{{#if:|
  • {{{44}}}|}}{{#if:|
  • {{{45}}}|}}{{#if:|
  • {{{46}}}|}}{{#if:|
  • {{{47}}}|}}{{#if:|
  • {{{48}}}|}}{{#if:|
  • {{{49}}}|}}{{#if:|
  • {{{50}}}|}}

It was not possible to upgrade to V5.08.04 if there are invalid coordinates in the database. Please run this SQL query anyhow because importing may overrun application rules. If you get any rows here, you have more SQL queries that will identify which object has the invalid coordinates in “Invalid_coordinates_ver2.doc” on PI.

MGRS coordinates

In V5.xxx it was possible to enter MGRS with wrong format. The first 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

In IMSMA NG there are 3 rules on how to handle and display coordinates, based on how they were entered;

  • MGRS,
  • Distance/Bearing
  • 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.

Length of Point ID

Point (local) ID should be unique and clearly identify single and polygon points. But it is possible to type blanks instead of characters/numbers. If spaces have been used it is not possible for the users to see difference when entering/editing the points. If you get length 0, 1 or 2 I recommend to look into the values of Point ID.

Missing approval information

Due to changed behaviour of migration/import scripts in version 5.08.02 and a bug in 5.08.04 approval information may be missing. Note that Last updated gets updated e.g. when templates are switched and should not be used for setting Approved Date. If the Data Entry Form that misses Approved Date is an Activity or Education then you might be able to use End date.

Column Old label New label
reportReceivedDate Initiated Data Entry Date
reportCompletedDate Submitted Submitted Date
reportVerifiedDate Approved Approved Date
dateofreport Date of Report Date of Information
dataentrydate Last updated (no change)

Missing Date of Information

Date of Information (stored in table fieldreport) is used when IMSMANG calculates the Summary (former Current view). If this data is missing then the result may not be as the expected when the Summary is updated. Note that Last updated gets updated e.g. when templates are switched and should not be used for setting Date of Information. If the Data Entry Form that misses Approved Date is an Activity or Education then you might be able to use End date.

Length of Point ID

Length of Point ID

Length of Point ID

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Data_quality_checks_before_upgrading_to_V6.0&oldid=13381"