5.12.12.16.5.4. Evaluation
Excel presentation

The Excel presentation happens on the base of CSV files.

Excel sheet "main"

Excel sheet "main"

  • The listing on the right (ViolationsDescriptions.csv) shows a subdivision according to the error groups basic, certified and premium. Each group points out what is missing in order to get the respective certification level.

    For each error code, the number of counts is displayed.

    When opening the single sections the affected article numbers are visible.

    Number of products in the single error codes

    Number of products in the single error codes

  • The bar chart (status.csv) shows the number of products in each status (representation as Pivot).

    Bar chart with distribution according to "Status"

    Bar chart with distribution according to "Status"

  • The pie chart (class.csv) shows the distribution according to ECLASS classes over all products included in the log (representation as Pivot).

    Pie chart with distribution according to ECLASS classes

    Pie chart with distribution according to ECLASS classes

In the Excel sheets "classe", "status" and "ViolationsDescriptions", you can see the table data which is used for the representation.

Example: ViolationsDescriptions

Example: ViolationsDescriptions

XML, Text and CSV files

In the user directory under "validator_reports", you can find all reports created during the generation. Each report includes the following directories and files:

  • The directory DETAILS contains text files with the specifically occurred error codes. Each single text file lists the articles, showing the respective error.

    The file name corresponds to the respective error code.

    The file name corresponds to the respective error code.

    Listing of article numbers in an error code file

    Listing of article numbers in an error code file

  • XMLREPORTS: Here, all reports are listed in the form of xml files (generated by the tool for batch verification "ECADPS3VERIFY"). When opening a file in any XML editor, you can see the information displayed in the dialog Extended ECLASS validation report, dialog area Report.

    XMLREPORTS -> xml file of a product (article)

    XMLREPORTS -> xml file of a product (article)

    Explanations on the single XML sections:

    • All sections ending with INFO or WARNINGS or INFORMATION, do not affect the final verification state of a part. These entries basically have information which could be helpful for the modeling process.

    • The section FUNDAMENTAL_ERRORS has entries indicating violations of the ECAD data model; such parts are not certified automatically.

    • PARTINFO -> message

      • PART7ASSY: Article number

      • PART MIDENT: MIDENT

    • PARTINFO -> message

      [Note]Note

      Datasets without CNSELEK are not considered for the statistic.

    • VERDICT: State of the product

    • VIOLATIONS: Error classes and error codes

      There are three types of VIOLATIONS:

      • Section PREMIUM_VIOLATIONS includes all entries preventing the part from getting the Premium state.

      • Section CERTIFIED_VIOLATIONS includes all entries preventing the part from getting the Certified state.

      • Section BASIC_VIOLATIONS includes all entries pointing out serious design errors; for such parts a successful export into the different ECAD systems is not ensured normally.

    [Note]Note

    In the dialog Extended ECLASS validation report, in the right dialog, you can see the same sections.

    Extended ECLASS validation report

    Extended ECLASS validation report

  • checkReport.csv: Includes information on the State and the article numbers, asked by the modeller to solve the problem.

    checkReport.csv

    checkReport.csv

  • The information from classe.csv, status.csv and ViolationsDescriptions.csv is presented in Excel. See above.