NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Warning | All IMSMA databases are different and '''all''' of the steps below are important for getting all countries to a functional V6.0. }}
===Data Quality SQL queries===__NOEDITSECTION__
__FORCETOC__
===Extract MySQL===__NOEDITSECTION__
Use the '''MySQLtoPGSQL''' tool which will generate two files:
The MySQLtoPGSQL tool does not have any installation program. Just copy the folder to somewhere on the C-drive.
The tool should be run twice:
{{Note| That other errors in templates are '''NOT''' fixed by this tool or by upgrading. If you do not address the image issue the templates will not be possible to use for data entry or to edit in V6.0 (after the first publish in V6.0}}
* Data entry templates
: There are many database changes between previous versions and V6.0 and therefore existing templates might need to be updated. In the Using IMSMA portal, Viewing and Browsing, [[Items Pane]] there are lists with the new fields added in the upgrade.
* Summary templates
* SQL views
: The SQL views needs to be redone in PostGreSQL and may be redone from scratch or by editing view.sql (output from the extracting step).
* Do they have data stored in CDFs that there are standard fields for in V6.0?
: If yes, is there performance or other gains by moving the data to standard fields?
: If yes, the source and target fields need to be mapped. There is a template Excel file for that.
* Coordinate system manager