Load File Content In Memory
Description
Load file content in memory is a step in the Input Plugin for Process Studio Workflows. Load file content in memory Input plugin step is used to load file content in memory.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of the step. This name can me modified from the default name and has to be unique within the workflow. |
| Dynamic Filename: | ||
| 1 | Filename is defined in a field | Enable checkbox to get filename from field. |
| 2 | Get filename from a field | Select the field from which to get filename. |
| Or | ||
| 1 | File or directory | Browse the file or directory to load in memory. |
| 2 | Regular expression | If directory is chosen filter filenames using regular expression. |
| 3 | Exclude Regular expression | Exclude filenames with this regular expression. |
| Selected Files: | View the selected files. | |
| 1 | File/Directory | View added Directory or filename. |
| 2 | Wildcard | View Regular expression applied. |
| 3 | Exclude wildcard | View Regular expression to exclude files. |
| 4 | Required | Is this file requir (Y/N). The default value is N. |
| 5 | Include subfolders | Select value for: Include subfolders(Y/N). The default value is N. |
| Content Tab: | ||
| Settings: | ||
| 1 | Encoding | Choose the file content character encoding. |
| 2 | Ignore empty file | Enable to ignore empty file. |
| 3 | Limit | Provide content limit. |
| Additional fields: | ||
| 1 | Include filename in output? | Enable checkbox to include file name in output. |
| 2 | Filename fieldname | Provide the field name for Filename output. |
| 3 | Rownum in output? | Enable to see row number in output. |
| 4 | Rownum fieldname | Specify field name for rownum. |
| Add to result filename: | ||
| 1 | Add files to result filename | Enable this checkbox to add the names of the files read to the result of this workflow. A unique list is being kept in memory that can be used in the next process entry in a process, for example in another workflow. |
| Fields Tab: | ||
| 1 | Name | Specify the name of the file related elements loaded in memory. |
| 2 | Element | Choose File element: File content/File size. |
| 3 | Type | Data type of element. |
| 4 | Format | Choose a field format. |
| 5 | Length | Specify the length of the element. |
| 6 | Precision | Specify the precision of the element. |
| 7 | Currency | Specify the currency symbol of the element. |
| 8 | Decimal | Specify the numeric decimal symbol of the element. |
| 9 | Group | Specify the numeric grouping symbol to use. |
| 10 | Trim type | Specify the type of trimming to use. |
| 11 | Repeat | Choose from Y/N. Select Y to repeat the column value of the previous row if the column value is empty (null). |
| Additional Output Fields Tab: | ||
| 1 | Short filename field | Specify a field name for short filename |
| 2 | Extension field | Specify a field name for filename extension. |
| 3 | Path field | Specify a field name for file path. |
| 4 | Is hidden field | Specify a Y/N. Y to hide field. Default is N. |
| 5 | Last modification field | |
| 6 | Uri field | Specify a field name for Uri (e.g. file:///C:/temp/file.txt). |
| 7 | Root Uri field | Specify a field name for Root Uri (e.g. file:///C:/). |