This section explains how to import data from a Microsoft Excel file and export a decision table to 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.
● From the File menu:
− Select Import. An Import dialog is displayed.
− Click Browse and select the Microsoft Excel file to import
● From Project Explorer:
− Import dialog is displayed with VRF selected. Select the Microsoft Excel file to import and enter the name of the decision table.
● Does not allow you to choose any other source (VRF) available in the tree other than the selected.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 - OldFigure 2 Microsoft Excel File Format - New
● The Condition and Action column contain their respective body in the first row followed by their values.
● The CustomAction, CustomCondition, Description, ID, and Priority rows are blank (no body) followed by their actual values.
− 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.
Copyright © TIBCO Software Inc. All Rights Reserved.