ConvertCSVToDocuments

Many systems output data in comma-separated (CSV) format. The ConvertCSVToDocuments processor automatically detects any FlowFile that represents a text or CSV file and attempts to parse the data into IDOL documents. Each row in the CSV file becomes a new IDOL document.

Properties

Name Default Value Description
Document Registry Service   A DocumentRegistryService controller service that manages and updates a document registry database. This ensures that documents are indexed in the correct order.
Use CSV Header Row True A Boolean value that specifies whether the first row of the CSV file specifies field names and should not become a document.
CSV Field Names   The names of the fields in the CSV file. Setting this property overrides any values read from the file when Use CSV Header Row is true.
Reference Field DREREFERENCE The name of the field to use as the document reference.
Content Field DRECONTENT The name of the field to use as the document content.
Map all fields to content False A Boolean value that specifies whether to add all of the values to the document content, separated by new lines.
Base Reference   If the CSV file doesn't contain a suitable reference field, you can specify a base reference The documents extracted from the CSV file will be given references in form BaseReference:N where N is the line number in the source CSV file.

Relationships

Name Description
extracted New FlowFiles for individual IDOL documents that were extracted from a CSV file.
success Original FlowFiles that were successfully processed.
failure Original FlowFiles that do not represent CSV files, or from which there were parsing errors.

_FT_HTML5_bannerTitle.htm