ActionField1048

Beschrijving: Generate Excel dayplanning for Ultimo Inside. Custom: Nee

Propertiesbewerken

XMLbewerken

<Workflow Name="ActionField1048" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Generate Excel dayplanning for Ultimo Inside.</Description>
	<Properties>
		<Property	Name="SkillCategories"	Type="UltimoString"	Accessor="Optional"	Direction="In"						Comment="Generate planning for these SkillCategories (default 'CSS01', 'CSS02', 'CSS03', 'CSS04', 'CSS05', 'D', 'PROJ')" />

		<Property	Name="FileName"			Type="UltimoString"	Accessor="Internal" />
		<Property	Name="FromDate"			Type="Date"			Accessor="Internal" />
		<Property	Name="Reservations"		Type="Boolean"		Accessor="Internal"						Default="True" />
		<Property	Name="TillDate"			Type="Date"			Accessor="Internal" />
	</Properties>
	<Execution>
		<UserContent Name="Pre" />

		<Dialog Name="Select data for excel report" TitleCode="CHOOSERECORDSDIALOG">
			<Container>
				<Date Name="FromDate" Value="=#adddays(#{Environment.CurrentDate}, -14)" OutputProperty="${FromDate}" Required="False" LabelCode="STARTDATE" />

				<Date Name="TillDate" Value="=#addmonths(#{Environment.CurrentDate}, 6)" OutputProperty="${TillDate}" Required="False" LabelCode="ENDDATE" />

				<CheckBox Name="Reservations" Value="True" OutputProperty="${Reservations}" Required="False" LabelCode="RESERVATIONS" />
			</Container>
		</Dialog>

		<Transaction>
			<Assign Name="construct a filename" Property="${FileName}" Value="Planning.xlsm" />

			<Command Name="Employee_ExcelExportDaySchedule" CommandName="Employee_ExcelExportDaySchedule">
				<Parameter	Name="FromDate"					Direction="In"		Value="${FromDate}" />
				<Parameter	Name="IncludingReservations"	Direction="In"		Value="${Reservations}" />
				<Parameter	Name="InputFileName"			Direction="In"		Value="${FileName}" />
				<Parameter	Name="SkillCategories"			Direction="In"		Value="${SkillCategories}" />
				<Parameter	Name="TillDate"					Direction="In"		Value="${TillDate}" />
			</Command>
		</Transaction>

		<UserContent Name="Post" />

		<View Name="View document" ViewName="ExternalDocumentViewer">
			<Parameter	Name="FileName"	Direction="In"		Value="TEMP\${FileName}" />
		</View>
	</Execution>
</Workflow>