Data Repository Manager

The Data Repository Manager is an interface that manages the OL Connect Workflow Data Repository. This feature, introduced in version 8.5, is a persistent data store used to save any sort of textual data in a table format.

Accessing the Data Repository Manager

To access the Data Repository Manager:

  • Open OL Connect Workflow.
  • Go to the Tools tab.
  • Click the Data Repository Manager button in the Managers group.

Caution: Any change made within the Data Repository Manager is Immediate, and Irreversible. Deleting data from this interface may impact running processes if such processes access the data saved in the repository. This includes clearing a group, or clearing the repository.

Toolbar buttons

  • Group section
    • Add Group: Click to create a new group. Enter the group name and click OK.
      Three keys will be added to the group automatically: ID, DateC and DateM . These keys cannot be removed or edited.
      • ID is a unique number that identifies a key set in the Data repository.
      • DateC is the creation date of the key set.
      • DateM is the date at which the key set was last modified.
    • Delete Group: Click to delete the currently selected group. Warning: This action cannot be undone.
  • Key section
    • Add Key: Click to add a key to the currently selected group. Enter a key name and click OK. If adding a key to a group with existing data, the key will be empty for all existing key groups.
    • Delete Key: Click to remove the currently selected key in the group. This will remove the key and all the data for this key in each existing key set. Warning: This action cannot be undone.
  • Key Set section
    • Add Key Set: Click to add a new key set to the currently selected group. Displays a dialog with all the keys in the group, asking for a value for each of the keys. Enter the values then click OK. The key set will display in the right part of the repository manager.
    • Delete Key Set: Click to delete the currently selected key set in the Group. Warning: This action cannot be undone.
  • Update section
    • Edit Key Set: Click to edit the currently selected key set. Opens a dialog which each key and their value, which can be edited. Double-clicking a row has the same effect as clicking the Edit Key Set button.
    • Refresh: Click to load any changes made to the repository since it was last opened or refreshed.
  • Management section
    • Check Repository: Click to verify the integrity of the database, as well as reclaim any disk space from
    • Clear Group Data: Click to delete all the key sets in the currently selected group, leaving the key definitions intact. Warning: This action cannot be undone.
    • Clear All Data: Click to delete every key set of every group in the Repository. Warning: This action deletes all your data and cannot be undone.
    • Clear Repository: Click to delete every group in the repository, including all their data. Warning: This action deletes all your data and cannot be undone.
  • Show/Hide System Keys: Click to show or hide the ID, DateC (creation date) and DateM (modification date) keys. The creation date and modification date fields both contain a full time stamp in the form of YYYY-MM-DDThh:mm:ss.sZ, where
    • YYYY = four-digit year
    • MM = two-digit month (01=January, etc.)
    • DD = two-digit day of month (01 through 31)
    • T = literal constant separating date from time
    • hh = two digits of hour (00 through 23) (am/pm NOT allowed)
    • mm = two digits of minute (00 through 59)
    • ss = two digits of second (00 through 59)
    • s = one or more digits representing a decimal fraction of a second
    • Z = literal constant representing the UTC time zone designator.

Repository structure pane

This section of the Data Repository display a tree view of all groups in the data repository as well as all the keys under each of those groups.

  • To add, delete or edit a group, use the contextual menu (right-click).
  • To expand a group and edit its keys, click the + or double-click on the group .
  • To rename a key, select it and then press F2.

Key Sets pane

This section of the Data Repository displays the current key sets in the group. Each horizontal row is a key set, and each vertical row is a key defined in the group.

  • To add, edit or delete a value in a key set, double-click on the field, or select it and press F2. The Edit Key Set dialog will appear. Use the arrow buttons to browse through the keys in the key set.
  • To delete a key set, press the Del key.
  • To add a key set, press Insert. The Add Key Set dialog will appear. Use the arrow buttons to browse through the keys in the key set and add values to them. This dialog has a button at the bottom to add another key set.

Though of course the mouse is the easiest way to navigate through the Data Repository, the keyboard can be used as well.

  • Press Tab to switch between the Repository Structure, Group Key Sets, Lookup Function Syntax and the Close and Help buttons.
  • Press CTRL+N to add a new key within the selected group.
  • Press Ctrl+G to add a new group.
  • Press Insert to add a key set. The Add Key Set dialog will appear, allowing you to create a new key set.
  • Press F2 to rename a group or a key on the Repository Structure pane.
  • Press Delete to remove a group or key from the Repository, or a key set from the Key Sets pane.

Tip: You can look up these shortcuts by right-clicking the item you want to interact with, and looking at the contextual menu.