CSV File Writer Output Adapter Sample

This sample demonstrates the usage of the TIBCO StreamBase® CSV File Writer embedded adapter.

Running This Sample in StreamBase Studio

  1. In the Package Explorer, double-click to open the CVSWriterTest.sbapp application. Make sure the application is the currently active tab in the EventFlow Editor.

  2. In the canvas, select the CSVWriter adapter named OutputAdapter1. In the Properties view, Adapter Settings tab, change File Name to point to a valid location on your machine. The sample's default file name, sample.csv, will be written to the sample project directory.

  3. Click the Run button. This opens the SB Test/Debug perspective and starts the application.

  4. Select the Manual Input tab.

  5. Enter the value 10 for a and press Send Data.

  6. Press F9 or click the Stop Running Application button.

  7. The file specified in the File Name field should now contain tuples formatted as shown in this example:

    a,b,Timestamp
    10,100,2013-06-15 22:48:44.502-0400
    

    If you used the default output file name, or specified another file written to the sample project directory, you might have to select the project name in the Package Explorer and press F5 to refresh the project's contents before the output file appears.

Running This Sample in Terminal Windows

This section describes how to run the sample in UNIX terminal windows or Windows command prompt windows. On Windows, be sure to use the StreamBase Command Prompt from the Start menu as described in the Test/Debug Guide, not the default command prompt.

  1. Open two terminal windows on UNIX, or two StreamBase Command Prompts on Windows. In each window, navigate to the directory where the sample is installed, or to your workspace copy of the sample, as described above.

  2. In window 1, run sbd CSVWriterTest.sbapp.

  3. In window 2, run sbc enqueue InputStream1 < inputstream.dat

  4. In window 2, run sbadmin shutdown to shut down the server.

  5. Look for the file sample.csv in the current directory.

Importing This Sample into StreamBase Studio

In StreamBase Studio, import this sample with the following steps:

  • From the top menu, click FileLoad StreamBase Sample.

  • Select this sample from the Embedded Adapters list.

  • Click OK.

StreamBase Studio creates a single project containing the sample files.

Sample Location

When you load the sample into StreamBase Studio, Studio copies the sample project's files to your Studio workspace, which is normally part of your home directory, with full access rights.

Important

Load this sample in StreamBase Studio, and thereafter use the Studio workspace copy of the sample to run and test it, even when running from the command prompt.

Using the workspace copy of the sample avoids the permission problems that can occur when trying to work with the initially installed location of the sample. The default workspace location for this sample is:

studio-workspace/sample_csvwriter

See Default Installation Directories for the location of studio-workspace on your system.

In the default TIBCO StreamBase installation, this sample's files are initially installed in:

streambase-install-dir/sample/csvwriter

See Default Installation Directories for the location of streambase-install-dir on your system. This location may require administrator privileges for write access, depending on your platform.