Difference between revisions of "Gantt Sync CodeUnit"
Jump to navigation
Jump to search
old>Tvi |
old>Tvi |
||
| Line 6: | Line 6: | ||
Name: dk.tempusserva.gantt.StructureMigrationCodeUnit | Name: dk.tempusserva.gantt.StructureMigrationCodeUnit | ||
=== Notes === | |||
If a duration field is set in the config, the following logic is used when calculating start and end dates.<br/> | |||
Default is to copy the dates.<br/> | |||
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 == | == Configurations == | ||
| Line 70: | Line 77: | ||
|StructureMigrationCodeUnit.Value.Parent | |StructureMigrationCodeUnit.Value.Parent | ||
|Static value. Use this to staticly set a DataID as parent task for all tasks synced | |Static value. Use this to staticly set a DataID as parent task for all tasks synced (not required) | ||
|- | |- | ||
| Line 118: | Line 125: | ||
|} | |} | ||
Revision as of 13:55, 5 August 2021
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.
Name: dk.tempusserva.gantt.StructureMigrationCodeUnit
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 |