Adding associations to header files
You can create associations between records that exist in the IBM® TRIRIGA® Application Platform environment and the records that are uploaded by Data Integrator. To arrange this process, you can add specific information to define each association to the tab-delimited Header File.
About this task
The specific information identifies:
- The module with the business object that was used to create the record to be associated to the uploaded records.
- The business object that was used to create the record to be associated to the uploaded records.
- The name of the association from the existing records to the new records.
Data Integrator cannot be used to populate a smart section and certain types of locator fields. You might need to create a custom workflow for each type of association to append the associated record to a smart section or a locator field. Just associating two records does not make them appear in smart sections or locator fields. An exception is a query section that uses the same association.
Procedure
- Type the key word Associate in a new column immediately to the right of the last column of data.
- Insert two rows between the header row and the first row of data. The data now begins in row 4.
- In row 2 of the Associate column, enter the fully qualified
name of the business object and surround it with double percent symbols.
For example, %%triPeople:triPeople%%. This row reflects the module and business object of the records from which an association is made as %%Module:BusinessObject%%.
- In row 3 of the Associate column, enter an association
string and surround it with double percent symbols. For example, %%Manages%%. This string must be the association string that is defined from the %%Module:BusinessObject%% in row 2 to the business object for the file that is uploaded.
- In each row of the spreadsheet, in the Associate column, enter the name of the existing record from which the new record is associated.