Gantt Sync CodeUnit

Name: dk.tempusserva.gantt.StructureMigrationCodeUnit

About

This is a codeunit that syncs data from one entity to another.
It also calculates start/end dates if a duration and only one of the dates are given.
If all three are given, an error will be thrown.
It was developed to sync data from a couple of entities to a single one, to display the data as a gantt chart.

Notes

If a duration field is set in the config, the following logic is used when calculating start and end dates.
Default is to copy the dates.
If one of the dates isn't given, then it is calculated based on duration (whole days) and the given date.

All statusIDs have to be set and it isn't possible to map from multiple states to a single state.

Configurations

Configuration	Description
StructureMigrationCodeUnit.From.Field.Duration	Name of the column in the database containing the duration of the task (not required)
StructureMigrationCodeUnit.From.Field.EndDate	Name of the column in the database containing the enddate of the task
StructureMigrationCodeUnit.From.Field.Parent	Name of the column in the database containing the DataID of the parent task
StructureMigrationCodeUnit.From.Field.Progress	Name of the column in the database containing the percentage progress of the task
StructureMigrationCodeUnit.From.Field.Serial	Name of the column in the database containing the unique "code" of the task
StructureMigrationCodeUnit.From.Field.StartDate	Name of the column in the database containing the startdate of the task
StructureMigrationCodeUnit.From.Field.Title	Name of the column in the database containing the title of the task
StructureMigrationCodeUnit.To.Field.EndDate	Name of the column in the database where the end will be stored
StructureMigrationCodeUnit.To.Field.Parent	Name of the column in the database where the DataID of the parent task will be stored
StructureMigrationCodeUnit.To.Field.Progress	Name of the column in the database where the percentage progress of the task will be stored
StructureMigrationCodeUnit.To.Field.Serial	Name of the column in the database where the unique "code" of the task will be stored
StructureMigrationCodeUnit.To.Field.StartDate	Name of the column in the database where the startdate of the task will be stored
StructureMigrationCodeUnit.To.Field.Title	Name of the column in the database where the title of the task will be stored
StructureMigrationCodeUnit.To.Table	Name of the table in the database where all the tasks will be stored
StructureMigrationCodeUnit.Value.Parent	Static value. Use this to staticly set a DataID as parent task for all tasks synced (not required)
StructureMigrationCodeUnit.From.StatusID.Active	StatusID from source entity that should be converted to To.StatusID.Active
StructureMigrationCodeUnit.From.StatusID.Waiting	StatusID from source entity that should be converted to To.StatusID.Waiting
StructureMigrationCodeUnit.From.StatusID.Suspended	StatusID from source entity that should be converted to To.StatusID.Suspended
StructureMigrationCodeUnit.From.StatusID.Completed	StatusID from source entity that should be converted to To.StatusID.Completed
StructureMigrationCodeUnit.From.StatusID.Failed	StatusID from source entity that should be converted to To.StatusID.Failed
StructureMigrationCodeUnit.To.StatusID.Unknown	StatusID from the target entity. Given to tasks that have a status, that isn't defined in the config
StructureMigrationCodeUnit.To.StatusID.Active	StatusID from target entity that matches From.StatusID.Active
StructureMigrationCodeUnit.To.StatusID.Waiting	StatusID from target entity that matches From.StatusID.Waiting
StructureMigrationCodeUnit.To.StatusID.Suspended	StatusID from target entity that matches From.StatusID.Suspended
StructureMigrationCodeUnit.To.StatusID.Completed	StatusID from target entity that matches From.StatusID.Completed
StructureMigrationCodeUnit.To.StatusID.Failed	StatusID from target entity that matches From.StatusID.Failed