How Core Fields are populated on Upload from Microsoft Project

Modified on Fri, 5 Jun at 3:35 PM

TABLE OF CONTENTS


Microsoft Project is upload-only – it has no import (download) operation. It has no Profile concept, and every resource assignment is treated as staff time. The host fields are Aspose.Tasks property keys: Prj = project, Tsk = task, Rsc = resource, Asn = assignment.


Schedule Core Fields

Core field nameApi response fieldFormulaData typeDescription
DescriptionPrj.NameSame value as Code (MS Project has no separate description)TextThe schedule's name – the MS Project project name.
CompletedDatePrj.FinishDate
DateThe date the schedule finishes – the MS Project project finish date.
StartedDatePrj.StartDate
DateThe date the schedule starts – the MS Project project start date.
CutoffDatePrj.StatusDate
DateThe data / status date – the MS Project project status date used to report progress.
CodePrj.Name
TextThe schedule's unique identifier – the MS Project project name.


Resource Core Fields

Core field nameApi response fieldFormulaData typeDescription
DescriptionRsc.Name
TextThe resource's name – the MS Project resource name.
CodeRsc.Initials
TextThe resource's unique identifier – the MS Project resource initials.


Activity Core Fields

Core field nameApi response fieldFormulaData typeDescription
ActivityTypeTsk.IsMilestoneA milestone task becomes MilestoneStart; other tasks are RegularActivity; the milestone with the latest early finish becomes MilestoneFinishEnumThe kind of activity, derived from the MS Project milestone flag. Possible values: RegularActivity, MilestoneStart, MilestoneFinish, Hammock.
DescriptionTsk.Name
TextThe activity's name – the MS Project task name.
FinishNoLaterThanTsk.ConstraintType
Tsk.ConstraintDate
ConstraintDate when the constraint type is Finish No Later ThanDateConstraint date: the activity must finish on or before this date.
MustFinishOnTsk.ConstraintType
Tsk.ConstraintDate
ConstraintDate when the constraint type is Must Finish OnDateConstraint date: the activity must finish exactly on this date.
MustStartOnTsk.ConstraintType
Tsk.ConstraintDate
ConstraintDate when the constraint type is Must Start OnDateConstraint date: the activity must start exactly on this date.
StartAsEarlyAsPossibleTsk.ConstraintTypeTrue when the constraint type is As Soon As Possible (or none is recognised)BooleanConstraint: the activity should start as early as the schedule allows.
StartAsLateAsPossibleTsk.ConstraintTypeTrue when the constraint type is As Late As PossibleBooleanConstraint: the activity should start as late as the schedule allows.
StartNoEarlierThanTsk.ConstraintType
Tsk.ConstraintDate
ConstraintDate when the constraint type is Start No Earlier ThanDateConstraint date: the activity must start on or after this date.
StartNoLaterThanTsk.ConstraintType
Tsk.ConstraintDate
ConstraintDate when the constraint type is Start No Later ThanDateConstraint date: the activity must start on or before this date.
ActualStartTsk.ActualStartEmpty when the task has no actual startDateThe date the activity actually started – the MS Project task actual start.
ActualFinishTsk.ActualFinishEmpty when the task has no actual finishDateThe date the activity actually finished – the MS Project task actual finish.
CurrentProgressTsk.PercentWorkComplete
NumberThe activity's progress – the MS Project % Work Complete (percentage of work completed).
EarlyStartTsk.EarlyStart
DateThe earliest the activity can start – the MS Project task early start (earliest a task could begin given predecessors and constraints).
EarlyFinishTsk.EarlyFinish
DateThe earliest the activity can finish – the MS Project task early finish.
LateFinishTsk.LateFinish
DateThe latest the activity can finish without delaying the project – the MS Project task late finish.
LateStartTsk.LateStart
DateThe latest the activity can start without delaying the project – the MS Project task late start.
FreeFloatHoursTsk.FreeSlackTimeSpanFree slack converted to hoursNumberHours the activity can slip without delaying any successor – the MS Project task free slack.
TotalFloatHoursTsk.TotalSlackTimeSpanTotal slack converted to hoursNumberHours the activity can slip without delaying the project finish – the MS Project task total slack.
PlannedWorkHoursTsk.WorkAlready in hoursNumberThe planned work hours – the total work scheduled on the MS Project task for all assigned resources.
RemainingWorkHoursTsk.RemainingWorkAlready in hoursNumberThe work hours still remaining – the MS Project task remaining work.
IsCancelledTsk.IsActiveTrue when the task is inactive (NOT IsActive)BooleanWhether the activity has been cancelled – true when the MS Project task is inactive.
CancelledDate(derived)Today's date when IsCancelled is true; otherwise emptyDateThe date the activity was cancelled – set to today's date when cancelled (MS Project has no cancellation date).
PlannedProgressTsk.PercentComplete
NumberThe planned progress – the MS Project % Complete (percentage of the task's duration completed).
DurationHoursTsk.DurationConverted to hoursNumberThe activity's duration in hours – the MS Project task duration (active working time).
RemainingDurationHoursTsk.RemainingDurationConverted to hoursNumberThe activity's remaining duration in hours – the MS Project task remaining duration.
FinishOnOrAfterTsk.ConstraintType
Tsk.ConstraintDate
ConstraintDate when the constraint type is Finish No Earlier ThanDateConstraint date: the activity must finish on or after this date.
CalendarTsk.Calendar
(fallback Prj.Calendar)
The task calendar matched to an exported calendar; the project default is used when the task has noneReferenceThe calendar that governs the activity's working time – the task calendar, or the project default.
CodeTsk.UidPadded to 6 characters with leading zerosTextThe activity's unique identifier – the MS Project task UID (a unique id that does not change when tasks are reordered).


Resource Assignment Core Fields

Core field nameApi response fieldFormulaData typeDescription
PlannedHoursAsn.WorkConverted to hoursNumberPlanned work hours assigned to the resource – the MS Project assignment work.
ActualHoursAsn.ActualWorkConverted to hoursNumberActual work hours the resource has spent – the MS Project assignment actual work.
CurrentProgressAsn.PercentWorkComplete
NumberThe assignment's progress – the MS Project assignment % work complete.
ResourceUsageType(constant)Set to StaffTimeEnumThe kind of resource usage – fixed to StaffTime for MS Project. Possible values: Equipment, StaffTime, Material.
ResourceAsn.ResourceMatched to the exported resourceReferenceThe resource assigned to the activity.
EarlyStartAsn.Start
DateThe early start of the assignment – the MS Project assignment scheduled start.
EarlyFinishAsn.Finish
DateThe early finish of the assignment – the MS Project assignment scheduled finish.
LagHoursAsn.DelayConverted to hoursNumberThe lag, in hours – the MS Project assignment delay.
CodeAsn.Uid
TextThe assignment's unique identifier – the MS Project assignment UID.


Successor Core Fields

Core field nameApi response fieldFormulaData typeDescription
TypeTaskLink.LinkTypeMap: StartToStart, StartToFinish, FinishToStart, FinishToFinishEnumThe dependency relationship type, mapped from the MS Project task link type. Possible values: StartToStart, StartToFinish, FinishToStart, FinishToFinish.
LagHoursTaskLink.LinkLagLinkLag / 600 (Aspose stores lag in tenths of a minute)NumberThe lag, in hours – the MS Project task link lag.
Calendar(successor activity's calendar)Inherits the successor activity's calendarReferenceThe calendar used to interpret the lag.
SuccessorObjectTaskLink.SuccTaskThe successor activity (the link target)ReferenceThe successor activity (the link target).
Code(predecessor + successor)predecessor activity Code + "|" + successor activity CodeTextThe link's unique identifier – the predecessor and successor activity codes joined with a pipe.


Structure Core Fields (Outline Code)

Core field nameApi response fieldFormulaData typeDescription
TypeOutlineCode.FieldIdFlatList for a text-type field; otherwise HierarchicalListEnumThe kind of structure, from the MS Project outline-code field. Possible values: Wbs, FlatList, HierarchicalList.
DescriptionOutlineCode.FieldNameDescription = "{field type} Structure for field {FieldName}"TextThe structure's name – built from the MS Project outline-code field name.
CodePrj.Uid
OutlineCode.FieldId
Code = "{project Uid}|{FieldId}"TextThe structure's unique identifier – the project UID joined with the field id.


Structure Core Fields (WBS)

Core field nameApi response fieldFormulaData typeDescription
Type(constant)Set to WbsEnumThe kind of structure – the task work-breakdown hierarchy. Possible values: Wbs, FlatList, HierarchicalList.
Description(constant)Description = "Wbs"TextThe structure's name – "Wbs".
CodePrj.UidCode = "{project Uid}-WBS"TextThe structure's unique identifier – the project UID with a -WBS suffix.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article