This functionality was modified in an update. For more information, see Configure the Exchange Data functionality (modified in an update).
The Exchange Data functionality enables you to export data and documents to CSV files. You can validate and export these CSV files to a target system using Data Validator. To use this feature, you must create a custom method using the delivered SPFExchangeData client API and associate it with the type of object you want to export.
The Exchange Data command allows you to:
-
Create a report configuration object to generate basic and inverted CSV files using view definitions and graph definitions, respectively.
-
Create an export details object that contains all the required parameters to run a Data Validator job or to generate a control file in XML format for silently running a Data Validator job, to validate the documents and data in CSV files and export them to a target system.
The report configuration object contains details of view definitions and graph definitions, as well as additional parameters, such as the type of CSV file, inclusion of superseded revisions and working revisions, CFIHOS format for export, and so on. The view definitions and graph definitions are used to gather objects by traversing relationships.
The custom method configured using the SPFExchangeData client API and the graph definition
used for generating CSV files must be configured on the same interface definition.
Mappings for CSV files using Data Validator
You configure the mapping for importing data using Data Validator. Data Validator imports data in CSV format into the staging system where the validation takes place. Data Validator uses import definitions to map the column headers in the input CSV file to the correct column headers for objects, properties, and relationships in the staging area. The import mapping not only uses the physical column headers that already exist in the input data file, but also supports other column headers that are computed or provided by the user during the import process. Data Validator validates the quality of the incoming data in the supplied files before they are loaded into the system.
Access groups and roles
Two access groups, SPFExchangeDataAdmin and SPFExchangeDataUser, are delivered with the software.
The SPFExchangeDataAdmin access group and the SDx Administrator role enable you to access the Exchange Data menu options and associated methods for creating and finding the report configuration and export details objects. For more information about access groups and roles, see How to Configure the Security Model.
CFIHOS format
You can export data and documents to CSV files using the Capital Facilities Information HandOver Specification (CFIHOS) format. The CFIHOS format is a common data exchange language that standardizes the specifications of information handover requirements for a project for owner operators, contractors, equipment manufacturers, and suppliers. The ICFIHOSDetails interface stores the CFIHOS details and exposes three properties: CFIHOSName, CFIHOSNumber, and CFIHOSDescription.
The delivered CFIHOS format is supported for:
-
FDW tag classification
-
FDW material classification
-
FDW document classification
-
Properties, EnumEnums, and UoMEnums
-
You can also export assets, models, and tags in CFIHOS format.
-
To export data and documents in CFIHOS format, ensure the class definitions for the objects being exported realize the ICFIHOS interface.
The following work process diagram illustrates the steps involved in the export of data and documents to CSV files, and the subsequent validation and export of these CSV files to a target system using Data Validator.
Click a box in the diagram to go to the associated procedure.