Using CSV Import
You can prepare a CSV file with the rules you want to add to a decision table and then import this CSV file to the Business Rules User Interface in My webMethods to fill an existing decision table. The content in the CSV file does not override the content of the existing decision table but the input from the CSV file is appended after the last rule of the decision table.
For instructions on how to import a CSV file, see
Importing a CSV File.
Scope
The following limitations apply to the import of CSV files:
CSV import is only enabled for decision tables.
The CSV file can contain the following content:
Operators for condition columns (including range operators): =, !=, >=, <=, <, >, <...<=, <=...<, <...<, <=...<=
Operators for assignment result columns: =
Literals
Principal definitions
Expressions
Constants, parameter elements, actions, and in effect dates must not be contained.
You can import values for the following column types:
Condition columns
Assignment result columns
Verification service columns
Data provider service columns
Values for action result columns cannot be imported.
Requirements
For a successful import, keep the following points in mind:
The CSV file must have the same number of columns as the decision table in
My webMethods, with exception of the
In Effect column. The in effect date cannot be specified in the CSV file but is set to
Always as a default.
The column names in the header line of the CSV file do not have to match the column names of the decision table in
My webMethods. The columns of the CSV file are assigned from left to right.
Very large CSV files may result in an import error if they exceed the allowed HTTP request size. By default, this is 20 MB on
My webMethods Server. Should your CSV file be very large, you can split up the data into two or more CSV files and import them one after the other.
The values in the CSV file must be formatted as described in
CSV Formatting.