| # 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 ERP Enterprise to Microsoft Project . The table shows how data in ERP Enterprise 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. Note 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\.
ERP Enterprise | Microsoft Project | Remarks
--- | --- | ---
PCS Project | Summary Task | --
Project | Task Name | --
Description | ERP Enterprise 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. | StartDate FinishDate | A Microsoft Project file consists of only one project. This project can contain all activities of multiple ERP Enterprise PCS projects.
PCS Planning Method Backward Forward | ScheduleFromStart False True | --
Project (selection range) Start Date of first project Completion Date of last project | StartDate FinishDate | A Microsoft Project file consists of only one project. This project can contain all activities of multiple ERP Enterprise PCS projects.
| Fixed values: DurationFormat: 5 (=hours) DefaultFixedCostAccrual: 3 (=end) Project ExternallyEdited: 0 (no) | --
Activity | Task | --
Activity | Task Name: <project code> - <activity code> | --
Description | ERP Enterprise Activity Description (custom field) | --
Task | ERP Enterprise Task (custom field) | --
Task | ERP Enterprise Task Description (custom field) | --
Activity Manager | ERP Enterprise Activity Manager (custom field) | --
Work Center | ERP Enterprise Work Center (custom field) | Refer also to Resource
Calendar that is valid for the activity's work center: Availability as defined in routing parameters Company calendar or work center calendar, dependent on Used Calendar Type in the routing parameters. | Calendar Value: <availability> . <calendar> IgnoreResourceCalendar: 1 (=yes) | Microsoft Project only uses the task calendar. The work center calendar is not used.
--- | Task Type: Fixed Work | --
Desired Start Date Desired End Date If these fields have no dates, other date fields are used: In case of forward planning: Earliest Start Date and Earliest End Date In case of backward planning: Latest Start Date and Latest End Date | Start Finish | --
Activity Duration | Duration | The duration in ERP Enterprise 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 Availability type as defined in the routing parameters Dependent on the routing parameter, the company calendar is exported, or a calendar for each work center. For each calendar the default availability type as defined in the routing parameters is exported. A maximum of three working time blocks per day is exported. | Calendar Value: <availability> . <calendar> Calendars are linked to tasks | --
Work Center | Resource | --
Work Center (used on the activity) | Resource For each task, a custom field 'ERP Enterprise Work Center' is available During XML import, resources are not formally linked to tasks | --
Code | Name | --
Calendar | Calendar | --
Related topics Integration between PCS and Microsoft Project Data mapping: import data from Microsoft Project to PCS |