Create a data reader pattern - SmartPlant Foundation - IM Update 48 - 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)

You can associate a data reader pattern with a data tag discovery task to extract tags from a database. For more information on database tag discovery task, see Create a new database domain discovery task.

  1. On the Data Reader Patterns page, click Create Data Reader Pattern .

    SHARED Tip To create a copy of the data reader pattern from an existing one, select a data reader pattern and click Copy Data Reader Pattern Copy DRP.

  2. In the Create Data Reader Pattern dialog box, type a name and description for the new data reader pattern.

  3. Select the import definition from the Data Validator Import Definition list to map the csv file into the Data Validator application to create a task with the created data reader pattern and the Data Validator Job Definition.

  4. Type a class definition name in the Class Name box.

    The name of the objects that are created in the database as a result of the database domain discovery task, which uses this data reader pattern, use the format SPFN<Domain Name><Class Definition Name>. The domain name is obtained from the data connection, and the class definition name is obtained from the data reader pattern.

  5. Select a Data Connection from the list. For more information on creating data connections, see Manage data connections.

    • If you select Excel as a Data Connection, click Browse Excel File in the File Path, to select a Microsoft Excel file as the database.

    • The database domain discovery task creates relationships between the tags it creates and the documents attached to the file object (Microsoft Excel file) when the path to the Excel file used by the database domain discovery task and the path to the Excel file for which the document is created are the same. After the document to tag relationship is established, the Prevent Content Discovery property of the document is set to True, and the status is set to Document Processed.

  6. Click OK.