NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
===SQL syntax===__NOEDITSECTION__
{{Note | It is strongly recommended to copy all SQL statements to a SQL tool like PGadminIII or NaviCat and test them before running the script in {{IMSMANG}} 6.0}}
Due to PostgreSQL is case sensitive you need to adapt SQL statements by adding " around column names that contains capital case and because of the " you also need to add \ (escape character).<br/>
'''5.08.04 example'''
<pre>
<pre>
SELECT \"Loc_VillageGUID\", \"mMREID\" FROM loc_link_mre WHERE \"Loc_VillageGUID\" IS NOT NULL
</pre> <br/>
In PostgreSQL there are other reserved words than in MySQL. In your SQL tool you will see them marked with blue text. <br/>
[[Image:Reserved_word1.png|800px|center]]
Attribute.SetBoolean("Active", Cast.Boolean("true"))
</pre>
===Multi-select===__NOEDITSECTION__
{{Note | If any of the fields that are imported are multi-select then you need to verify that position in cdfvalue is set. Scripts run with 6.0 works better than 5.08.04, see ICR-114. If position is NOT set then the update query in [[Multi-select CDFs]] needs to be added as a ''Data.RunSQLStatement'' in Migration Cleanup or run in a SQL tool. }}
===Geodata===__NOEDITSECTION__
The column ''userenteredcoord'' has been split up in 3 columns
* UserInputFormat
===Key and Object Mapping===__NOEDITSECTION__
One parameter seems to be need to be changed '''from'''
Object.SetKeyedObjectMapping(Row.GetString("clnGUID"), "Geopoint", Object.CreatePojo("Geopoint"))
'''to '''
Object.SetKeyedObjectMapping("", "GeopointDA", Object.CreatePojo("Geopoint"));
{{Note | The second parameter is a variable name and I find it easier to read the scripts if the variable have a slightly different name than the third parameter which is the pojo''.}}
===Mandatory information===__NOEDITSECTION__
{{Note | There is no changes in version 6.0 for these fields but there were a change in version 5.08.02 and many existing scripts are not yet updated. I would also recommend to double-check '''new''' scripts written by Novetta.}}
{{Note | Other clean-up and value setting in Domain-MigrationCleanup.mtxt '''still''' needs to be done.}}
===Multi-selectMRE details===__NOEDITSECTION__ {{Note | If any of The difference between other items and Education which is using the fields that are imported are multi-select then you need to verify that position in cdfvalue table ''mredetail'' is setthe double reconciliation. Scripts run with In version 6.0 works better than 5the approach is as e.08g.04, see ICR-114Hazdeviceversion with a loop using SQLSubQuery and Pojo.SetChildren + Pojo. If position is NOT set then PersistPojo after the update query in [[Multi-select CDFs]] needs loop. The link to be added as a the table ''Data.RunSQLStatementfieldreport'' needs to be added in Migration Cleanup or run in a SQL toolthe end of the loop Attribute.SetObject("Fieldreport", Pojo.GetPojoByGuid("Fieldreport", Cast.String(Object. }}GetKeyedMapping("", "FieldReport"))));
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:NAA]]