NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
* Click OK twice to save and exit
==== Adapt SQL fields ====__NOEDITSECTION__
SQL fields, if used in a report, need to be adapted in two ways:* The need to be renamed from '''com.fgm.imsma.ext.report.xxx'''to e.g. '''HazardSQLField'''. In order to be sure about the spelling, an empty report containing all fields of a data source can be created, which then allows to copy-paste fields from this empty report into the ones that is being upgraded.* The SQL query needs to be adapted to the PostgreSQL syntax. Check [[http://mwiki.gichd.org/IM/Difference_MySQL_PostGreSQL#Most_common_changes_in_queries_and_views_from_MySQL_to_PostgreSQL|this page]] for more details.==== Adapt field names ====__NOEDITSECTION__Some IMSMA field names have changed from 5.08.04 to V6. The following error message (when trying to preview the report) can be an indication for that:[[File:iReport_error_message.png|center]]However, check first that the right data source is used indeed.There is no exhaustive list of all changes yet, but please get in touch with VIE in case of doubt.
=== Test and import into IMSMA ===__NOEDITSECTION__
Once all those changes have been made, the report should be ready to run in V6. Finalise the upgrade by carrying out the following steps:
* Compile the report in iReport {{Note|If there are errors, they are most likely not related to the upgrade.}}
* Preview the report in iReport {{Note|If there are errors, they are most likely not related to the upgrade.}}
* Import the iReport template into IMSMA
* Adapt the report definition in IMSMA
* Test the report by running it in IMSMA
* Delete the old reports and report templates in IMSMA
{{NavBox Upgrade}}
[[Category:NoPublic]]