Spazio selectors and filebox metadata management

There are many service tasks that operate on metadata classes and values. In Filebox, the pattern is usually that metadata classes are like groups. For each metadata class known and stored in a Fileset, there is one or more key/value pairs that contain the proper metadata name and value.

Metadata classes are stored in Filebox as database tables/views where every column is the name of the metadata belonging to that class, and the value as the database value itself.

This behavior is standard and is applied for the following known metadata classes:

1. "Generic Metadata" [SPFB_FILE_GENERIC_MD]

2. "eMail Metadata" [SPFB_MAIL_SYS_MD]

3. "Ghibli System" [SPFB_FILES_SYS_METADATA]

4. "Spazio2 file" [SPFB_SP2_FILE_SYS_MD]

But that is not the only existing behavior, so additional service tasks are needed. For example, the "Spazio2 selector" [SPFB_SP2_SEL_SYS_MD] metadata class contains all Spazio2 selectors that are written on a Fileset, if the trasport has occurred with Spazio2.

These selectors are not standard. They are stored in a database table or view. However, rather than having a column for each metadata item, the columns have a pattern, and each record contains metadata itself. Therefore, it is more than just a key/value pair.

File Service Registry - Get Metadata

This one operates in a way to let the user get a list of key/value pairs for all the elements stored in a Fileset once the desired metadata class is selected.

This task operates on the following metadata classes:

1. "Generic Metadata" [SPFB_FILE_GENERIC_MD]

2. "eMail Metadata" [SPFB_MAIL_SYS_MD]

3. "Ghibli System" [SPFB_FILES_SYS_METADATA]

4. "Spazio2 file" [SPFB_SP2_FILE_SYS_MD]

The operator in the flow designer will choose a class and a variable where results will be placed. If nothing more is specified, the resulting variable will be a list of MetaName/MetaValue pairs for all the elements present in that metadata class.

If the operator decides that the flow will return a single value, the "SingleValue" property will be configured with a MetadataName and doing so the resulting variable will only contain the MetaValue, null if not present, for that specific MetaName.

File Service Registry - Set Generic Metadata

This service task stores a Metadata Name and its specified value on a Fileset ONLY for the Generic Metadata Class [SPFB_FILE_GENERIC_MD].

Spazio2 - Insert Selector

This service task will be initialized with a FilesetID like the previous one and then with all the required fields to create a new selector. All the data must be filled in according to Sp2 standards for SEL_CODE possible known values (4100 - 500 - 2010) and so on.

1. AREA_TYPE

2. SEL_CODE

3. SEL_TYPE

4. SEL_LENGTH

5. SEL_NAME

6. SEL_VALUE

Refer to Sp2 official documentation for the possible values on real case scenarios.

Spazio2 - Get Selector

This service task will be initialized with a FilesetID. Since Sp2 selectors are not key/value pairs, the user must also provide the desired Selector Code to obtain its value in the desired output variable. The Selector Code is a mandatory field; the service task will not provide a list of all the selectors set on the Filesetin the output variable, only the value if it exists; otherwise, it will be null.

Spazio2 - Update Selector

This service task will be initialized with a FilesetID and selector code, as the previous one. Next, the Selector Value that needs to be updated is required.

This service task updates values; it will not insert anything if there are no selectors on the fileset with the specified selector code. Therefore, if no selector exists, use the "Insert Selector" instead of the "Update."

Example of how the value of a Spazio Selector is read into a variable

In this example, we are reading a spazio selector value into a variable named "selector" [ Output variable ]. We have to choose a selector code [ Spazio2 Selector code ]: 6200 in this example.