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

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

Related tasks
Related reference