CSV File Writer Output Adapter Sample

In the Project Explorer view, open the sample you just loaded.

If you see red marks on a project folder, wait a moment for the project to load its features.

If the red marks do not resolve themselves after a minute, select the project, right-click, and select Maven>Update Project from the context menu.

Open the src/main/configurations folder and double-click to open sbengine.conf.

Use a dataAreaPath property to specify the full, absolute path to a folder that is to contain the file to be written by this adapter. You can uncomment the dataAreaPath line appropriate for your operating system and edit the sbuser placeholder name for your system login name. For example, take the following starting point:

streamBase = {
  // dataAreaPath = "C:/Users/sbuser/Documents"
  // dataAreaPath = "/Users/sbuser/Documents"
  // dataAreaPath = "/home/sbuser/Documents"
  // dataAreaPath = "/Users/sbuser/tmp"
  }

Uncomment the first dataAreaPath line and replace sbuser:

streamBase = {
  dataAreaPath = "C:/Users/your-login-name/Documents"
  // dataAreaPath = "/Users/sbuser/Documents"
  // dataAreaPath = "/home/sbuser/Documents"
  // dataAreaPath = "/Users/sbuser/tmp"
  }

Open the src/main/eventflow/packageName folder.

Open the CSVWriterTest.sbapp file and click the Run button. This opens the SB Test/Debug perspective and starts the module.

Select the Manual Input tab.

In the Stream drop-down control, select the Write stream.

Enter any integer value such as 10 in the num field and click Send Data.

Enter several more integers, clicking Send Data after each one.

Use your operating system's file browser to navigate to the folder you specified in step 3. A file named sample.csv (or named as specified in the File Name field of the adapter's Properties view, File Creation tab) should now contain tuples formatted as shown in this example:

num,square,Timestamp
10,100,2018-04-27 12:40:42.912-0400
200,40000,2018-04-27 12:40:50.958-0400
42,1764,2018-04-27 12:40:56.958-0400

The sample is configured to append to the specified file, so you may also see lines from previous runs of this sample.

In the Manual Input tab, select the Stream drop-down control, and select the zStartControl stream. Enter the name of an alternate file for this adapter to write to. For example, enter NewFileName.csv.

In the Stream control, re-select the Write stream and enqueue a few more integers in the num field.

Use your operating system's file browser to locate and open the NewFileName.csv file in the same directory you specified in step 3. Open the file to see the most recent set of tuples entered.

When done, press F9 or click the Terminate EventFlow Fragment button.

Studio workspace folder

.nodes (This is a hidden folder on macOS.)

nodename (see the Clusters view to identify the node name for this sample's most recent launch)

fragments

enginename (see the Clusters view)

engine-data-area