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