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
Importing relationship instance data from the comma-separated values (CSV) format
Using the relationship editor in IBM Integration Designer, you can import existing data created in a CSV format, such as a spreadsheet that has been created in Excel, into a relationship.
To import relationship instance data from a pre-populated spreadsheet that uses a comma-separated values (CSV) file format, follow these steps:
Procedure
- From the File menu, select Import > Business Integration > Relationship instance data and click Next (If that you can also import a .csv file from the Properties page of a relationship using the Import button).
- The Import Relationship Instance Data window opens. Use Browse to select the .csv file and then identify the target relationship.
- Click Next to select the role and key attributes for each data column and to specify which rows to import. In some cases, the CSV data contains the title rows for the columns, which are not valid instance data values. You can clear the rows by clicking the check box on the left side in each row. If that every role must be bound to a column, however, not all columns are required to be bound.
- Click Finish. After the data has been imported, the target relationship will open in the relationship editor.