Record Bulk Load
The Record Bulk Load activity populates records into a TIBCO Patterns table from a CSV file.
General
The General tab has the following fields:
Field |
Module Property? |
Description |
Name |
No |
The name of the activity within the process. The default value is |
Patterns Connection |
Yes |
The path to the shared configuration resource which contains the Patterns Connection information. See Activities Connection. |
Description
Provide a short description for the Record Bulk Load activity.
Input
The Input tab has the following fields:
Input Item |
Description |
|||||||||
TableName |
The name of the table to load records into. |
|||||||||
Operation |
The record operation to perform. The following are the possible operations:
|
|||||||||
FileName |
Name of the file that contains the table data. This should be the full path name in the correct format for the system it is on. |
|||||||||
FileReadBy |
The file system that contains the file. The following are the possible systems:
|
|||||||||
FileEncoding |
Supported encodings are |
|||||||||
HasFieldNames |
Set to |
|||||||||
HasFieldTypes |
Set to |
|||||||||
KeyFieldName |
Name of the file field that contains record keys. This is optional. |
|||||||||
KeyFieldIndex |
Index of the file field that contains record keys. This is optional. At most, either KeyFieldName and KeyFieldIndex can be specified. If neither is specified, records are assigned ascending numerical keys, but this is strongly discouraged. |
|||||||||
ParentKeyFieldName |
Name of the file field that contains parent-record keys. This is optional. |
|||||||||
ParentKeyFieldIndex |
Index of the file field that contains parent-record keys. This is optional. For child tables, one of these two must be specified. |
|||||||||
InitialKey |
If neither KeyFieldName or KeyFieldIndex are specified, this can be used to set the starting point of the ascending generated keys. This is optional. |
|||||||||
DoMaxWork |
Set to |
Output
The output contains the information on the table after the activity completes. See Table Create Output Fields for details.