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. }}
{{Note | All steps below '''are''' mandatory and should be done in the mentioned order.}}
===Data Quality SQL queries===__NOEDITSECTION__
''Raw'' as in it is PostGreSQL format but the table structure, etc. are still 5.08.04 and needs to be upgraded to V6.0.
===Restore the raw dump and correct FK Foreign Key constraints===__NOEDITSECTION__
{{Warning| Do '''NOT''' restore GIS database and map data. You need to rebuild the sandbox and by restoring the map you will '''overwrite''' the ArcGIS 10.1-version of ''imsma.mxd'' in C:\IMSMAng\server\gis\maps with the ArcGIS 9.3.1-version.}}
{{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}}
===Templates - Checking the templates by publishing them in V6.0 (mandatory)===__NOEDITSECTION__
After you have either run the tool or removed the images manually you should test that all published templates are still working by publish them in V6.0. Check the log when you drag them into the designer.
This error message in the log means that there is still an image in wrong format in the template:
* value list of multi-select is changed.
===Templates - Checking the templates by opening them for data entry (mandatory)===__NOEDITSECTION__
After you have published the templates then open them and check the log when you open them. Scroll through the template and look for any single and multi-select that have default values that do not look OK/normal to be set to default.