The Activity Import External Schedule import creates or updates P6 Activities to EcoSys as Tasks with a Task Type of "P6 Activity".
The external Activity import also integrates with the EcoSys Scheduling module. This allows the EcoSys user to view P6 Activities within the EcoSys Gantt chart view. This is accomplished by setting the "external" date fields on the Activity Task. The EcoSys Scheduling module provides a read-only view of the Activities.
The P6 Primary Constraints are also imported along with the Activities. P6 Constraints don’t have a direct mapping to EcoSys Constraints, so the following mapping has been implemented:
P6 Constraint Type |
EcoSys Constraint Area |
---|---|
Start on |
Start No Earlier Than |
Start On or Before |
Start No Later Than |
Start On or After |
Start No Earlier Than |
Finish On |
Finish No Later Than |
Finish On or Before |
Finish No Later Than |
Finish On or After |
Finish No Earlier Than |
As Late As Possible |
N/A |
Mandatory Start |
Start No Earlier Than |
Mandatory Finish |
Finish No Later Than |
If the EcoSys Scheduling module is not being used, it is recommended to swap this job for the "P6 Activity Import" for slightly better performance since there are some additional steps required for compatibility with EcoSys Scheduling.
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 Ext Sched Import
-
EcoSys Action: ITG P6 Activity to Task Ext Sched 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 |
Duration |
Schedule Constraint |
Planned Duration |
Duration Units |
Schedule Constraint |
Set to the Connect Setting "Scheduler.Units" |
P6 Remaining Duration |
Custom Field (Number) |
Remaining Duration |
P6 Remaining Units |
Custom Field (Number) |
Remaining Total Units |
P6 Constraint Type |
Task Category |
Primary Constraint Type |
P6 Constraint Date String |
Custom Field (Text) |
Primary Constraint Date |
External Start Date |
External Schedule |
Start Date |
External Finish Date |
External Schedule |
Finish Date |
External Early Start Date |
External Schedule |
Remaining Early Start Date |
External Early Finish Date |
External Schedule |
Remaining Early Finish Date |
External Late Start Date |
External Schedule |
Remaining Late Start Date |
External Late Finish Date |
External Schedule |
Remaining Late Finish Date |
External Free Float |
External Schedule |
Free Float |
External Total Float |
External Schedule |
Total Float |
Data Date |
External Schedule |
Project Date Date |