Specify Tags for eDNA Data Extraction Using a Blank Spreadsheet

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 manually by creating a configuration file. Alternatively, you can specify the tags using the utility, a template spreadsheet or a blank spreadsheet.

Procedure

  1. Create a Microsoft Excel file.
  2. Enter column names matching the names of the tag properties.
  3. 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.
    Note: If a message appears, stating that the .xml file is not linked to schema, ignore the message.
  4. Select Developer > Source > XML Maps > Add.
  5. Select the eDNAHistTagConfigSchema.xsd file located in the <installation drive>:\Program Files\GE Digital\Historian ETL eDNA Extract folder.
  6. Map each column name with each entry under Taglist in the XML Source section. To do so, select each column name, and then double-click the corresponding property under Taglist.
    Each property under Taglist changes to bold formatting, indicating that it is mapped to the corresponding column.
  7. For each tag, enter or modify values in the columns.
  8. Select Design > Properties, select the Validate data against schema for import and export check box, and then select OK.
  9. Save the file.
  10. Select Developer > Export.
  11. 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.
  12. 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.