The Activity Import creates or updates P6 Activities to EcoSys as Tasks with a Task Type of "P6 Activity".
The Activity import establishes the mapping by setting the EcoSys Task External Key field with the Activity Object Id.
-
Connect Job: P6 Activity to Task Import
-
EcoSys Action: ITG P6 Activity to Task Import
-
Dependencies: P6 Project and WBS Import
It is possible to filter which P6 Activities are imported by setting the EcoSys Connect Global Setting "P6Connector.ActivityImportFilter". For instance, to only import milestones, and so on.
This setting has the following requirements:
-
Requires a value
-
The filter value must be specified in the format accepted by the P6 API. For more information about this format, refer to the P6 web services API documentation.
-
By default, this setting is set to import all Activities, with the value of: Type like '%'
Project level mapping follows the logic described in the section Map an existing EcoSys Project to a P6 Project.
Field Mappings
The default behavior of the Activity import is to import the following P6 Activity fields. If desired, any available P6 Activity field could be imported by modifying the Connect Job.
EcoSys Field |
EcoSys Subject Area |
P6 Field |
---|---|---|
External Key |
Task |
Activity Object Id |
Owner Cost Object (External Key) |
Task |
WBS Object Id |
Task ID |
Task |
Activity Id |
Task Name |
Task |
Activity Name |
P6 Activity Type (ID) |
Task Category |
Activity Type |
P6 Activity Status (ID) |
Task Category |
Status |
P6 Actual Start Date |
Custom Field (Date) |
Actual Start Date |
P6 Actual End Date |
Custom Field (Date) |
Actual End Date |
P6 Baseline Start Date |
Custom Field (Date) |
Baseline Start Date |
P6 Baseline End Date |
Custom Field (Date) |
Baseline End Date |
P6 Remaining Start Date |
Custom Field (Date) |
Remaining Early Start Date |
P6 Remaining End Date |
Custom Field (Date) |
Remaining Early Finish Date |
P6 % Complete |
Custom Field (Percent) |
Percent Complete |
P6 Performance % Complete |
Custom Field (Percent) |
Performance Percent Complete |
P6 Earned Value Cost |
Custom Field (Money) |
Earned Value Cost |
P6 Budget At Completion Cost |
Custom Field (Money) |
Budget At Completion Cost |
P6 Actual Duration |
Custom Field (Number) |
Actual Duration |
P6 Baseline Duration |
Custom Field (Number) |
Baseline Duration |
P6 Planned Duration |
Custom Field (Number) |
Planned Duration |
P6 Planned Start Date |
Custom Field (Date) |
Planned Start Date |
P6 Planned End Date |
Custom Field (Date) |
Planned Finish Date |