5.8.2.1.16.16.  Classification checker

The tool checks whether a catalog contains data able to be classified but not yet are.

If, for example, a catalog contains variables having a weight unit, it is quite obvious that this is the component weight.

The evaluation by this tool only displays faulty (or possibly faulty) columns/variables.

As incorrect the following is considered:

  • isCustomsTariff= true (11 digit number) & hasCNSCTN=false & hasCNSECCN=false

    An available number, but not being a 11 digit number is considered as "false".

  • hasCNSMASSEXACT = false & isWeight =true (it is checked, if a value is <=0; this results also in "false")

  • isClassified = false & isRangeValue=true

[Note]Note

The check is only related to the CNS classification.

The call is made on any directory/project under Automation.

In the Classification check dialog, enter a storage path and name for the output and specify the separator.

After successful export a respective message is displayed.

Exemplary result:

  • File: PRJ file name

  • ColumnName: Column name in table

  • isClassified: ColumnName is assigned to cns_* (is classified)

  • is ValueRange: ColumnName is a value range (yellow field)

  • isWeightUnit: The variable's unit is convertible to 'kg'

    If there is a classification according to weight, but the table does not contain a reasonable value (e.g. 0kg), then under "desc" "invalidWeight(<=0)" is displayed.

  • isCustomsTarif: Does the respective variable contains the CustomsTariff number?

    "true" is displayed if either hasCNSCTN or hasCNSECCN is "true".

  • hasCNSMASSEXACT: Is CNSMASSEXACT classified in the project?

  • hasCNSCTN: Is CNSCTN classified in the project?

  • hasCNSECCN: Is CNSECCN classified in the project?

  • mappedTo: Contains the currently mapped value and gives the hint that the set value is wrong (e.g. cns_CNSGEOMBASE_CNSMASSEXACT instead of cns_CNSPHYPROP_CNSMASSEXACT)

  • Desc = the set filter (some variables have 2):

    • no cns_CNSPHYPROP_CNSMASSEXACT & isWeight = No assignment in cns_CNSPHYPROP_CNSMASSEXACT and column unit is 'kg'

    • isNotClassified & isRangeValue = No assignment in cns_* and value range in table

    • isNotClassified & isNotRangeValue = No assignment in cns_* and no value range in table