Microsoft Access Input
Description:
Microsoft Access Input is a step in the Input Plugin for Process Studio Workflows. Microsoft Access Input plugin step reads directly from Microsoft Access "MDB" 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 | Filename is defined in a field | Enable checkbox to accept filenames from previous steps. |
| 3 | Get filename from field | Select the field that will contain the filenames at runtime from this list. |
| 4 | File or directory | Specify the location and/or name of the input file or browse for the file. **Note:**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 Filename(s) button | Displays a list of all files that will be loaded based on the current selected file definitions |
| 8 | Preview rows button | Click Preview to examine the contents of the specified Access file |
| Content Tab | ||
| 1 | Table | The access table-name to read data from. |
| 2 | Include filename in output? | Allows you to specify a field name to include the file name (String) in the output of this step. |
| 3 | Include table name in output? | Allows you to specify a field name to include the table name (String) in the output of this step. |
| 4 | Include rownum in output? | Allows you to specify a field name to include the row number (Integer) in the output of this step. |
| 5 | Reset rownum per file? | This check box will start to number at 1 in each file that is being read. |
| 6 | Limit | Specify an integer larger than zero here to limit the number of rows being read by this step. |
| 7 | Add filename to result? | Adds the Access filenames 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 name of the column in the Access table. |
| 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 | Choose from Y/N. Select Y to repeat the column value of the previous row if the column value is empty (null). |