Execute Data Mapping
The Execute Data Mapping action task generates a record set by executing a data mapping configuration on a data source. It can also automatically create a record set from a PDF/VT file without using a data mapping configuration.
Input
Optional. Both main options can refer to external files, but either one can be the active data file using %F. By default the Data Source is set to use the active data file as input.
To open a Microsoft Access database, you have to use the Load External File task just before the Execute Data Mapping task.
Processing
The task executes the selected data mapping configuration on the appropriate data source, or converts the PDF/VT into a Record Set directly.
If the data mapping configuration expects a database data source, the Data Source option is ignored and the database is accessed instead. If a PDF/VT file is used, the data mapping configuration option is optional - if one is present, it must be able to read the PDF/VT.
Output
The output to this task is twofold. On the OL Connect Server side, a Record Set containing multiple records is created and saved. On PlanetPress Workflow side, Metadata is returned with information about each record set (see Metadata in OL Connect jobs).
Alternatively, it is possible to ignore creation of the Record Set on the OL Connect Server and simply return an XML file containing the full Record Set structure.
Properties
General Tab
- Data mapping configuration: Enter the full path to a valid data mapping configuration (.oldatamapper) file, or use the Browse button to find the path.
- Data Source or PDF/VT file: Enter the full path to a valid data source compatible with the above data mapping configuration or a PDF/VT file, or use the Browse button to find the path.
- Output Type group:
- Output IDs in Metadata: Select to only output the Record and Job IDs in the metadata. This does not permit sorting and filtering, but it enhances performance since only minimal data is exchanged between the OL Connect Server and PlanetPress Workflow.
- Output records in Metadata: Select to output the full Record table (no Details table) as metadata in the task. It is then possible to sort and filter the metadata using the regular metadata tools, as long as the Update Records from Metadata option is used in further tasks to use the modified metadata.
- Output results in XML data file: Select to output an XML structure containing the full Record Set including all details table. When this option is used, the Record Set is not saved on the OL Connect Server, the data is simply returned and processing stops on the server side. This option cannot be used with other OL Connect tasks.
OL Connect Proxy Tab
This tab is common to all OL Connect tasks and defines where to process the jobs sent through these tasks. When these fields are empty, they use the defaults set in the OL Connect User Options page of the preferences.
Defaults are not used unless the configuration is sent to the Workflow service.
- OL Connect Proxy Address: Enter the machine name or IP Address where the OL Connect Server resides.
- Port: Enter the port to use to communicate with the OL Connect Server. Default: 9340
- User name: Enter the user name expected by the OL Connect Server.
- Password: Enter the password expected by the OL Connect Server for the above user name.
On Error Tab
Comments Tab
The Comments tab is common to all tasks. It contains a text area (Task comments) that lets you write comments about the task. These comments are saved when the dialog is closed with the OK button, and are displayed in the Task Comments Pane.
Check the option Use as step description to display the text next to the icon of the plugin in the Process area.
|