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
- 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 -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
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. |