IMSMA3 script writing - Revision history

Alnaucler at 17:46, 11 July 2018

2018-07-11T17:46:45Z

← Older revision		Revision as of 19:46, 11 July 2018
Line 74:		Line 74:
	: Attribute.SetInt("Number", 1)		: Attribute.SetInt("Number", 1)
	: Attribute.SetInt("NumberOfDependentsAge0To18", Cast.Int(Row.GetAttribute("clnCA_UserDefined1")))		: Attribute.SetInt("NumberOfDependentsAge0To18", Cast.Int(Row.GetAttribute("clnCA_UserDefined1")))
	Multi-select		* Multi-select
	:		: Attribute.AddToSet("HazreducMethods", Pojo.GetImsmaenumByCategory("Clearance Operation", "Manual"))
	* ~~Number~~		: Attribute.AddToSet("Vegetations", Pojo.GetImsmaenumByCategory("Vegetation", Row.GetString("clnVegetationTC")))
	:		* Ordnance
			: Attribute.SetObject("Ordnance", Pojo.GetPojoByGuid("Ordnance", Row.GetString("clnDeviceSelectedGUID")))
			: Attribute.SetObject("Ordnance", Pojo.GetPojoByGuid("Ordnance", "{00000020-0000-0000-0000-000000000000}"))
			* Organisation
			: Attribute.SetObject("Organisation", Pojo.GetPojoByGuid("Organisation", Translate.toDbLookup("org_guid", "organisation", "org_guid", Cast.String(Row.GetAttribute("clnOrganisationGUID")))))
			* Place
			: Attribute.SetObject("Medicalfacilitylevel3", Pojo.GetPojoByGuid("Place", Row.GetString("clnMedicalLevel3GUID")))
	* Single-select		* Single-select
	:		: Attribute.SetObject("VegetationDensity", Pojo.GetImsmaenumByCategory("Density", "Not Specified"))
	String		: Attribute.SetObject("OccupationAfterEvent", Pojo.GetImsmaenumByCategory("Occupation", Row.GetString("clnCA_UserDefined13")))
	:		: String
	* Time		: Attribute.SetString("Bestroutetohazard", Row.GetString("clnRouteToSite"))
	:		* Time (which is kind of a date)
			: Attribute.SetDate("TimeToHospital", Cast.Date("2015-10-10 " & Translate.toDbLookupSQL( " SELECT to_char( (( \"tblIncAccCasualty\".\"clnTimeToHospital\" * 60) \|\| 'minute')::interval, 'HH24:MI:SS') FROM \"tblIncAccCasualty\" WHERE \"clnGUID\" = ?", Row.GetString("clnGUID") ) ))
	* Timestamp		* Timestamp
			: Attribute.SetDate("StartDate", Cast.Date(Cast.String(Row.GetString("Start of Reporting Period"))& " 14:00:00"))
	{{NavBox Hub}}		{{NavBox Hub}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 17:37, 11 July 2018

2018-07-11T17:37:28Z

← Older revision		Revision as of 19:37, 11 July 2018
Line 62:		Line 62:
	==Data types==__NOEDITSECTION__		==Data types==__NOEDITSECTION__
	* Boolean		* Boolean
	:		: Attribute.SetBoolean("Active", Cast.Boolean("true"))
			: Attribute.SetBoolean("Active", Cast.Boolean("1"))
	* Date		* Date
	:		: Attribute.SetDate("DateOfReport", Cast.Date(Row.GetAttribute("clnEntryDate")))
			: Attribute.SetDate("ReportVerifiedDate", Data.CurrentDate())
	* Decimal		* Decimal
	:		: Attribute.SetDecimal("AreaSize", Cast.Decimal(Row.GetAttribute("Area Cleared")))
	* Float		* Double/Float
	:		: Attribute.SetDouble("Latitude", Cast.Double(Row.GetAttribute("clnLatitude")))
	* Integer		* Integer
	:		: Attribute.SetInt("Number", 1)
			: Attribute.SetInt("NumberOfDependentsAge0To18", Cast.Int(Row.GetAttribute("clnCA_UserDefined1")))
	Multi-select		Multi-select
	:		:

Alnaucler at 17:32, 11 July 2018

2018-07-11T17:32:47Z

@@ Line 58: / Line 58: @@
 : this function is super old and the link between Accident/Victim is nowadays done link the other items via the table ''Link''
 * ApproveHazardReductionAsProgress
-: if the country really want to combine the Progress reports with the Clearance report then I would use Combine
+: if the country really want to combine the Progress reports with the Clearance report then I would use Combine.
 {{NavBox Hub}}
 [[Category:NoPublic]]
 [[Category:NAA]]

Alnaucler at 11:03, 14 June 2017

2017-06-14T11:03:23Z

← Older revision		Revision as of 13:03, 14 June 2017
Line 39:		Line 39:
	\| ApproveAsUpdateBase \|\| ??? \|\| \|\|		\| ApproveAsUpdateBase \|\| ??? \|\| \|\|
	\|-		\|-
	\| ApproveLocationAsNew \|\| 6.0 \|\| [[~~Script~~ changes 6.0#Location\|Location]] \|\|		\| ApproveLocationAsNew \|\| 6.0 \|\| [[IMSMA3 script changes 6.0#Location\|Location]] \|\|
	\|-		\|-
	\| ReconcileAsDelete \|\| 6.0 \|\| Same as above but DEF will be found in the Workbench \|\|		\| ReconcileAsDelete \|\| 6.0 \|\| Same as above but DEF will be found in the Workbench \|\|

Alnaucler at 11:02, 14 June 2017

2017-06-14T11:02:34Z

← Older revision		Revision as of 13:02, 14 June 2017
Line 1:		Line 1:
	{{Note \| Changes to scripts in 6.0 are outlined in [[~~Script~~ changes 6.0]]. In the [[Data Dictionary]] you will find the target field names that should be used in the scripts in the column ''Pojo name''. We also have more documentation than provided in ''C:\IMSMAng\migration\doc'', training material from several GICHD IM trainings and the one script training provided in Afghanistan.}}		{{Note \| Changes to scripts in 6.0 are outlined in [[IMSMA3 script changes 6.0]]. In the [[Data Dictionary]] you will find the target field names that should be used in the scripts in the column ''Pojo name''. We also have more documentation than provided in ''C:\IMSMAng\migration\doc'', training material from several GICHD IM trainings and the one script training provided in Afghanistan.}}
	{{TOC right}}		{{TOC right}}
	==Approval information is not set==__NOEDITSECTION__		==Approval information is not set==__NOEDITSECTION__

Alnaucler: Alnaucler moved page Script writing to IMSMA3 script writing without leaving a redirect

2017-06-14T10:58:37Z

Alnaucler moved page Script writing to IMSMA3 script writing without leaving a redirect

← Older revision	Revision as of 12:58, 14 June 2017
(No difference)

Alnaucler at 13:22, 22 June 2016

2016-06-22T13:22:43Z

← Older revision		Revision as of 15:22, 22 June 2016
Line 29:		Line 29:
	\| ApproveAsDelete \|\| 6.0 \|\| [[Delete from the Summary Window]] \|\|		\| ApproveAsDelete \|\| 6.0 \|\| [[Delete from the Summary Window]] \|\|
	\|-		\|-
	\| ApproveAsEdit \|\| 6.0 \|\| [[Update ~~the Data in the~~ Summary Window]] \|\| Not suitable for scripts if you will not update '''all''' fields of the item		\| ApproveAsEdit \|\| 6.0 \|\| [[Update from Summary Window]] \|\| Not suitable for scripts if you will not update '''all''' fields of the item
	\|-		\|-
	\| ApproveAsNew \|\| 5.x \|\| [[Reconcile as New]] \|\|		\| ApproveAsNew \|\| 5.x \|\| [[Reconcile as New]] \|\|

Alnaucler at 04:43, 2 May 2016

2016-05-02T04:43:25Z

← Older revision		Revision as of 06:43, 2 May 2016
Line 53:		Line 53:
	\| ReconcileLocationAsNew \|\| 6.0 \|\| Same as above but will be found in the Workbench \|\|		\| ReconcileLocationAsNew \|\| 6.0 \|\| Same as above but will be found in the Workbench \|\|
	\|}		\|}


	Do NOT use:		Do NOT use:
	ApproveAndLinkVictim		* ApproveAndLinkVictim
	ApproveHazardReductionAsProgress		: this function is super old and the link between Accident/Victim is nowadays done link the other items via the table ''Link''
			* ApproveHazardReductionAsProgress
			: if the country really want to combine the Progress reports with the Clearance report then I would use Combine

	{{NavBox Hub}}		{{NavBox Hub}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 04:35, 2 May 2016

2016-05-02T04:35:42Z

@@ Line 1: / Line 1: @@
-{{Note | Changes to scripts in 6.0 are outlined in [[Script changes 6.0]].}}
+{{Note | Changes to scripts in 6.0 are outlined in [[Script changes 6.0]]. In the [[Data Dictionary]] you will find the target field names that should be used in the scripts in the column ''Pojo name''. We also have more documentation than provided in ''C:\IMSMAng\migration\doc'', training material from several GICHD IM trainings and the one script training provided in Afghanistan.}}
 {{TOC right}}
 ==Approval information is not set==__NOEDITSECTION__
@@ Line 15: / Line 15: @@
 </pre>
 ==Limitations==__NOEDITSECTION__
 Unfortunately it is still not possible to use the following in scripts:
@@ Line 21: / Line 20: @@
 * less than (<)
 * LIKE (e.g. Eriks* or Eriks%)
 {{NavBox Hub}}
 [[Category:NoPublic]]
 [[Category:NAA]]

Alnaucler at 07:07, 19 October 2015

2015-10-19T07:07:32Z

← Older revision		Revision as of 09:07, 19 October 2015
Line 1:		Line 1:
	{{Note \| Changes to scripts in 6.0 are outlined in [[Script changes 6.0]].}}		{{Note \| Changes to scripts in 6.0 are outlined in [[Script changes 6.0]].}}
	{{TOC right}}		{{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__		==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'''.		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'''.