Resource Assignments - EcoSys - Help - Hexagon PPM

EcoSys Primavera P6 Adapter Help

PPMProduct
EcoSys
PPMCategory_custom
Help
Version_EcoSys
8.7
  • Create field maps for importing P6 project field values. The syntax is:

    import.actual.assignment.ProjectUDFMap.Count=[Total fields]
    import.actual.assignment.ProjectUDFMap.[#]=[API Project Field Name]|[FM UDF Type Name]
    import.forecast.assignment.ProjectUDFMap.Count=[Total fields]
    import.forecast.assignment.ProjectUDFMap.[#]=[API Project Field Name]|[FM UDF Type Name]

Make sure the Count matches number of field maps.

Example: (for forecast and actuals)

import.actual.assignment.ProjectUDFMap.Count=4
import.actual.assignment.ProjectUDFMap.1=ObjectId|PROJECT_ID
import.actual.assignment.ProjectUDFMap.2=Id|PROJ_SHORT_NAME
import.actual.assignment.ProjectUDFMap.3=Name|PROJ_NAME
import.actual.assignment.ProjectUDFMap.4=Status|PROJ_STATUS_CODE

 

import.forecast.assignment.ProjectUDFMap.Count=4
import.forecast.assignment.ProjectUDFMap.1=ObjectId|PROJECT_ID
import.forecast.assignment.ProjectUDFMap.2=Id|PROJ_SHORT_NAME
import.forecast.assignment.ProjectUDFMap.3=Name|PROJ_NAME
import.forecast.assignment.ProjectUDFMap.4=Status|PROJ_STATUS_CODE

  • Create field maps for importing P6 WBS field values. The syntax is:

    import.actual.assignment.WBSUDFMap.Count=[Total fields]
    import.actual.assignment.WBSUDFMap.[#]=[API WBS Field Name]|[FM UDF Type Name]
    import.forecast.assignment.WBSUDFMap.Count=[Total fields]
    import.forecast.assignment.WBSUDFMap.[#]=[API WBS Field Name]|[FM UDF Type Name]

Make sure the Count matches number of field maps.

Example: (for forecast and actuals)

import.actual.assignment.WBSUDFMap.Count=2
import.actual.assignment.WBSUDFMap.1=Status|STATUS_CODE
import.actual.assignment.WBSUDFMap.2=WBSCategoryObjectId|PHASE_ID

 

import.forecast.assignment.WBSUDFMap.Count=2
import.forecast.assignment.WBSUDFMap.1=Status|STATUS_CODE
import.forecast.assignment.WBSUDFMap.2=WBSCategoryObjectId|PHASE_ID

  • Create field maps for importing P6 Activity field values. The syntax is:

    import.actual.assignment.ActivityUDFMap.Count=[Total fields]
    import.actual.assignment.ActivityUDFMap.[#]=[API Activity Field Name]|[FM UDF Type Name]
    import.forecast.assignment.ActivityUDFMap.Count=[Total fields]
    import.forecast.assignment.ActivityUDFMap.[#]=[API Activity Field Name]|[FM UDF Type Name]

    Make sure the Count matches number of field maps.

Example: (for forecast and actuals)

import.actual.assignment.ActivityUDFMap.Count=8
import.actual.assignment.ActivityUDFMap.1=ObjectId|TASK_ID
import.actual.assignment.ActivityUDFMap.2=Id|TASK_CODE
import.actual.assignment.ActivityUDFMap.3=Name|TASK_NAME
import.actual.assignment.ActivityUDFMap.4=PlannedStartDate|TARGET_START_DATE
import.actual.assignment.ActivityUDFMap.5=PlannedFinishDate|TARGET_END_DATE
import.actual.assignment.ActivityUDFMap.6=WBSObjectId|WBS_ID
import.actual.assignment.ActivityUDFMap.7=WBSCode|WBS_SHORT_NAME
import.actual.assignment.ActivityUDFMap.8=WBSName|WBS_NAME

 

import.forecast.assignment.ActivityUDFMap.Count=8
import.forecast.assignment.ActivityUDFMap.1=ObjectId|TASK_ID
import.forecast.assignment.ActivityUDFMap.2=Id|TASK_CODE
import.forecast.assignment.ActivityUDFMap.3=Name|TASK_NAME
import.forecast.assignment.ActivityUDFMap.4=PlannedStartDate|TARGET_START_DATE
import.forecast.assignment.ActivityUDFMap.5=PlannedFinishDate|TARGET_END_DATE
import.forecast.assignment.ActivityUDFMap.6=WBSObjectId|WBS_ID
import.forecast.assignment.ActivityUDFMap.7=WBSCode|WBS_SHORT_NAME
import.forecast.assignment.ActivityUDFMap.8=WBSName|WBS_NAME

  • Create field maps for importing P6 Resource Assignment field values. The syntax is:

    import.actual.assignment.UDFMap.Count=[Total fields]
    import.actual.assignment.UDFMap.[#]=[API Assignment Field Name]|[FM UDF Type Name]
    import.forecast.assignment.UDFMap.Count=[Total fields]
    import.forecast.assignment.UDFMap.[#]=[API Assignment Field Name]|[FM UDF Type Name]

Make sure the Count matches number of field maps.

Example: (for forecast and actuals)

import.actual.assignment.UDFMap.Count=7
import.actual.assignment.UDFMap.1=ObjectId|TASKRSRC_ID
import.actual.assignment.UDFMap.2=ResourceObjectId|RSRC_ID
import.actual.assignment.UDFMap.3=PlannedStartDate|EST_START_DATE
import.actual.assignment.UDFMap.4=PlannedFinishDate|EST_END_DATE
import.actual.assignment.UDFMap.5=ActualStartDate|ACT_START_DATE
import.actual.assignment.UDFMap.6=ActualFinishDate|ACT_END_DATE
import.actual.assignment.UDFMap.7=PlannedCost|BUDGET_AMT

 

import.forecast.assignment.UDFMap.Count=7
import.forecast.assignment.UDFMap.1=ObjectId|TASKRSRC_ID
import.forecast.assignment.UDFMap.2=ResourceObjectId|RSRC_ID
import.forecast.assignment.UDFMap.3=PlannedStartDate|EST_START_DATE
import.forecast.assignment.UDFMap.4=PlannedFinishDate|EST_END_DATE
import.forecast.assignment.UDFMap.5=ActualStartDate|ACT_START_DATE
import.forecast.assignment.UDFMap.6=ActualFinishDate|ACT_END_DATE
import.forecast.assignment.UDFMap.7=PlannedCost|BUDGET_AMT