Understanding the Data Capture Document Quality Control report - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

The Data Capture Document Quality Control report displays a list of processed documents. It provides a detailed report on the processed documents that have missing document attributes, missing relationships with the corresponding objects in the database, and also document attribute and document relationship mismatch.

The following graphic shows the Data Capture Document Quality Control report generated for three processed documents.

1

Red text without a comment represents that a document attribute exists but corresponding database object does not exist in the HxGN SDx database.

2

Cell highlighted with yellow represents that either the document attribute or the document relationship is missing.

3

Cell highlighted with pink represents a mandatory relationship without attribute value.

4

Red text with a comment represents that there is a mismatch between the document attribute and document relationship. The database object to which the document is related is displayed as a comment in that cell.

You can configure the SPFNDocReportQC view definition to view additional attributes of each document in this report. For more information about defining view definitions in the SmartPlant schema, see Create a View Definition.

Working with the Data Capture Document Quality Control report

You need to update the macro for the Data Capture Document Report QC to run the report with additional document attributes.

  1. Click Find > Template Documents.

  2. Type *Data Capture Doc Report QC Template* in the search box, and click OK.

  3. Right-click the template document.

  4. On the shortcut menu, click Edit > Check Out to check out the excel template file.

  5. Open the template file and press ALT+F11 to open the macro editor. Alternatively, you can click View > Macros, then select ReformatData and click Edit.

  6. In the Project - VBAProject window, expand the Modules node.

  7. Double-click the Module1 node. Let us consider adding a document attribute "Folder" as a document attribute "SPFNDocParameter1" and update the macro to generate the report with it.

    The image below illustrates the macro file.

    1. Add the following lines just below this line - Call AddNameToHeaderCell ("K", "SPFNProject")

      ' Compare Folder

      '

      Call Compare(12, 13, True)

      '

      ' Add name to the Folder header

      '

      Call AddNameToHeaderCell("M", "SPFNDocParameter1")

    2. And add the following line above this line: DeleteColumn ("L") ' Delete Project relation column

      DeleteColumn ("N") ' Delete Folder relation column

  8. Click File > Save.

  9. Open SmartPlant Foundation.

  10. Right-click on the template document.

  11. On the shortcut menu, click Edit > Check In to check in the Excel template file.