The ELO post-processing step allows you to store attributes and files from Forms in ELO.

Result of the ELO post-processing

MODE: Create

• A new folder in ELO is created

• the folder mask is assigned to the folder

• the mask attributes are assigned to the folder

• the map field attributes are assigned to the folder

• Attachments are uploaded as child Elements to the folder

• the file mask is assigned to each uploaded attachment

• if configured: a workflow is started

MODE: Update

• Updates an existing folder in ELO - identified by ObjectID or GUID

• If a folder mask is configured: an updated folder mask is set

• If a path is configured: moved the folder to the new location (including all subfolders/files)

• If a folder name is configured: updated the folder name

• Update the mask attributes: new values are added. If a value already exists, it will be overwritten. Old values that are not overwritten will stay

• Update the map field attributes. new values are added. If a value already exists, it will be overwritten. Old values that are not overwritten will stay

• Attachments are uploaded as child Elements to the folder

• the file mask is assigned to each uploaded attachment

• if configured: a workflow is started

MODE: Delete

• A single Sord Object in ELO is deleted - identified by ObjectID or GUID

Summary of naming conventions in ELO

Sord

A sord in ELO is any object. This can be a Folder, File, …

Folder

The Folder in ELO is a container that

• has ONE assigned Folder mask

• has N mask attributes (map-like key-value pairs) - also called objectkeys. These are directly connected to the assigned Folder mask. e.g. A Folder with the mask ‘invoice' has a mask attribute ‘invoice number’ but no attribute ‘birthday’.
  The mask attributes are String values only with a maximum length of 255 characters.

• has N map field attributes (map-like key-value pairs) - in ELO they are shown in the tab ‘Additional Infos’. They are used in various Business Solutions and Forms. Each attribute has an assigned domain (objekte, formdata, ...) and a type (string or blob). The type string is limited to a maximum length of 255 characters.

• has N child elements

  • other Folders

  • Files

File

These are actual BLOB files like JPG, PDF, …

They have:

• ONE assigned File mask

as well as

• N mask attributes

• N map field attributes

However, Portrait only allows setting the file mask. Attributes are only supported to be stored in the folder.

Detailed process description

MODE: Create

The creation process is done in the following order

• User submits Form

• Handlebars are applied, see order below

• Validations

  • Validation of Mask attributes - fieldProcessor + dialog "fields": [{...}]

  • Validation of Folder mask - mask

  • Validation of File mask - fileMask

• Folder is created or copied - according to path,folderName and sourcePath

• Folder mask is set

• Mask attributes are set

• Map fields are set

• Attachments, with the correct File mask, are uploaded

• Workflow is started

Validation of Mask attributes

Checked:

• Each mask attribute value can only contain max 255 characters.

Not Checked:

• The mask attribute is available in the folder mask. In this case, the attribute is ignored and not written to ELO.

Validation of Folder/File mask

Checked:

• If the configured mask is allowed to be set to a Sord of the type folder/file

MODE: Update

Same as in the CREATE mode. However, not all configurations are required.

• Path: if empty the folder won’t get moved and stays on the same path

• folderName: if empty the folder won’t get renamed.

MODE: Delete

• User submits Form

• A single Sord Object in ELO is deleted - identified by ObjectID or GUID

Configuration for MODE: CREATE

Mask Attributes

There are two methods to configure which Mask attributes are selected to be written:

• 1:1 mapping of the dialog field names. In Mode LOOSE this happens automatically, in STRICT not.

A mask attribute with the key ‘damaged_person_first_name’ is selected.

• fieldProcessors

A mask attribute with the key ‘CM_WA_COMPANY’ is selected.

The attributes are only marked to be written. At runtime, it is determined if the keys are available to be written for the configured folder mask. If some attributes are not available to be set for this mask they are simply ignored and not written.

The methods can also be combined:

Now 3 values will be marked to be written:

• damaged_person_first_name

• damaged_person_last_name

• CM_WA_FULLNAME

Map Attributes

Map attributes can be configured via the maps YML parameter

At runtime, the list domains and types are grouped together. For each domain and type the data is written separately.

Handlebars

The handlebars support the usage of the form parameter. In addition, we provide the following use of parameters from the user that submitted the form:

During the form submission, the handlebars are applied in this order:

1. Fieldprocessors

2. onSubmit.path, onSubmit.folderName

Therefore the result of the field processes can influence the onSubmit config.

Example ELO post-processing in Portrait

Example configuration:

Open

Overview of the newly created Folder 'Mod2 - Löscheinsatz - 2023 …' in ELO.

Open

The map attributes are also set according to the configuration. Notice that CM_WA_DESC is a blob field and therefore not shown in the UI of ELO. The domain of the map attribute is also only visible in the SQL database.

Configuration for MODE: UPDATE

Example ELO post-processing in Portrait

Example configuration:

Config for Dialog

Configuration for MODE: DELETE

Basic Example:

Config for Dialog

Improved Security: Scope (Strict / Loose)

A Parameter scope can be added to the onSubmitconfiguration element.
This can either be STRICT or LOOSE

STRICT:

When the scope isSTRICT

• Only configured fieldProcessors and map fields are written to ELO. Fields from dialog will NOT automatically passed along.

For Mode Update/Delete there are additional requirements and checks:

Required Config for Mode UPDATE/DELETE:

• The source: vacations parameter needs to be set → this is the sectionID of the referenced section

Additional Checks

The Update/Delete is now bound to a specific Portrait Entry (which itself is bound to an ELO Sord).

• If the referenced entry (unique by: <sectionID>/<entryID>) does not exist the operation will be cancelled.

• The ELO Guid/SordId will be read from the indexed portrait entry.

LOOSE (default)

When the scope isLOOSE

• All fields from the dialog will be automatically be written to the ELO mask if the name matches a mask field in ELO.

• In case of UPDATE/DELETE the ELO GUID/SordID from the form will be used

Troubleshooting

If you encounter some issues, look in the portrait backend log file. Watch out for error messages directly from ELO, which is logged during the process.
Example:

[TICKET:0ACDA9...][Die Maske Verkauf kann nicht für Ordner verwendet werden.]

The entire process is non-atomic, which means that in the case of an error, some data might have already been written to ELO. Some actions are required to classify the post-process step as a success, while others are not. Here is an overview: