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 new 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 solution.
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.