IMSMA3 script writing: Difference between revisions

Revision as of 08:07, 19 October 2015

	Changes to scripts in 6.0 are outlined in Script changes 6.0.

The approval function was changed in 5.08.02 and Approved by and Approved date needs to be set in the script in Pojo Fieldreport.

Attribute.SetDate("ReportVerifiedDate", Data.CurrentDate());
Attribute.SetString("VerifiedBy", "migration");

The different dates in the table fieldreport are explained here.

Especially when using Excel as indata it is common that item ID becomes e.g. Assistance-10.0 which is fixed with 2 Cast.

Attribute.SetString("LocalId", "Assistance-" & Cast.String(Cast.Int(Row.GetAttribute("ID"))));

Unfortunately it is still not possible to use the following in scripts:

@@ Line 1: / Line 1: @@
 {{Note | Changes to scripts in 6.0 are outlined in [[Script changes 6.0]].}}
 {{TOC right}}
-==Workarounds==__NOEDITSECTION__
-{{Warning | ICR-114: The update query in [[Multi-select CDFs]] needs to be added as a ''Data.RunSQLStatement'' if any of the fields that are imported are multi-select.}}
 ==Approval information is not set==__NOEDITSECTION__
 The approval function was changed in 5.08.02 and ''Approved by'' and ''Approved date'' needs to be set in the script in Pojo '''Fieldreport'''.