Bulk Load Activity - General Tab

The General tab contains the following fields.

Field Module Property? Description
Name No The name to be displayed as the label for the activity in the process definition.
Input Format No Choose an input format:
  • Entity Format: select to return entity only.
  • One Participant Relationship Format: select if the relationship is an identity relationship. That is, there is one or multiple participants per relationship.
  • Two Participant Relationship Format: select if the relationship is an association relationship. That is, there are only two participants in each relationship and both relationships are many-to-many.
ER Model Yes A SmartMapper ER Model defines a set of relationships and their participating entities.

Click the icon to select a SmartMapper ER Model.

Criteria No Select one criterion to load entities:
  • Name: for each entity, load records by name.
  • Index: index is the order in which the fields are defined in the schema. Index starts from 1. If specified, loading is by index.
Mode No This field is only displayed when the Input Format field is set to One Participant Relationship Format. Select a loading mode:
  • Create: any data load has a chance of collisions. When running in Create mode, the data is loaded in with minimal collision detection. This is the fastest, most efficient way to seed an empty store. See Create Mode Setting for details.
  • Add: this mode checks first for duplicate records and ignores them, rather than throwing an error. See Add Mode Setting for details.
  • Update: used to replace a relationship instance with a new one. See Update Mode Setting for details.
Enable Verbose Reporting No

When selected, a succeeded field and a failed field are reported for each record.

When cleared, the report includes details only about records that caused errors. A concise summary of successful loads and loads with given warnings is generated.

The report is displayed as part of the Output tab.

  • Create Mode Setting
    If the Mode setting is Create, a participant with the Cardinality is many option selected can be assigned with multiple values in the same relationship instance.
  • Add Mode Setting
    If the Mode setting is Add, a participant with the Cardinality is many option selected cannot be assigned multiple values in the same relationship instance. Instead, each value must be assigned using a unique relationship instance.
  • Update Mode Setting
    If the Mode setting is Update, lookup is performed based on the primary participant, and if no instance is found, a new one is created. If a lookup returns an existing relationship instance, it is replaced with the new participant.