Integration to Primavera Project Management

The integration to Primavera Project Management enables the possibility of exchanging information between IFS Applications and the Primavera Project Management module. The integration can go in both directions, that is either an IFS project can be exported to Primavera or a Primavera project can be imported to an IFS project. All information necessary for planning purposes is handled by the integration such as project information, the sub project structure, activities, resources, calendar, dependencies and constraints. In addition, for each export or import, it can be configured if certain data types should be transferred.

The following is a description of the exact fields and data types that are integrated between IFS Applications and Primavera. This document is divided into two sections: Export and Import, each section is then divided into basic data integration and project data integration.

The Project Management module of Primavera is required, consisting of a database and server installation as well as client installations. In addition, the integration API from Primavera is required. The Primavera user IDs that will be used in the integration must have licensing access to the integration API as well as to the Project Management module.

To facilitate the work process, IFS Applications offers a solution that gives you feed-back regarding the integration through integration messages. Read more about running the integration and integration messages in the document: Integration to Primavera Project Management - Integration Messages.

The Project Management module of Primavera is referred to as Primavera and IFS Applications is referred to as IFS in this document.
 


Export

Basic Data Integration

Basic data for the calendar and resources are exported from the Integration Configuration/Basic Data Integration tab. This data must exist in Primavera before it can be assigned to a Primavera project though a project integration.

Calendar Fields

It is possible to export single calendars as well as all resource calendars assigned to the resources in a defined resource company. Calendar information is required to be defined in the Integration Setup/Integration Calendar Setup tab.

If there is a value in the Calendar field in the integration configuration for an export, that calendar will be created or updated in Primavera. If the Resource Calendar check box is selected in the integration configuration (if there is a value in Resources Company field), then the related resource calendars will be created or updated in Primavera. The following fields are created or updated in Primavera when Calendars are exported:

IFS Field Primavera Field Comments
Calendar ID Calendar Name Calendars are created as global calendars in Primavera.
Base Schedule Workweek IFS calendars can have several schedules which are valid for different periods. The value for Base Schedule in the Calendar Setup tab updates the Primavera calendar workweek.
Schedule Exceptions   The IFS schedule exceptions data is applied to the Primavera calendar.
Secondary Schedules   If there are schedules in addition to the schedule in the Base Schedule field, this data is applied to the Primavera calendar for the period defined by the dates in the Calendar Setup tab.



Resource Fields:

In Primavera, resources are organized in a resource structure that is common for all projects. When exporting, the resources are placed in the Primavera resource structure under a top resource node that corresponds to the IFS resource company. This top resource node is automatically created the first time resources belonging to that company are exported. The node can also be created manually in the Primavera resource structure. When resources are assigned to a project, the resources must be located under the top resource node corresponding to the IFS project company. The integration cannot handle resources that are not located under this company resource node.

If there is a value in Resource Company in the integration configuration for an export, all resources corresponding to that IFS resource company are exported. If Resource Calendar check box is selected, the resource calendars for the resource company are created or updated and assigned to the resources in Primavera. The following fields are created or updated in Primavera.

Notes:

IFS Field Primavera Field Comments
Resource ID Resource ID If it does not already exist, a node for the project company is created at the highest level in the Primavera resource structure. Then when a new resource is created, it is placed under this company node in the Primavera resource structure.

Note: The Resource ID must be unique within the entire Primavera resource structure.
Resource Description Resource Name  
  Resource Type New resources created through an export receive the value Labor by default. An update of an existing resource does not update this field.
Effective From
Effective To of Resource Detail/ Cost/ General		 Effective Date When exporting the periods for IFS cost to Primavera, the following is considered:
  • In IFS, periods are defined with both a start and finish date.
  • In Primavera, a period is only defined by its start date, and cost is specified for such a period.
Resource Detail/ Cost/ General Price/Unit In IFS, the cost is always per hour. When exporting, the value in the Price/Unit will be per hour (/h).

Notes:
  • It is not possible to set the currency per project in Primavera. Therefore the currency shown in the Primavera project may not at all correspond to the currency of the IFS project. The value is exported at face value without considering currency.
  • Resource cost will be sent to Primavera only if the cost is defined without specifying a site.
    •
(Resource) Calendar ID Calendar in Resource Details/Details The Primavera resources are updated with the IFS Resource Calendar IDs only if the Resource Calendar  check box is selected in the integration configuration for an export.



Activity Classes Fields:

Global activity classes in IFS and its values are exported to activity codes and its values in Primavera.

IFS Field Primavera Field Comments
Activity Class Activity Code Global activity classes are exported.
Value Code Value  
Value Description Description  




Project Integration

Project data is exported from the Integration Configuration/Projects Integration tab.

Some information in IFS/Project which can also be useful information in Primavera, is exported to user defined fields (UDF) in Primavera. Note that these fields are not shown in the Compare Data dialog box since they are for additional information only. An example of an user defined field is IFS Activity Seq.


Project Fields:

IFS Field Primavera Field Comments
External Planning Tool Project ID

(As entered in the Integration Configuration tab)		 Project ID

(Or shown as WBS Code if viewing in the WBS window.)		 If the value does not exist in Primavera, a new project is created.
  • It is placed under the EPS ID corresponding to the Program ID. 
  • If the IFS project has no value for program, the new Primavera project is placed under the EPS ID corresponding to the Company.
If the value already exists in Primavera, this project is updated by the export.
  • The project information is updated without updating the EPS (Program ID and Company) information.
Project ID IFS Project ID This is a user defined field, grouped in the Projects subject area in Primavera.
Project Name Project Name or WBS Name  
Project Description IFS Project Description This is a user defined field, grouped in the Projects subject area in Primavera. The text may need to be truncated.
Program ID EPS ID This field is not updated when updating an existing project in Primavera.

If creating a new Primavera project, and if the IFS project has a value for Program ID, there is a check if the corresponding EPS ID already exists. In Primavera, the EPS ID must be unique.
  • If the EPS ID already exists, the project is placed under this node.
  • If the EPS ID does not exist, a new EPS ID is created and placed under the EPS node corresponding to Company, and the project is placed under this node. Note that the export creates an EPS node for Company if it does not already exist. (The new EPS ID will have * as the Responsible Manager.)
Program Description EPS Name  
Company EPS ID This field is not updated when updating an existing project in Primavera.

If creating a new Primavera project, and if the IFS project does not have a value for Program ID, there is a check if an EPS ID corresponding to the Company identity already exists. In Primavera the EPS ID must be unique.
  • If the EPS ID already exists, the project is placed under this node.
  • If the EPS ID does not exist, a new EPS ID is created at the top level, and the project is placed under this node. (The new EPS ID will have * as the Responsible Manager.)
If creating a new Primavera project, new EPS IDs may be created for both Program ID field and Company field if neither exists. See the comments for the Program ID field above.
Company Name EPS Name  
Manager OBS Name


Responsible Manager		 If the Manager check box is selected in the integration configuration for an export, this field is updated in Primavera.

If the OBS Name does not already exist in Primavera, it is added into the OBS structure.

This OBS Name is connected to the Primavera project as the responsible manager.

Note: Change of Project Manager in IFS will update the Responsible Manager for all WBS elements in Primavera.
(Project) Status (Project) Status The value in this field will be set as follows:
IFS Primavera
Initialized   Planned
Approved Active
Started Active
Completed Inactive
Closed Inactive
Cancelled Inactive
Earliest ES or Project Planned Start or System Date Project Planned Start
  • If the IFS project has a Planned Start date, then this date updates the Primavera Project Planned Start.
     
  • If the IFS project has no Planned Start date:
    - If the IFS Project contains any activities, the earliest ES updates the Primavera Project Planned Start.
    - If the IFS project does not have any activities, the system date updates the Primavera Project Planned Start.
Project Calendar Calendar in Project Details/Defaults tab If the Project Calendar check box is selected in the integration configuration for an export, then the Primavera project is updated with the IFS Calendar ID given that the calendar exists as a global calendar in Primavera.

When exporting:
  • The calendar will be assigned to the project.
  • The project calendar in existing projects will be updated (see information on activity calendar).
If the Project Calendar check box is not selected, or if the calendar does not exists as a global calendar in Primavera, then the Primavera default calendar will be assigned to the project.

Note: To get consistent results for activity dates and durations. its recommended to use the same calendar(and work hours/day) in IFS and Primavera.
  Activity Calendar in Activity/General tab If the Project Calendar check box is selected in the integration configuration for an export and an existing Primavera project is updated, the project calendar is updated but the activity calendars for existing activities are not updated.

 

Sub Project Fields:

IFS Field Primavera Field Comments
Sub Project ID WBS Code Note: IFS requires that the Sub Project ID is unique for the project, thus it is not possible to either import from or export to Primavera if there are non unique WBS codes in the Primavera project.
Sub Project Description WBS Name Note: Primavera requires that all the WBS elements under one parent WBS element have unique WBS Names.
Parent Sub Project (or Project) ID Parent WBS Code

 
Sub Project Manager OBS Name


Responsible Manager		 If the Manager check box is selected in the integration configuration for an export, this field is updated in Primavera.
 

If the OBS Name does not already exist in Primavera, it is added into the OBS structure.

This OBS Name is connected to the Primavera sub project as the responsible manager.

 

Activity Fields:

IFS Field Primavera Field Comments
Activity Sequence IFS Activity Seq. This is a user defined field, grouped in the Activities subject area in Primavera.

This field is the main identifier to associate a Primavera activity to an IFS activity.
Activity ID Activity ID If the activity ID is unique for the project, the IFS activity ID simply updates the Primavera field.

Note: In Primavera the activity ID must be unique for the whole Project whereas in IFS the activity ID need only be unique for the specific sub project that the activity belongs.
Activity Description Activity Name

 
Early Start Start

 
Early Finish Finish

 
Activity Milestone

The activity is a milestone when this check box is selected.		 Activity Type When creating new activities in Primavera:
 
  • If the IFS activity is not an activity milestone, the default value for this field is Task Dependent.
  • If the IFS activity is an activity milestone:
    • -  If there is no constraint imposed in IFS, the value for this field is Start Milestone.
    -  If there is a Start not earlier than constraint imposed on the IFS activity, the value for this field is Start Milestone.
    -  If there is an End not later than constraint imposed on the IFS activity, the value for this field is Finish Milestone.

 

When updating existing activities in Primavera:
 

  • If the IFS activity is an activity milestone:
    • -  If the Primavera activity type is a Start Milestone, and the End not later than constraint is imposed on the IFS activity, then the value for this field is Finish Milestone.
    -  If the Primavera activity type is a Finish Milestone, and the Start not earlier than constraint is imposed on the IFS activity, then the value for this field Start Milestone.
    -  If the Primavera activity type is a Start or a Finish Milestone and the constraint imposed is not Start on or after or Finish on or before, and the IFS activity has no constraint, then the constraint is not deleted in Primavera.
  • If the IFS activity is not an activity milestone:
    -     If the Primavera activity is not a Start or Finish Milestone, this field is not updated.
    -  If the Primavera activity is a milestone, this field is updated to Task Dependent.

Note: Primavera does not allow resources to be assigned to a milestone activity.

Primavera has a special network logic related to the milestone type, such as the allowed constraint type for that milestone type and the dependency types allowed for its dependencies. 

 

 Duration Type When creating new activities in Primavera, the default value for this field is Fixed Duration & Units.

When updating existing activities in Primavera, the value in this field is not updated.

 

 % Complete Type When creating new activities or updating activities in Primavera, the value for this field is Physical.
Calculated Progress Physical %

 
Actual Start Date Started check box and Actual Start Date If the IFS activity has a value in the Actual Start Date  field, then in Primavera:
  • The Started check box is selected.
  • The field beside this check box shows the actual start date.
Actual Finish Date Finished check box and Actual Finish Date If the IFS activity is a value in the Actual Finish Date   field, then in Primavera:
  • The Finished check box is selected.
  • The field beside this check box shows the actual finish date.
Activity Responsible ID IFS Activity Responsible This is a user defined field, grouped in the Activities subject area in Primavera.
Status IFS Activity Status This is a user defined field, grouped in the Activities subject area in Primavera.
Constraint Type Primary Constraint If the Constraints check box is selected in the integration configuration for an export, this field is updated in Primavera.

The IFS constraint Start not earlier than corresponds to the Primavera constraint Start on or after.

The IFS constraint End not later than corresponds to the Primavera constraint Finish on or before.

If the IFS activity has no constraint:
  • When a new activity is created in Primavera, this activity has no constraint.
  • When updating an existing activity in Primavera:
    - If the Primavera activity has the constraint Start on or after or Finish on or before, the Primavera field is updated.
    - If the Primavera activity has a constraint other than Start on or after or Finish on or before, the Primavera field is not updated.
     
If the IFS activity has a constraint:
  • If the IFS field has the value Start not earlier than, the Primavera field receives the value Start on or after
  • If the IFS field has the value End not later than, the Primavera field receives the value Finish on or before.
Constraint Date Primary Constraint Date If the Constraints check box is selected in the integration configuration for an export, this field is updated in Primavera.
Activity Class Activity Code If the Activity Classes check box is selected in the integration configuration for an export, this field is updated in Primavera.
Value Code Value If the Activity Classes check box is selected in the integration configuration for an export, this field is updated in Primavera.
Value Description Description If the Activity Classes check box is selected in the integration configuration for an export, this field is updated in Primavera.

 

Activity Dependencies Fields:

If the Dependencies check box is selected in the integration configuration for an export, the following fields are created or updated in Primavera. Changes in dependency type results in that the current dependency type is deleted and the new dependency type is inserted.

IFS Field Primavera Field Comments
Activity ID Activity ID  
Predecessor Activity ID Predecessor Activity ID  
Successor Activity ID Successor Activity ID  
Dependency Type Relationship Type

 
Lag Lag

 

 

Resource Assignment Fields:

If the Resource Assignments check box is selected in the integration configuration for an export, the following data is created or updated in Primavera. The resource basic data must exist in Primavera, for the resources to be assigned through the export.

IFS Field Primavera Field Comments
Activity ID Activity ID Note: Primavera does not allow resources to be assigned to a milestone activity.
Resource ID Resource ID  
Planned Hours or Baseline Hours
(as shown in the Project Info / Resource  tab		 Budgeted Units The Planned Hours value is exported if the Earned Value Method is Planned. The Baseline Hours value is exported if the Earned Value Method is Baseline.

The value exported is in the unit Hours.
Actual Hours for  Resource Actual Units The value exported is in the unit Hours.

 


Import

Basic Data Integration

Neither Resource basic data nor the Calendars can be imported from Primavera to IFS. Only the Global Activity Codes in Primavera are possible to import in to IFS Activity Classes.
 

Activity Classes Fields:

Global activity codes in Primavera and its values are imported to activity classes and its values in IFS.

IFS Field Primavera Field Comments
Activity Class Activity Code Global activity classes are imported.
Value Code Value  
Value Description Description  



Project Integration

Project data is imported from the Integration Configuration/Projects Integration tab.

Project Fields:

IFS Field Primavera Field Comments
Project Planned Start Project Planned Start  
Project Planned Finish Finish  

 

Sub Project Fields:

Note that it is not possible to delete sub projects in IFS through an import. The deleted sub project in Primavera is displayed in the Compare Data dialog box with the change type Delete for information, but it is not actually deleted when the integration is completed.

IFS Field Primavera Field Comments
Sub Project ID WBS Code If a WBS Code is changed in Primavera, then a new sub project is created when importing.

Note: IFS requires that the Sub Project ID is unique for the project, thus it is not possible to either import from or export to Primavera if there are non unique WBS codes in the Primavera project.
Sub Project Description WBS Name

 
Parent Sub Project (or Project) ID Parent WBS Code

 

 

Activity Fields:

Note that it is not possible to delete activities in IFS through an import. The deleted activity in Primavera is displayed in the Compare Data dialog box with the change type Delete for information, but it is not actually deleted when the integration is completed.

IFS Field Primavera Field Comments
Activity ID Activity ID If an activity ID is changed in Primavera, then a new activity is created when importing.
Activity Description Activity Name

 
Parent Sub Project ID WBS Code The sub project to which the activity belongs.
Early Start Start

 Note: If the IFS activity has an actual start date, the early start date will not be updated when importing.
Early Finish Finish

 Note: If the IFS activity has an actual finish date, the early finish date will not be updated when importing
Activity Milestone
 		 Activity Type If the Primavera activity is a Start or Finish Milestone, the Activity Milestone check box in IFS is selected.

If the Primavera activity has another Activity Type, the Activity Milestone check box in IFS is not selected.
Late Start Date Late Start  
Late Finish Date Late Finish  
Total Float Total Float

 
Free Float Free Float  
Constraint Type Primary Constraint If the Constraints check box is selected in the integration configuration for an import, this field is updated in IFS.

The IFS constraint Start not earlier than corresponds to the Primavera constraint Start on or after.

The IFS constraint End not later than corresponds to the Primavera constraint Finish on or before.
 
  • If the Primavera field has the value Start on or after, the IFS field receives the value Start not earlier than.
  • If the Primavera field has the value Finish on or before, the IFS field receives the value End not later than.
  • If the Primavera field has any other value or no value, the IFS field receives no value.
Constraint Date Primary Constraint Date If the Constraints check box is selected in the integration configuration for an import, this field is updated in IFS.
Baseline Project Start Date BL Project Start  
Baseline Project Finish Date BL Project Finish  
Baseline User Primary Start Date BL1 Start  
Baseline User Primary Finish Date BL1 Finish  
Primary Constraint Primary Constraint  
Secondary Constraint Secondary Constraint  
Activity Class Activity Code If the Activity Classes check box is selected in the integration configuration for an import, this field is updated in IFS.
Value Code Value If the Activity Classes check box is selected in the integration configuration for an import, this field is updated in IFS.
Value Description Description If the Activity Classes check box is selected in the integration configuration for an import, this field is updated in IFS.
Validity   If the Activity Classes check box is selected in the integration configuration for an import, this field is updated in IFS.



Activity Dependencies Fields:

If the Dependencies check box is selected in the integration configuration for an import, the following fields are created or updated in IFS.

If there is a dependency to an activity in another project, that will be shown on the Planning/Primavera tab independent of the Dependencies check box.

IFS Field Primavera Field Comments
Activity ID Activity ID  
Predecessor Activity ID Predecessor Activity ID  
Successor Activity ID Successor Activity ID  
Dependency Type Relationship Type  
Lag Lag

 

 

Resource Assignment Fields:

If the Resource Assignments check box is selected in the integration configuration for an import, the following data is created or updated in IFS. The resource basic data must exist on the receiving side of the integration, for the resources to be assigned though the integration.

IFS Field Primavera Field Comments
Activity ID Activity ID Note: IFS allows a Resource ID to be assigned only once to the same activity.
Resource ID Resource ID  
Planned Hours
(as shown in the Project Info /Resource tab)		 Planned Units When importing, the value is converted to the unit Hours, if another unit is used.