/
Creating a CSV \ Spreadsheet extract of entity data.

Creating a CSV \ Spreadsheet extract of entity data.

This document shows you how to create an extract of entity data from your TFS database. It assumes that you have created the campaign.

The steps to run a campaign are ;


 1. Creating the Stream - Click here to expand...

At their most fundamental, streams describe a set of criteria or fields and the output format to be used when processing a marketing campaign. Streams are useful because one campaign may have different outputs. You would create a different stream for each campaign output.


  1. Click in the Streams area of the screen.
  2. Click on the New button.
  3. Enter the Name for the stream.
  4. Select the marketing company the data is to be supplied to (Optional).
  5. Enter some notes against the stream to identify its purpose (Optional).
  6. Click on OK.
 2. Specifying the stream output - Click here to expand...


  1. From the stream dialogue box click on the Output tab.
  2. Click on the pop up button and select either Clients and Prospects or All entities.
  3. Click on the pop up button against format
  4. Select either CSV or Excel.
  5. Enter a name for the output file.
  6. Click on the OK button.
 3. Selecting the Fields - Click here to expand...

When you are doing either a CSV or Excel campaign you have to pick the fields that will be extracted.


  1. Click on the field that you want to extract. When a field description has the word entity.
  2. Click on the >> button to move the field into the selected fields.

The << button will move the highlighted Selected Field back to the Available Fields column and the X will move back ALL the Selected Fields back to the Available Fields,

 4. Criteria Selection - Click here to expand...

When you have defined the fields that you want to extract you can then define the criteria for the entities that you wish to extract. /wiki/spaces/TFSKB/pages/48857298.

 Running the Stream - Click here to expand...

When you have entered the criteria click on the Run Stream button (Shown below)

You will then be taken to the Review Entitites for Marketing screen.

This screen shows you all of the entities that will be extracted.

You can deselect and select any single line by double clicking on the tick

You can deselect all the entities by clicking on the button.

You can ensure all records are selected by clicking on the button.

When you are satisfied with the records that will output click on the button.