Importing the Microsoft 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 -wsPath workspaceFolderPath

    For example:

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

Reference

importExcel Options
Option Description
-dt importExcel Specifies the importExcel operation for importing a Microsoft Excel file to create a decision table.
-h (Optional) Prints usage help.
-studioProjPath Specifies the path to the TIBCO BusinessEvents Studio project to which you want to import the file.
-excelPath Specifies the path to the Microsoft Excel (.xls or .xlsx) file that you want to import to TIBCO BusinessEvents Studio.
-dtName Specifies name of the decision table that you want to create using the Microsoft Excel file.
-folderPath Specifies the output folder for the created decision table. Specify the output folder path relative to the path of the TIBCO BusinessEvents Studio project path.
-vrfPath Specifies the path of the virtual rule function that the imported decision table uses. Specify the virtual rule function path relative to the path of the TIBCO BusinessEvents Studio project path and exclude the .vrf extension in the it.
-wsPath (Optional) Use this option if you want to specify the location of the existing TIBCO BusinessEvents Studio workspace folder to which the decision table is added. The best practice is to leave this option blank so that the project is not stale.