IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Defining and transforming data > Create relationships > Work with comma-separated values (CSV) data
Export relationship instance data to the comma-separated values (CSV) format
Using the relationship editor in IBM Integration Designer, you can export relationship instance data into a .csv file, such as an Excel spreadsheet.
To export relationship instance data to a comma-separated values (CSV) file format, follow these steps:
Procedure
- From the File menu, select Export > Business Integration > Relationship instance data and click Next (If that you can also export a .csv file from the Properties page of a relationship using the Export button).
- The Export Relationship Instance Data window opens. Click the drop-down list to select a static relationship to export.
- Specify the target file format using one of the following options:
- Contains only instance values: Selecting this target file format type provides only the instance values. Selecting this option means that if the data is modified after it was exported, you will need to reconcile the values when importing them back into IBM Integration Designer.
For example, upon importing, you will need to indicate which columns correspond to which roles and key attributes. If that this format type is not supported when importing the output file into IBM BPM.
- Contains properties and metadata: Selecting this target file format type provides all of the data that can be converted into the ri (relationship instance) file. Selecting this option means that if the data is modified after it was exported, you will not need to further reconcile the values when importing them back into IBM Integration Designer. If that this format type is supported when importing the output file into IBM Process Server.
- Click Browse to set the target .csv file.
- Click Finish to export the data.