Data mapping: import data from Microsoft Project to PCS

If you work on Microsoft Project, use the Export / Import PCS Activities via XML (tipcs4172m000) session to transfer project data from Microsoft Project to Project Control in LN. The table shows how data in Microsoft Project matches the data in . Project Control. Only a limited number of fields in Project Control is updated.

Microsoft Project task field (in XML)LN activity field codeLN field name
EarlyStarttipcs400.esdtEarliest Start Date
LateStarttipcs400.lsdtLatest Start Date
EarlyFinishtipcs400.efdtEarliest End Date
LateFinishtipcs400.lfdtLatest End Date
Starttipcs400.dsdtDesired Start Date
Free Slacktipcs400.totfFree Float
Total Slacktipcs400.frefTotal Float
Finishtipcs400.dfdtDesired End Date
The following fields are only updated if the AutomaticUpdate check box in the Activity Overview by Project (tipcs4502m000) session is cleared:
PercentCompletetipcs400.pctcPercentage Completed
ActualStarttipcs400.asdtActual Start Date
ActualFinishtipcs400.afdtActual End Date

 

Note

The Free Float and Total Float fields are expressed in days, but the MS Project Slack fields are expressed in hours.

The conversion is based on the Work Center field and the Basic Day Capacity[Hours] field linked to the specified work center.

Related topics