Chapter 7 Working with Decision Tables : Importing and Exporting Decision Tables

Importing and Exporting Decision Tables
This section explains how to import data from a Microsoft Excel file and export a decision table to a Microsoft Excel file.
Importing Data from a Microsoft Excel File
You can import data from a Microsoft Excel file to create a decision table. For some examples see BE_HOME/DecisionManager/examples/ExcelFiles.
To Import Data
1.
2.
From the File menu:
Select Import. An Import dialog is displayed.
Click Browse and select the Microsoft Excel file to import
From Project Explorer:
The data imported from the Microsoft Excel file is saved to the decision table and you can continue modifying the data or add new data.
For custom conditions and custom actions to be imported from Excel, mark the header names as "CustomCondition" and "CustomAction" respectively.
Decision Manager supports two formats, an older one and the current one. The current format requires Version header. While importing using the older format, a Version header in the Excel file is not required.
Figure 1 Microsoft Excel File Format - Old
Figure 2 Microsoft Excel File Format - New
The new Excel file format requires Version header and version number.
In the new Excel file format:
Exporting a Decision Table to a Microsoft Excel File
You can export the decision table to a Microsoft Excel file. To export:
1.
2.
Select Export. An Export dialog is displayed
Click Browse
Not Exported  A priority setting of 5 in a decision table row (because 5 is the default value).
The decision table is now exported in the new header format with a header containing version and version number. See the above figure for the new Excel file format.