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:
| Field Name | Description |
|---|---|
| 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. |
| Filename is defined in a field | Enable checkbox to accept filenames from previous steps. |
| Get filename from field | Select the field that will contain the filenames at runtime from this list. |
| 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. |
| Regular Expression | Specify the regular expression you want to use to select the files in the directory specified in the previous option. |
| 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. |
| Show Filename(s) button | Displays a list of all files that will be loaded based on the current selected file definitions |
| Preview rows button | Click Preview to examine the contents of the specified Access file |
| Content Tab | |
| Table | The access table-name to read data from. |
| Include filename in output? | Allows you to specify a field name to include the file name (String) in the output of this step. |
| Include table name in output? | Allows you to specify a field name to include the table name (String) in the output of this step. |
| Include rownum in output? | Allows you to specify a field name to include the row number (Integer) in the output of this step. |
| Reset rownum per file? | This check box will start to number at 1 in each file that is being read. |
| Limit | Specify an integer larger than zero here to limit the number of rows being read by this step. |
| 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 | |
| Name | Specify the name of the output field. |
| Column | Specify the name of the column in the Access table. |
| Type | Specify the data type to convert to. |
| Format | Specify the format or conversion mask to use in the data type conversion. |
| Length | Specify the length of the output data type. |
| Precision | Specify the precision of the output data type. |
| Currency | Specify the currency symbol to use during data type conversion. |
| Decimal | Specify the numeric decimal symbol to use during data type conversion. |
| Group | Specify the numeric grouping symbol to use during data type conversion. |
| Trim type | Specify the type of trimming to use during data type conversion. |
| Repeat | Choose from Y/N. Select Y to repeat the column value of the previous row if the column value is empty (null). |