Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
_Previous Version Note
_Previous Version Note

Metrics have metadata that the dashboard application uses to render the content of metric values in the user interface (UI). The Import Dashboard Types ETL package is a component in the solution that loads all the metrics required to display the dashboards from a set of comma separated values (CSV) files. This process enables licensees to manage metric metadata without modifying the database tables directly, as was required in previous versions of the Ed-Fi Dashboards.

Similar to the Import Ed-Fi Core Types and the Import Ed-Fi Descriptor ETL packages, the Import Dashboard Types package utilizes source files to import data into a database. This ETL package extracts information from a set of files that contain:

  • Metric names, types and definitions
  • Metric display hierarchy
  • Metric actions and drilldowns
  • Documentation, such as research and background, data mappings, visualization(s), business rules and implementation considerations

The Import Dashboard Types loads the metrics information from the following comma separated values (CSV) files:

  • DomainEntityType
  • Metric
  • MetricAction
  • MetricActionType
  • MetricFootnoteDescriptionType
  • MetricNode
  • MetricState
  • MetricStateType
  • MetricType
  • MetricVariant
  • MetricVariantType

The Import Dashboard Types package is included under the following path: \Ed-Fi-Core\Database\Data\Dashboard, whereas the CSV files are located on \Ed-Fi-Apps\Database\Data\Dashboard\metricsDb, and are available in GitHub.