Data mapping: export data from PCS to Microsoft Project
To work on PCS projects in Microsoft Project, use the Export / Import PCS Activities via XML (tipcs4172m000) session to transfer data related to the PCS projects in LN to Microsoft Project . The table shows how data in LN matches the data in Microsoft Project.
If no matching field exists, automatically a custom field is inserted in Microsoft Project.
To display custom fields in the Microsoft Project grid, do the following:
- Right-click on the column header.
- Select insert column.
- In the column definition screen, select field name text3, text4, text5, text6 or text7.
To modify GLOBAL.MPT, so that custom fields are displayed in the grid by default:
- Copy GLOBAL.MPT, which is located in C:\Documents and Settings\<user>\Application Data\Microsoft Data\Microsoft\MS Project\11\1033\.
- Perform the steps described above to display customs fields, and save the template file.
- Replace the GLOBAL.MPT file by your modified copy.
You can always recover the original GLOBAL.MPT file:
- Delete the modified MPT file.
- Create a Microsoft Project file. A new GLOBAL.MPT file is copied from the globally installed template located in C:\Program Files\Microsoft Office\OFFICE11\1033\.
| LN | Microsoft Project | Remarks |
|---|---|---|
| PCS Project | Summary Task | -- |
| Project | Task Name | -- |
| Description | LN Task Description (custom field) | -- |
| The PCS start dates and end dates are not exported. Microsoft Project determines the project's start date and end date during loading the XML file into Microsoft Project, based on the dates of the individual tasks. |
|
A Microsoft Project file consists of only one project. This project can contain all activities of multiple LN PCS projects. |
PCS Planning Method
|
ScheduleFromStart
|
-- |
Project (selection range)
|
|
A Microsoft Project file consists of only one project. This project can contain all activities of multiple LN PCS projects. |
Fixed values:
|
-- | |
| Activity | Task | -- |
| Activity | Task Name: <project code> - <activity code> | -- |
| Description | LN Activity Description (custom field) | -- |
| Task | LN Task (custom field) | -- |
| Description | LN Task Description (custom field) | -- |
| Activity Manager | LN Activity Manager (custom field) | -- |
| Work Center | LN Work Center (custom field) | Refer also to Resource |
|
Calendar that is valid for the activity's work center:
|
Calendar
|
Microsoft Project only uses the task calendar. The work center calendar is not used. |
| --- | Task Type: Fixed Work | -- |
|
|
-- |
| Activity Duration | Duration |
The duration in LN is the number of working hours between the Desired Start Date and the Desired End Date. Dependent on the routing parameter, the calendar of the activity's work center or the company calendar is used to calculate the number of hours. Refer also to Desired Start Date and Desired End Date. Microsoft Project uses Start Date, Duration, and the imported Calendar definition to calculate the task's Finish Date. |
| Preceding Activity (as defined in Activity Relationships (tipcs4110m000)) | Predecessor |
The float time in days is multiplied by the work center's basic
capacity to convert the time to hours (working time). In Microsoft Project, the float time is imported in hours, but the time is displayed in days (working time). The calendar of the current task ( Next Activity in Activity Relationships (tipcs4110m000)) is used to offset the time. |
| Calendar | Calendar | -- |
All
calendars used for the network planning are exported to Microsoft Project
|
Calendar
|
-- |
| Work Center | Resource | -- |
| Work Center (used on the activity) |
Resource
|
-- |
| Code | Name | -- |
| Calendar | Calendar | -- |