ETIM classification¶
From version 3.8.3
This page describes behaviour available from client version 3.8.3. Sites on an earlier version do not have it yet.
ETIM is the international standard for classifying technical products. It sorts products into classes (such as a fire sealant), gathers classes into groups, and gives each class a fixed set of features (colour, fire resistance, temperature range and so on). Each feature has a type:
| Type | What a product gives for it |
|---|---|
| A (alphanumeric) | One value from the list the class allows, such as White |
| L (logical) | Yes or no |
| N (numeric) | A number, in the unit the class sets for that feature |
| R (range) | A from and a to, in the unit the class sets |
Any feature can also be marked not applicable to a product.
From version 3.8.3 each product can carry one ETIM class and a value for each of its features. The values are checked against the ETIM model as they are entered or loaded.
Releases¶
The ETIM model is published by ETIM International in numbered releases
(9.0, 10.0 and so on) and is licensed. It is held once and shared by every
site. eBiz staff load a release on the Product Template page
(/pim/template, the ETIM panel) from the release files, as a .zip of
its tables or one spreadsheet with a sheet per table. The panel shows each
release loaded, how many classes, features and values it holds, and the
progress of a load that is running. Loading the same release and language
again replaces the earlier load. A release can be removed unless it is the
only one that products are classified against.
A site uses the newest release unless its settings name one
(pim.etimVersion, and pim.etimLanguage, default EN). If the named
release is not loaded, the newest is used instead.
Until a release is loaded, class, feature, value and unit codes are kept as given and checked only for their form: EC, EF, EV or EU followed by six digits. They are checked properly once a release is loaded.
On a product¶
The product's ETIM tab shows its class and group, and each feature of the class in the class's order with its value. A user with the edit role can:
- Choose a class or Change class, searching by name or code. When the class changes, values for features the new class does not have are removed.
- Edit features: a list for A features, yes or no for L, a number for N and a from and to for R, each with its unit, and a N/A box. Nothing is saved if any value is wrong; the wrong ones are shown against their feature.
The product's ETIM class is also kept in its ETIM class field, so screens and searches that use that field see it. Every change goes to the product's history.
In the template workbook¶
The template's ETIM tab has one row per feature: the product keys, then the group, class, feature, value and unit codes, each with its description.
- Loading a filled-in workbook sets each product's class from its rows
and checks every feature against it. A value can be given as its code or
its description. A number is given in the class's unit; a row that names
a different unit is refused. A range is written as
10 - 20.NAor-means not applicable. Features not in the file are left as they are. Every refused row is listed in the load report by tab, row and column. - Downloading the template with products writes one row for each feature a product has.
- The gaps download lists, for each product whose ETIM data is not complete, one row for each feature it still lacks, named and with its unit, with the value cells highlighted. A product with no class gets one highlighted row for its class.
Data Level 5¶
Data Level 5 (Standardised) needs full ETIM classification. Where the template version makes the ETIM class and feature columns needed for Level 5, a product reaches it only when its class is in the loaded release and every feature of the class has a value or is marked not applicable. The product's Template tab and the gap report show how many features are filled.