Push to Repository

The Push to Repository Action task adds data to the PReS Workflow Data Repository. The task may only add one KeySet per action. If more than one insert is needed, a loop must be established first.

The Push to Repository task can also be used to update an existing KeySet if a lookup is provided.

Input

Any data file, in any format.

Processing

A new KeySet is added to the Data Repository, or updated, using the data provided.

Output

The unmodified input file. This task does not change the data file in any way. The only modification is a single variable or Job Info variable, if the Store Result option is selected.

Task properties

General tab

  • Group: Use the drop-down to select into which group the KeySet is inserted, or in which group the KeySet should be updated.
  • Key set: Displays a list of keys for the selected group.
    • Key: Displays the key name in the group.
    • Value: Enter a value for the key, which will be inserted in the KeySet. This value can be dynamic, including data selections, metadata selections, variables and other data.
    • Update: Check to update the key with new data. For the Update column to be active, the Update base on option must be checked. Key values will only change in the KeySet if the Update checkmark is checked for that key, otherwise it is left unchanged.
  • Create Group and Key(s) if they don't exist: Check this option to force the creation of a new group and/or keys, if they do not exist. This is useful for portability: if a configuration with this task is sent to a new Workflow server that does not contain this group or is missing keys, the task will create them automatically.
  • Update based on: Check this option to update an existing KeySet instead of creating a new one. The value of the Condition field is used to filter the KeySets to only obtain one or more. Here are some valid conditions:
    • last_name = 'Jones'
    • id = 237
    • age IS NOT NULL
    • last_name LIKE 'La%'
    • province IN ('QC', 'ON', 'AB')
  • Add KeySet when condition is false: If the update condition above is false, a new KeySet is added to the group. If unchecked, no data is changed in the repository.
  • Store the result ID in variable: Select a variable or Job Info in which an array of inserted or updated IDs will be placed. The array of IDs in the form of [1, 2, 3, 4, 2443, 532, 5457, ...]

On Error Tab

For a description of the options on the On Error tab see Using the On Error tab.

Miscellaneous Tab

The Miscellaneous 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.

The tab also provides an option to highlight the task in The Process area with the default color, set in the Preferences (see Colors), or the color selected or defined under Highlight color on this tab.
To revert the selected highlight color to the default color, open this tab, turn the Highlight option off and close the dialog with the OK button; then turn highlighting back on.
Highlighting can also be turned on and off via the task's contextual menu and with the Highlight button on the View ribbon.