P6 Activity to Task Ext Sched Import - EcoSys - 2.0 - Help - Hexagon

EcoSys P6 Connector Help

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
2.0

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