Create Schedule Sheet Activities V2 from Oracle® Primavera P6™ XML
Description
This method creates activities into an existing Unifier project or shell (cost code type CBS) level schedule sheet based on the data mapping parameter and schedule options provided as part of Web Service call.
Support
This method can only support creation of activities in project or shell (cost code type CBS) level schedule sheets.
Installation: ASP and Self host
Level | Yes or No |
---|---|
Company Level | No |
Project and Shell Level | Yes |
Prototype
public XMLObject createScheduleActivitiesV2(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 or 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 | Name of the data mapping that should be used while processing XML file. If there is no map name then the one marked "Default" on the schedule sheet will be used. |
ActivityIdentifier | Possible values are the globally unique identifier (GUID)or ID. ID is the tag of Activity Id in Primavera. This tag will be used if you want to update an activity through udpateScheduleActivities webservice call. If Id tag is used for create and update then the value provided under Id tag will be used as task / activity identifier. |
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 together. EXAMPLE: Assume that P6 has following structure: (5.ON.DA.DA03.F350.U11.095.ABC20.CAct04). If you specify 3, then three levels will be merged together and the 3 segments will be based on the next parameter (CBS_startmergefrom). Value of this parameter can be 0. |
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, then 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. Value of this parameter can be 0. |
Return Value
See Return Values.
Sample Method
createScheduleActivitiesV2("acme","acme_authcode","Proj-0001","Schedule Sheet 001", "<XML Content>","<scheduleoptions>");
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. Only elements that are mapped will be copied.
This method can only be used to create new activities not for updating existing activities.
If invoked on an empty schedule sheet, this method will insert activities into the schedule sheet. If invoked on a non-empty schedule sheet, it will overwrite all existing activities (delete and recreate) in the non-empty schedule sheet if this function is allowed in the data mapping setup.
If the method is called on a non-empty schedule sheet and the data mapping setup does not allow overwrite, then the method will return an error in the response.
This service can be used for both Project (Standard) and Shells of cost code type CBS.
- Activity identified with this creation method can be GUID or ID
- CBS Code will be derived automatically based on the XML file. For more information see Associate CBS Codes with Activities.
In a Project, the activities are grouped together by CBS Codes.
The following shows a sample project data:
In this sample, the activities A1160, A1180 are under a CBS Code built by the following sequence of codes:
P -00050-EV-C-OB.5 Execute
P -00050-EV-C-OB.5.ON Onshore
P -00050-EV-C-OB.5.ON.DA LNG Facilities
P -00050-EV-C-OB.5.ON.DA.DA03 LNG Shared Facilities
- and so forth ...
In this sample, activity A1160 (Plot Plan) is associated with CBS Code:
P -00050-EV-C-OB.5.ON.DA.DA03.F350.U11.095.ABC20.CAct04
. The XML file that is generated by Unifier does not include the entire string of CBS Code with all segments. The structure of the XML file is built based on the Parent/Child CBS segments. As a result, activity A1160 (Plot Plan) has reference to its immediate parent segment, which in this example isCAct04
, only. TheCAct04
segment will have a reference toABC20
segment, theABC20
has reference to095
and so on.To associate an activity with a CBS Code, the system will go through this hierarchical structure of CBS segments to build the final CBS Code. Unifier will perform this function when CBS Code import option is checked on the Options tab of Data Mapping. The CBS Code string generated will then be validated with leaf level CBS Codes created under Cost Manager. If the CBS Code is available, then the activity will be associated with the CBS Code. If the CBS Code is not available, then the import process will fail.
Additional options are available to create entire string of CBS Code. These options can be used to address any structural differences between the way CBS Codes are built in Unifier Cost Manager and CBS Codes in Primavera Project.
- Levels: User can choose number of CBS segments that should be considered while processing a Primavera XML file. For example, if user enters 8 then last segment CAct04 will not be considered while building CBS Code.
- Suffix Mask: User can optionally enter a suffix mask, which will be added to the end of CBS Codes built based on Primavera XML file. Users can either enter a constant value of select a data element from activity attribute form.
Note: With the help of this data element being selected as suffix, it is possible to build CBS Code and assign it to an activity based on attributes of activities coming from P6 instead of the CBS Code hierarchy of the activities.
Related Topics
Create Schedule Sheet Activities from Primavera P5 and P6 XML
Create Schedule Activities from file V2
Update Schedule Sheet Activities from Oracle® Primavera™ P5 and P6 XML
Update Schedule Sheet Activities V2 from Oracle® Primavera™ P6 XML
Update Schedule Activities From File V2
Get Schedule Sheet Activities from Unifier
Get a List of Project Schedule Sheets
Get a List of Schedule Sheet Data Mappings
Last Published Friday, December 13, 2024