File Writer Activity Overview

Context

Use the File Writer Activity to create a file, write (edit) to the file, and save the file to the Cora SeQuence database as part of a workflow. After you create the file, you can access and use the file's data in other activities.

Use Cases

  • Create a spreadsheet of all support tickets with a designated severity level.
  • Create a file from large, unstructured data that you import to .
  • Create a file and use it as an attachment in File Activities.
  • File enrichment.

Define the File

  • Type a file name including the file extension.
  • Select a file type: CSV or OpenXML

IMPORTANT: After you select a file type and click Next, you cannot change the file type (even if you click back). If you need to change the file type, cancel the activity wizard and start a new activity wizard. See the screenshot below.

CSV Files

CSV Files Configuration Parameters

Parameter
Description
Encoding
  • ASCII
  • Big-Endian Unicode
  • Unicode
  • UTF32
  • UTF7
  • UTF8
First row contains header
Select if the first row of the source file contains a header. This row is skipped when the file is processed.
Has fields enclosed in quotes
Fields contain quotations when they are used to count separator symbols as part of the field value.
For example, if a field value is 52,345 and comma is a defined separator, the entire field is wrapped in quotations "52,345".
Cases in which a field is wrapped in quotations for other reasons, and the Has fields enclosed in quotes checkbox is selected, the quotations are removed from the field.
Trim white spaces
Removes unnecessary spaces in cell values. This option is selected by default.


OpenXML Files

OpenXML Files Configuration Parameters

Parameter
Description
Encoding
  • ASCII
  • Big-Endian Unicode
  • Unicode
  • UTF32
  • UTF7
  • UTF8
Sheet Name
If the file contains more than one sheet, specify the sheet name that you want to process. If this field is empty, the first sheet in the file is selected.
First row contains header
Select if the first row of the source file contains a header. This row is skipped when the file is processed.


Define Field Properties - All File Types

This window depends on previous configurations. In this example, we selected a CSV file with fixed width.

File Field Properties Configuration Parameters

Parameter
Description
Source Query
The source of the data that you want to include in the file.
Name
Field name that you enter.
Value
Field value.
Field Type
Determines the valid values for the property.
Advanced Options
See the Advanced Options section.


Define Advanced Options - All Files (optional)

DateTime Configuration


Time Configuration

Access and Use the File's Data

After you create the file, you can access the file's data from the activity's metadata. For example, if you want to use data from the created file in a Put File Activity, you can use the created file when defining the file source.

About this Article
  • Created: 03/26/2017 2:49 am EDT
  • Last updated: 01/23/2018 3:48 am EST
In This Article