Difference between revisions of "Gantt Sync CodeUnit"
Jump to navigation
Jump to search
old>Tvi (Created page with "== About == This is a codeunit that syncs data from one entity to another.<br/> It also calculates start/end dates if a duration and only one of the dates are given.<br/> If a...") |
old>Tvi |
||
| Line 14: | Line 14: | ||
|StructureMigrationCodeUnit.From.Field.Duration | |StructureMigrationCodeUnit.From.Field.Duration | ||
| | |Name of the column in the database containing the duration of the task (not required) | ||
|- | |- | ||
|StructureMigrationCodeUnit.From.Field.EndDate | |StructureMigrationCodeUnit.From.Field.EndDate | ||
| | |Name of the column in the database containing the enddate of the task | ||
|- | |- | ||
|StructureMigrationCodeUnit.From.Field.Parent | |StructureMigrationCodeUnit.From.Field.Parent | ||
| | |Name of the column in the database containing the DataID of the parent task | ||
|- | |- | ||
|StructureMigrationCodeUnit.From.Field.Progress | |StructureMigrationCodeUnit.From.Field.Progress | ||
| | |Name of the column in the database containing the percentage progress of the task | ||
|- | |- | ||
|StructureMigrationCodeUnit.From.Field.Serial | |StructureMigrationCodeUnit.From.Field.Serial | ||
| | |Name of the column in the database containing the unique "code" of the task | ||
|- | |- | ||
|StructureMigrationCodeUnit.From.Field.StartDate | |StructureMigrationCodeUnit.From.Field.StartDate | ||
| | |Name of the column in the database containing the startdate of the task | ||
|- | |- | ||
|StructureMigrationCodeUnit.From.Field.Title | |StructureMigrationCodeUnit.From.Field.Title | ||
| | |Name of the column in the database containing the title of the task | ||
|- | |- | ||
|StructureMigrationCodeUnit.To.Field.EndDate | |StructureMigrationCodeUnit.To.Field.EndDate | ||
| | |Name of the column in the database where the end will be stored | ||
|- | |- | ||
|StructureMigrationCodeUnit.To.Field.Parent | |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 | |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 | |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 | |StructureMigrationCodeUnit.To.Field.StartDate | ||
| | |Name of the column in the database where the startdate of the task will be stored | ||
|- | |- | ||
|StructureMigrationCodeUnit.To.Field.Title | |StructureMigrationCodeUnit.To.Field.Title | ||
| | |Name of the column in the database where the title of the task will be stored | ||
|- | |- | ||
|StructureMigrationCodeUnit.To.Table | |StructureMigrationCodeUnit.To.Table | ||
| | |Name of the table in the database where all the tasks will be stored | ||
|- | |- | ||
|StructureMigrationCodeUnit.Value.Parent | |StructureMigrationCodeUnit.Value.Parent | ||
| | |Static value. Use this to staticly set a DataID as parent task for all tasks synced | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.From.StatusID.Active | ||
| | |StatusID from source entity that should be converted to To.StatusID.Active | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.From.StatusID.Waiting | ||
| | |StatusID from source entity that should be converted to To.StatusID.Waiting | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.From.StatusID.Suspended | ||
| | |StatusID from source entity that should be converted to To.StatusID.Suspended | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.From.StatusID.Completed | ||
| | |StatusID from source entity that should be converted to To.StatusID.Completed | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.From.StatusID.Failed | ||
| | |StatusID from source entity that should be converted to To.StatusID.Failed | ||
|- | |- | ||
|StructureMigrationCodeUnit.To.StatusID. | |StructureMigrationCodeUnit.To.StatusID.Unknown | ||
| | |StatusID from the target entity. Given to tasks that have a status, that isn't defined in the config | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.To.StatusID.Active | ||
| | |StatusID from target entity that matches From.StatusID.Active | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.To.StatusID.Waiting | ||
| | |StatusID from target entity that matches From.StatusID.Waiting | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.To.StatusID.Suspended | ||
| | |StatusID from target entity that matches From.StatusID.Suspended | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.To.StatusID.Completed | ||
| | |StatusID from target entity that matches From.StatusID.Completed | ||
|- | |- | ||
|StructureMigrationCodeUnit. | |StructureMigrationCodeUnit.To.StatusID.Failed | ||
| | |StatusID from target entity that matches From.StatusID.Failed | ||
|- | |- | ||
Revision as of 13:51, 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
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 |
| 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 |