Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

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

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.