Creatio development guide
PDF
This documentation is valid for Creatio version 7.10.0. We recommend using the newest version of Creatio documentation.

Bound data structure

Glossary Item Box

Introduction

Bpm’online comes with full multilanguage support since version 7.8. As a result, the storage structure of resources and bound data has been reworked.

Data binding specifics (compared to version 7.8):

  • A new SysPackageDataLcz table now contains localized bindings data.
  • A new mechanism for creating and installing bindings.
  • A new SVN data storing structure.

The SysPackageDataLcz localization table

An additional table is used for storing localized bound data:

Table 1. SysPackageDataLcz table columns

Column name Description
Id Unique identifier.
SysPackageSchemaDataId A reference to the unique binding identifier in the SysPackageSchemaData table.
SysCultureId Unique culture identifier reference.
Data Localized data.

ATTENTION

The binding mechanism interface is identical to that of the previous versions.

Creating a binding

If a schema does not contain localized columns, the bound data for this schema is still stored in the SysPackageSchemaData table. Data binding for a schema with localized columns:

  • The bound data is still stored in the SysPackageSchemaData table.
  • The SysPackageDataLcz table contains localized bindings data.
  • Every record in SysPackageDataLcz corresponds with a record in SysPackageSchemaData, with a reference to the unique SysCultureId identifier. For example, if two cultures (English and Spanish) are installed in the system, each entry in the SysPackageSchemaData table will correspond to entries in the SysPackageDataLcz table, with a reference to the corresponding record identifier in the SysPackageSchemaData table, and the culture identifier in the SysCulture table.

Installing bound data

Installing data for a schema without localized columns is done in the corresponding schema table. If the data includes any localized values (i.e. there are corresponding records in the SysPackageDataLcz table), the installation occurs not only in the corresponding schema table, but also in its localized Sys[schema_name]Lcz table.

For example, the bound data for the ContactType schema is installed. Non-localized data is installed in the ContactType table, and the localized data is installed in the ContactType table (default culture values), and the SysContactTypeLcz table (the values of all other cultures included in the binding and in the system).

ATTENTION

If you are working with a system schema (the name begins with the “Sys” prefix), then the “Sys” prefix is not re-added to the localization table. For example, if the schema name is SysTest1, the localized data table name will be SysTest1Lcz, and not SysSysTest1Lcz.

Storing data in SVN

The structure of storing the bound schema data in SVN for bpm'online version 7.8 and higher:

Fig. 1. SVN data storing structure

Non-localized data is stored in the data.json file. All localized data is located in the corresponding files in the Localization subdirectory. For example, for the Country schema of the Base package, the data is localized for only two languages and stored in the corresponding files - data.en-US.json and data.es-ES.json (Fig. 1).

 

 

© bpm'online 2002-2017.

Did you find this information useful?

How can we improve it?