Importing the Micorsoft Excel File to a Decision Table at the Command Line

You can import a correctly formatted Microsoft Excel file as a decision table using the command line.

Procedure

Navigate to BE_HOME/studio/bin/ and open a command prompt.

Execute a command with the following format (all on one line) at a command prompt:

studio-tools -dt importExcel [-h] -studioProjPath studioProjectDir [-projWsPath projectWorkspaceDir] -excelPath excelFilePath -dtName decisionTableName -folderPath decisionTableProjectFolderPath -vrfPath vrfProjectFolderPath

For example:

studio-tools -dt importExcel -studioProjPath D:\Workspace\CreditCardApplication -excelPath c:\BankUser.xls -dtName BankUser -folderPath \Virtual_RF -vrfPath \Virtual_RF\BankUser_VirtualRuleFunction

Result

Table 5 provides detailed information about the options.

*TIBCO BusinessEvents Studio* Tools Options for Importing Excel Files into *TIBCO BusinessEvents Decision Manager*
Option	Description
-dt importExcel	Within the `dt` category of operations, specifies the `importExcel` operation for importing Excel files containing decision table definitions.
-h	Optional. Displays help.
-studioProjPath	File path to the TIBCO BusinessEvents Studio project into which the decision table will be added.
-projWsPath	Optional. File path to the Eclipse Workspace used for the TIBCO BusinessEvents Studio project.
-excelPath	File path to the Excel file to be imported as a decision table.
-dtName	Name of the decision table that the Excel file imports as.
-folderPath	TIBCO BusinessEvents Studio project path to the decision table (but not including the decision table name).
-vrfPath	TIBCO BusinessEvents Studio path to the virtual rule function under which to create the decision table. The decision table is an implementation of this virtual rule function.