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

  1. Navigate to BE_HOME/studio/bin/ and open a command prompt.
  2. 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.
Related tasks
Related reference