Update Schedule Sheet Activities V2 from Oracle Primavera P6 XML

Support for SOAP is deprecated starting with Unifier 23.10.

Description

This method will insert/update activities into any project/shell schedule sheet. It will not overwrite existing activities in the schedule sheet based on the data mapping parameter.

Support

This method can only support updating of activities in project/shell-level schedule sheets.

Installation: ASP and Self host

Level Yes or No
Company Level No
Project/Shell Level Yes

Prototype

public XMLObject updateScheduleActivitiesV2(String shortname, String authcode, String projectNumber, String sheetName, String sheetXML, String scheduleOptions);

Parameters

Parameter Description
shortname Identifier of the company, company's short name
authcode Authentication code for the company, in text string
projectNumber Identifier of a project/shell.
sheetname Name of Schedule Sheet to import activities into.
sheetXML Content of activities to import. This is obtained from the Primavera P5/P6 xml content. The Primavera XML content should be generated by exporting the full Primavera project.
scheduleOptions

This element will allow message to carry optional information. Following are the tags under this element:

<MapName/>

<ActivityIdentifier/>

<CBS_NoOfLevelsToMerge/>

<CBS_StartMergeFrom/>

<ActivityDeletion/>
MapName Name of the data mapping that should be used while processing XML file
ActivityIdentifier Possible values are GUID, ID. ID is the tag of Activity Id in Primavera.
CBS_NoOfLevelsToMerge

This parameter will take a numeric value. This parameter can be used by user to specify how many levels (CBS Levels) in P6 XML file should be merged.

  • EXAMPLE: Assume that P6 has following structure (5.ON.DA.DA03.F350.U11.095.ABC20.CAct04)

If you specify 3 then two levels will be merged. But which 3 segments will be based on the next parameter (CBS_startmergefrom)
CBS_StartMergeFrom
  • This parameter will take a numeric value. Value of this parameter will be used to determine the level from which this merge should start.
  • EXAMPLE: In the above example, if a user specifies 2, the system will start from level 2 and merge ON, DA and DA03. So after the merge the CBS Code build by import program will be 5.ONDADA03.F350.U11.095.ABC20.CAct04
ActivityDeletion Indicate to delete activities from schedule sheet in Unifier if it is deleted in P6.

Return Value

See Appendix B: Return Values.

Sample Method

updateScheduleActivitiesV2("acme","acme_authcode","Proj-0001","Schedule Sheet 001", "<XML Content>","Data Mapping 001","Id");

Additional Information

You must perform appropriate data mapping setups on the target schedule sheet. This includes mapping Unifier Schedule Sheet columns to Primavera XML elements and setting appropriate XML Import options.

This method will insert/update activities into any project/shell schedule sheet. The method will utilize the data mapping setup to update only those elements that are mapped.

The method errors out if the data mapping option does not allow merge.

Activities are uniquely identified within Primavera by the Globally Unique Id (<GUID>) or the identified provided as part of XML file. GUID will be used if ActivityIdentifier is empty or blank.

Resource assignments will be imported (inserted/updated) if the ‘Import Resource Assignments' checkbox is selected. Resource assignments will be matched by Resource Name.

This service can be used for Projects/Shells of cost code type CBS.

  • Activity identified with this creation method can be GUID or ID
  • On the options tab of Data Mapping, merge existing schedule option should be checked.
  • CBS Code will be derived automatically based on the XML file. For more information, see Associate CBS Codes with Activities.
  • ActivityDeletion tag logic is based on the "Delete Activity" checkbox available on data mapping window in Unifier. Following is the logic for this tag. ActivityDeletion tags are only considered for updateScheduleSheetFromFileV2 service and not for create.
Delete Checkbox Activity Deletion Behavior
Deselected Auto or Confirm

Activity Deletion tag is ignored.

Activities that are removed under source schedule will not be removed from the Schedule Sheet.
Selected Auto

Activity Deletion tag is considered.

Activities that are removed under source schedule will be deleted automatically under Unifier Schedule Sheet.

Selected Confirm

Activity Deletion tag is considered.

Activities that are removed under source schedule will not be deleted.

System will return an error and will not update Unifier schedule sheet.

If no activities are removed under source schedule, the system will update the Schedule Sheet.