Specify Tags for eDNA Data Extraction Using a Template

About this task

Before you extract data, you must specify the tags whose data you want to extract.

This topic describes how to specify the tags using a template spreadsheet, which is provided with the Historian ETL package. Alternatively, you can specify the tags using the utility, using a blank spreadsheet, or by creating a configuration file manually.

Procedure

  1. Access the eDNAHistTagConfigGenerateExcel.xlsx file located in the Historian eDNA ETL Extract folder.
  2. Optional: If you want to modify an existing tag configuration file, you can import the data from that .xml file by selecting Developer > Import.
    Tip: If the Developer tab is not available, right-click the menu bar of the spreadsheet, select Customize the Ribbon, and then select the Developer check box.
    Data from the .xml file is imported into the spreadsheet.
    Note: If an error occurs, stating that the data is not valid according to the schema, verify that:
    • You have provided values in all the red-colored columns.
    • There are no blank rows.
    • The values that you have entered are valid and of the same data type as defined for each property.
    For details, refer to Tag Properties.
  3. For each tag, enter or modify values in the columns for the tag properties. A value is required in the red-colored columns.
  4. Save the file.
  5. Select Developer > Export.
    Tip: If the Developer tab is not available, right-click the menu bar of the spreadsheet, select Customize the Ribbon, and then select the Developer check box.
  6. Enter a name and location for the .xml file.
    The tag configuration file is created with the list of tags and their properties to be extracted.
    If an error occurs, stating that the data is not valid according to the schema, verify that:
    • You have provided values in all the red-colored columns.
    • Values in the Name column are unique.
    • There are no blank rows.
    • The values that you have entered are valid and of the same data type as defined for each property.
    For details, refer to Tag Properties.
  7. In the HistorianETLeDNAExtractConfigTool file located at <installation drive>\Program Files\GE Digital\Historian ETL eDNA Extract, select Files, and then in the Tag Configuration File field, provide the path to the configuration file that you have created, and then select Save.
    The tag configuration file is specified.

What to do next

Configure the eDNA Data Extraction settings.