Business Rules 10.7 | webMethods Business Rules Web Help | Working with Business Rules in My webMethods | Using CSV Import
 
Using CSV Import
 
CSV Formatting
Importing a CSV File
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.