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 code | LN field name |
|---|---|---|
| EarlyStart | tipcs400.esdt | Earliest Start Date |
| LateStart | tipcs400.lsdt | Latest Start Date |
| EarlyFinish | tipcs400.efdt | Earliest End Date |
| LateFinish | tipcs400.lfdt | Latest End Date |
| Start | tipcs400.dsdt | Desired Start Date |
| Free Slack | tipcs400.totf | Free Float |
| Total Slack | tipcs400.fref | Total Float |
| Finish | tipcs400.dfdt | Desired End Date |
| The following fields are only updated if the Automatic Update check box in the Activity Overview by Project (tipcs4502m000) session is cleared: | ||
| PercentComplete | tipcs400.pctc | Percentage Completed |
| ActualStart | tipcs400.asdt | Actual Start Date |
| ActualFinish | tipcs400.afdt | Actual 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 field linked to the specified work center.