Multi-language Snapshot Table

EnterWorks supports multi-language attributes, which may have a value for each language EnterWorks has been configured to support. If a repository has multi-language attributes, and those attributes are defined as relational, and the repository has been configured to create multi-language snapshot tables, a multi-language snapshot table will be created for each language other than the default language.

To trigger a repository to create multi-language snapshot tables, using the EnterWorks Classic UI, edit the repository’s properties and check the repository’s Snapshot Language Support box. The multi-language snapshot tables will be created the next time the snapshot tables are rebuilt. (For instructions on editing a repository’s properties and rebuilding snapshot tables, see the EnterWorks 10 Administration Guide).

Category Attribute Snapshot Table

The category attribute snapshot table view is sometimes called the “vertical snapshot table”, because instead of the attributes making up the columns of the table, they make up the rows. They are arranged in this manner to allow the category attribute snapshot table view to overcome the database limitation of allowing only 1022 columns, thereby freeing EnterWorks repositories to have an unlimited number of category attributes in the snapshot tables.

To trigger the creation of a repository’s category attribute snapshot table, using the EnterWorks Classic UI, edit the repository’s properties and check the repository’s Create Category Attribute Snapshot box. The category attribute snapshot table will be created the next time the snapshot tables are rebuilt. (For instructions on editing a repository’s properties and rebuilding snapshot tables, see the EnterWorks 10 Administration Guide).

Open the CZ Vehicle Staging Repository's Properties for Editing

Set the Repository’s Snapshot Language Support Flag

The names of the multi-language snapshot tables will be suffixed with their language code. So if a repository is named:

Product_Staging

and EnterWorks has been configured with English as its default language and configured to support the French, German, and Spanish languages, the following multi-language snapshot tables will be created:

Product_Staging_fr

Product_Staging_de

Product_Staging_es

The Item_Staging Repository’s Multi-language Snapshot Table Views

The attribute’s value for the default language will be stored in the main snapshot table, while any values for the attribute’s non-default languages will be stored in their respective language-specific snapshot tables.

Unlike the main snapshot table view, which will have entries for each attribute that is defined as relational, the multi-language snapshot tables will only have entries for attributes that have a non-null value for that language.

The first few columns in the multi-language snapshot table are system bookkeeping columns. They are:

InternalRecordId: This is the ID of the repository’s record.
Created: When the repository record was created.
Last_Updated: The last time the repository record was updated for any reason, including validation.
Data_Last_Updated: The last date any attribute in the repository record was last updated.
Snapshot_Last_Updated: The last time the snapshot record was updated. This may not match the Data_Last_Updated value if a change is made to one of the repository record’s attributes that is NOT in the snapshot table or if the snapshot table has been regenerated.

The attribute columns follow the system columns. They are:

InternalRecordId: This maps to the InternalRecordId of the record in the repository. It can be used to join a multi-language snapshot table row to a row in the main snapshot table.
KeyName: The name of the attribute. This will exactly match the attribute name in the repository, which can be seen by viewing the repository’s profile or opening the repository in EnterWorks’s Detail Editor.
KeyRestrictedName: The restricted name of the attribute, as defined in the repository’s attribute definition.
KeyValue: The attribute’s value.
KeySequence: If a display sequence is set for the attributes in the repository, an attribute’s sequence value will be reflected in the multi-language snapshot table’s attribute’s KeySequence field.

When EnterWorks’s multi-language feature is being used, typically only a subset of attributes are multi-language. For instance, an item’s description and feature bullets might be multi-language, but the measurements are not.

To use SQL to access an attribute in a multi-language snapshot table, query the main snapshot table to get all the global attributes, including the default language attribute values, then query or join it with the desired multi-language snapshot table, using the internal record ID to get the attribute values for that same record.

For example, if English is the default language, to get an attribute’s French value, you would query the main snapshot table to get the global attributes, then query or join it with the French snapshot table, using the internal record ID to get the French attribute value.