Importing a Decision Table

You can import correctly formatted Microsoft Excel file to create a decision table or to merge to an existing decision table in TIBCO BusinessEvents WebStudio.

Note:
  • Only import from the Microsoft Excel files is supported. You cannot import from CSV (comma-separated values) files or tab-delimited text files. You can open such files in Excel and save as Excel format binary files.
  • Before importing the Microsoft Excel file, ensure that cells are not protected (locked). The protected cells, after the import, appear disabled in WebStudio.
Importing a Decision Table Flowchart

Procedure

  1. Open the Import dialog box in either of the following ways:
    • Select the virtual rule function and click the Import icon in the Tools toolbar.
    • Right-click the virtual rule function in the Group Contents section and select Import.
  2. Click Choose Files in the Import Decision Table dialog box.
  3. Browse the excel file you want to import and click Open.
  4. In the Name field, do either of the following:
    • Specify the new decision table name and click OK.
    • Specify the name of an existing decision table name and click OK.
    Depending on the decision table name, either a new decision table is created or a prompt is displayed that a decision table with the existing name already exists. The prompt provides the option to either overwrite existing table or merge the imported and the existing table.
  5. If you have given an existing decision table name, in the prompt, select either of the following options and click OK.
    Option Description
    Overwrite the existing decision table The imported table overwrites the existing decision table with the same name
    Manually merge the imported decision table with the existing one, in a diff editor WebStudio automatically merges both the decision tables and displays the merged decision table in the decision table editor. All the differences are highlighted using the following legends:
    • Green for added items
    • Red for deleted items
    • Yellow for modified items

    In the editor, to restore any data to the local value, click the modified item and select Use Local. Click the Save icon to save the changes to the decision table.