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.
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. |
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. |
|