Configure basic attributes
censhare saves basic features for every asset in the asset table of the SQL database. These include asset type, name, ID, and others.
Context
Asset features are configured in the censhare Admin Client.
Prerequisites
You must be familiar with the data model of assets.
Introduction
When a new feature is added to the database, censhare carries out two steps. First, censhare creates a generic feature in the SQL database. Second, censhare creates an index in the censhare database (cdb) that allows to search for the feature.
censhare treats basic features differently because they are already known to the SQL database. Attributes are stored in the root element of the asset XML. If an attribute references an XML attribute is selected, censhare looks up the values in the referenced database table.
Configure attributes
The recommended method to create an attribute is to create an entry for the feature in the features table in the censhare Admin Client. This indexes the feature in the cdb. For this configuration, enter the data table reference in the XML attribute field.
Alternatively, you can add a column to the asset table in the SQL database. This method is not recommended.
Asset XML
Other than asset features, attributes are stored in the XML root element of the XML representation of an asset:
<asset id="20801"
type="text."
name="Editorial">
<asset_feature feature="censhare:font.family"
value_string="Helvetica" />
</asset>
1. The XML attributes "id", "type" and "name" are saved in the root element <asset>. A column is created in the asset table of the SQL database for each of these attributes. The assignment of attributes to a column is done using mapping entered into the "attribute_mapping" field. To do that you have to select the entry "Attribute" in the "storage" field.
2. In the asset element a feature is created that is represented by the <asset_feature> element. The feature name and value are XML attributes in this element.
3. Asset XML structures are displayed in a very simplified fashion. Other attributes and XML elements were left out in order to make everything clearer.