Data Manager

The Data Manager is a powerful local data engine that sends requests to the server side, then binds the data to the GanttSheet when the data is ready. GanttSheet uses the DataManager view as a data source.

Data Source Schema

A data source schema refers to the data structure within a particular data source.

Data and Fields

GanttSheet requires the following fields from the data source as task fields.

Here is a sample data source.

[
  {
    "id": 1,
    "taskNumber": 1,
    "parentId": null,
    "name": "Plan for Project Server 2013 deployment",
    "duration": "1 day", 
    "start": "21/12/23 8:00",
    "finish": "21/12/23 17:00",
    "predecessors": ""  
},
{
    "id": 2,
    "taskNumber": 2,
    "parentId": null,
    "name": "Prepare for deployment",
    "duration": "4 days",
    "start": "21/12/24 8:00",
    "finish": "21/12/29 17:00",
    "predecessors": "1"
  },
]

Build Type

GanttSheet builds a task tree with three types of hierarchy, such as Parent, Level, and Children. However, you can also manually change the used build type if required.

To know more about different hierarchy types, see Add Hierarchy Types.

Duration Unit

The duration unit in GanttSheet is a calendar setting that defines specific parameters for calculating durations.

When the duration is provided as a string from a data source, GanttSheet automatically parses and normalizes the duration. For example, parse 6 days to the actual duration type { value: 1, unit "Day", time: 86400000 }.

GanttSheet supports the following duration units:

• Minute

• Hour

• Day

• Month

• Week

However, if the source duration data is a number or { value: 6 }, GanttSheet uses the project.calendarSettings.defaultDurationUnit as the default unit for parsing or editing duration.

To know more about calendar settings, see Calendar Settings.

Task Completion

GanttSheet displays the task progress as a percentage in the complete field. For this, the "complete" field must be included in the source data.

If you define the complete in the Gantt chart view's column settings, you can modify the complete value by dragging the progress bar inside the taskbar.

Note: Currently, the state of a summary task will not change even if the complete percentage of its subtask changes.

The code sample below defines the "complete" column for the Gantt chart view.

var view = myTable.addView("ganttView", [
    ...
    { value: "complete", caption: "Complete" },
    ...
]);

To know more about task status, see Task Operations.

Columns Schema

A GanttSheet needs valid data to schedule tasks. Therefore, the Gantt chart view provides multiple cell types for its columns and improves the editing experience of the task data.

Column Cell Types

Each cell type in the GanttSheet corresponds to a datatype defined in the column schema of the table configuration. These cell types allow you to manage and edit task-related data efficiently.

Here is a sample columns' schema.

schema: {
    columns: {
        ...
        mode: { dataType: "TaskSchedulingMode" },
        name: { dataType: "TaskSubject" },
        duration: { dataType: "TaskDuration" },
        start: { dataType: "TaskStartDate" },
        finish: { dataType: "TaskFinishDate" },
        predecessors: { dataType: "TaskPredecessor" }
        ...
    }
}

Note: If the field names in your source data match the predefined task field names in the GanttSheet, the relevant data types will be automatically aligned.