Metavist: Entity & Attribute information: Excel or CSV files

In this example, we explore how you would enter information into Metavist if you had three Excel files (and/or CSV - exported Excel) to describe in your metadata record.

The example data set we will use here is the data templates from BSIERP project B92.

In this example, an excel file may be delivered with the following information. Certain assumptions about the data set have been made for illustrative purposes. This example shows how Attributes can be re-used for each of the three worksheets.

Worksheet: transect

Attributes Domain Values
Institution Enumerated: Institution
Study area Unrepresentable: string
Day or night Enumerated: daynight
Substrata Unrepresentable: string
Cruise Unrepresentable: integer
Transect Range: min=1 max=15
Latitude Range: min=0 max=90.0
Longitude Range: min=0 max=-180.0
Local date Unrepresentable: string format: YYYYMMDD
Time Range: min=0 max=24.0

Entering this table into Metavist

  • Add Entity Type: transect | [after adding]
  • Add Attribute: Institution | [after adding]
    NOTE: The Attribute Definition Source in this throughout this example is the same. However, the columns draw from other sources, that source should be defined here.
  • Select transect in Entity Types, then press the arrow key just to the right of the drop down and under' Select elements. This will add transect to the Root window. Select Institution in Attributes, then press the arrow just to the right of it. This will add Institution to the Branch window. Then press the Attach button. This will link Institution as and entity attribute for transect. [image]
  • Press Clear fields.
  • Add Domain Value: Institution | [after adding]
  • Select Institution in Attributes and click the arrow to add it to the Root window. Select Enumerated: Institution in Domain Values and click the arrow to add it to the Branch window. Then click on Attach. This will link the domain value to the attribute. [image]

Worksheet: prey_abundance

Attributes Domain Values
Institution Enumerated: Institution
Study area Unrepresentable: string
Day or night Enumerated: daynight
Substrata Unrepresentable: string
Cruise Unrepresentable: integer
Transect Range: min=1 max=15
Species name Unrepresentable: string
Mid-point depth interval (m) Unrepresentable: number
Biomass density (mt nmi-2) Unrepresentable: number
Energy density (tJ nmi-2) Unrepresentable: number
Number density (# nmi-2) Unrepresentable: number

Entering this table into Metavist

  • documentation

Worksheet: predator_abundance

Attributes Domain Values
Institution Enumerated: Institution
Study area Unrepresentable: string
Day or night Enumerated: daynight
Substrata Unrepresentable: string
Cruise Unrepresentable: integer
Transect Range: min=1 max=15
Species name Unrepresentable: string
Number density (# nmi-2) Unrepresentable: number

Entering this table into Metavist

  • documentation