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:

  • Seed

This component is an application for workflow configuration, and it is used in the "onAddUpdate" Workflow Event.

Create Workflow


  1. On the Aspire Admin UI, go to the Workflows main page
  2. All existing workflows will be listed. Select one or click on the new button image2021-12-7_7-37-8.png
    1. Enter the new workflow description. 
  3. Select the "Create" button.
  4. Go to the Workflow Event "onAddUpdate".
  5. 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.
  6. Enter a new description for this application component.
  7. General Settings:
    1. Debug: Option if you want to debug messages enabled.
    2. 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).
      1. Separator String: Custom separator string, cannot be longer than 5 characters.
    3. Headers On First Row: Whether to use the first row data as column names or not. If false, columns will be named column1, column2, ...,.
    4. Ignore Quotes: Determine if the quotes are going to be used as literal text or not.
    5. Max number of sub-jobs: Max number of sub-jobs, 0 means process all sub-jobs.
    6. Max number of lines to read: Max number of lines to read, 0 means process all lines.
    7. 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.
    8. Include Empty Columns: Whether or not to include empty columns in sub-jobs.
  8. Custom Mappings:
    1. Table Mapping: Specify the mapping configuration.
      1. From: Specify the field to a destination field.
      2. To: Specify the destination field name.









  • No labels