The Tabular Files Extractor component can be configured using the Aspire Admin UI. It requires the following entities to be created in order to use the component:
Connector
Seed
This component is an application for workflow configuration, and it is used in the "onAddUpdate" Workflow Event.
Create Workflow
On the Aspire Admin UI, go to the Workflows main page
All existing workflows will be listed. Select one or click on the new button
Enter the new workflow description.
Select the "Create" button.
Go to the Workflow Event "onAddUpdate".
Search in “Type criteria” (in the Application's options) and drag, using the symbol () next to the Tabular Files Extractor component in the onAddUpdate section.
Enter a new description for this application component.
General Settings:
Debug: Option if you want to debug messages enabled.
Separator:Select The character used to separate each column on the tabular file. It can be: comma, semicolon, tab, pipe, SOH start of header (x001), dotaccent (·) (x307), c-cedilla (Ç), medium shade (▒), tilde (~) or a custom string separator (not longer than 5 characters).
Separator String:Custom separator string, cannot be longer than 5 characters.
Headers On First Row:Whether to use the first row data as column names or not. If false, columns will be named column1, column2, ...,.
Ignore Quotes:Determine if the quotes are going to be used as literal text or not.
Max number of sub-jobs:Max number of sub-jobs, 0 means process all sub-jobs.
Max number of lines to read:Max number of lines to read, 0 means process all lines.
Default column name prefix:If column names are not specified in the first row, this prefix will be used for column names followed by a sequential number.
Include Empty Columns:Whether or not to include empty columns in sub-jobs.