XBase Input
Description
XBase Input reads data from XBase-family database files (.dbf), including formats from dBase III/IV, FoxPro, Clipper, and other compatible systems. Use this step when your workflow needs to process legacy database files that are still in active use or require migration to a modern system. It supports reading from multiple files, accepting filenames from a previous step, and adding file metadata to the output stream for tracking which records came from which source file.
Configurations
| Field Name | Description |
|---|---|
| Step Name | Specify the name of the step. This name must be unique in a single workflow. |
| Filename | Specify the name of the DBF file from which to read the data. |
| Button: Browse | Click to search the file from which you want to read the data. |
| Accept filenames from previous steps | Note: You can opt to enter details either in the Filename field OR in the Accept filenames from previous steps section. |
| Accept filenames from previous step | Enable checkbox to read filenames from a previous step in the workflow. |
| Step to read filenames from | Select the step from which you want the filename to be read. |
| Field in the input to use as filename | Select the field from the input step that you want to use as a filename. |
| Limit Size | Specify a limit size to limit the number of rows read (optional). |
| Add input file to result | Select the checkbox to add the input file to the result stream. |
| Add rownr? - And Fieldname of rownr | Enable checkbox to add row number to output. Specify a fieldname to that contains the row number. |
| Include filename in output? - Filename fieldname | Enable checkbox to include filename in output. Specify fieldname to contain the file name to be included in output (optional). |
| The character-set name to use | Specifies the character set (such as, ASCII, UTF-8) to use. |
| Button: Preview | Click to preview the content that will be read. |