Converting a CSV File to a Microsoft Excel File with the Studio Tools Utility

If you have a CSV (comma-separated values) file of a decision table, you can open and save it in Excel, so that it can be used for import to TIBCO BusinessEvents Decision Manager.

Note: The Studio Tools utility runs only on Microsoft Windows and Linux platforms as it has dependencies on Eclipse.

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 convertCSV2Excel [-h] -csvPath CSVFilePath -excelPath excelFilePath -s columnSeparator

For example:

studio-tools -dt convertCSV2Excel -csvPath D:\myfolder\BankUser.csv -excelPath D:\myotherfolder\BankUser.xls -s ;

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 convertCSV2Excel	Within the `dt` category of operations, specifies the `convertCSV2Excel` operation for converting comma separated value (CSV) files to Excel format files.
-h	Optional. Displays help.
-CSVPath	File path to the CSV file to be converted.
-excelPath	File path to the Excel file to be created.
-s	Optional. The column separator that is used in the CSV file. Default is "`,`" (comma).