Property Input
Description
Property Input is a step in the Input Plugin for Process Studio Workflows. This step reads data (key, value) from Java properties files.
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. |
| 2 | Filenames from field | Enable ‘Filename is defined in a field’ checkbox to read filenames from a previous field. |
| 3 | Get filename from field | Specify the field to the filenames from. |
| 4 | File or directory | Specify the location and/or name of the input text file. Important: Click Add to add the file/directory/wildcard combination to the list of selected files (grid) below. |
| 5 | Regular expression | Specify the regular expression you want to use to select the files in the directory specified in the previous option. |
| 6 | Selected Files | Contains a list of selected files (or wildcard selections) and a property specifying if file is required or not. If a file is required and it is not found, an error is generated; otherwise, the file name is skipped. |
| 7 | Show filenames(s)... | Click button to display a list of all files that will be loaded based on the current selected file definitions. |
| Content Tab: | ||
| 1 | Include filename in output? | Enable checkbox to include the file name (String) in the output of this step. |
| 2 | Rownum in output | Specify a field name to contain the row number (Integer) in the output of this step. |
| 3 | Reset rownum per file? | Enable this option if you want the generated row number (optional) to be reset (to 1) at the start of every individual file. |
| 4 | Limit | Limits the number of rows to this number (zero (0) means all rows). |
| 5 | Result filenames | Enable 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 output field. |
| 2 | Column | Specify the attribute to read. |
| 3 | Type | Specify the data type to convert to. |
| 4 | Format | Specify the format or conversion mask to use in the data type conversion. |
| 5 | Length | Specify the length of the output data type. |
| 6 | Precision | Specify the precision of the output data type. |
| 7 | Currency | Specify the currency symbol to use during data type conversion. |
| 8 | Decimal | Specify the numeric decimal symbol to use during data type conversion. |
| 9 | Group | Specify the numeric grouping symbol to use during data type conversion. |
| 10 | Trim type | Specify the type of trimming to use during data type conversion. |
| 11 | Repeat | Select 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 fieldname to hold the short filename. |
| 2 | Extension field | Specify a fieldname to hold the filename extension. |
| 3 | Path field | Specify a fieldname to hold the file path. |
| 4 | Size field | Specify a fieldname to hold the file size. |
| 5 | Is hidden field | Choose from Y/N. Choose Y to hide field. Default is N. |
| 6 | Last modification field | Specify a fieldname to hold the last modification date. |
| 7 | Uri field | Specify a fieldname to hold the Uri (e.g. file:///C:/temp/file.txt). |
| 8 | Root Uri field | Specify a fieldname to hold the Root Uri (e.g. file:///C:/). |