Click the Integration sub-node to expand and click the Detail sub-node to open the Detail log.
When you open Detail, from the Detail log, the Detail Design window opens which has the following tabs:
- General
In this tab, you can enter the name and description
- Data Elements
In this tab, you can click to add, modify, remove, or change the position of the data elements and data definitions, or labels, on the CSV template. The following columns are included in this tab:
- Row
- Element Label
- Data Element
- Direction
You can double-click on a row to open the Modify Data Element window and change the value for the Direction field to one of the following options:
- Both
- Output
- Input
The Data Elements tab enables you to define the data elements that can be part of the CSV template. Users are able to add all of the data elements from the new manual activity attribute form defined. The data element direction can be set either as input, output, or both. Unifier ignores the import of any formula fields that have a direction set as input or both data. The data elements whose direction is set as the output will not be seen in the CSV template, for the creation and update of activities.
Defining the integration interface is not mandatory for the CSV import of activities. If the integration is not defined, then export CSV for activities will show all the default columns, such as uuu_P6 columns and so forth.
The uuu_P6ActivityID and uuu_P6ActivityName will be included in the exported CSV template irrespective of the data element direction set in the integration interface.
The data elements uuu_P6ActivityID and uuu_P6ActivityName are required if the user updates the integration form defined. The data elements cannot be removed from the interface, and the direction for the data elements will be Both.
If any of the above elements are removed from the integration interface, and the user tries to complete the attribute form design, then Unifier displays an error message. Similarly, if the Direction for the data elements uuu_P6ActivityID and uuu_P6ActivityName is set as Output, then Unifier displays an error message during error check or at the completion of the attribute design.
The following data elements that are formula columns will default to Direction > Output, in the integration form:
- uuu_P6ActualTotalCost
- uuu_P6ActualTotalUnits
- uuu_P6PlannedTotalCost
- uuu_P6PlannedTotalUnits
- uuu_P6AtCompletionTotalCost
- uuu_P6AtCompletionTotalUnits
Users should be able to add the custom data elements that are added to the activity attribute form into the integration interface.
If the user selects the uuu_predecessor and uuu_successor data elements Direction > Input or Both, then Unifier displays an error message.