Deployment

Database

The gpi database must be linked to the project. Please refer to the linking a database section for more information about how to link a database.

dbt project specification

Update your cssXX.dashboards_store/dbt_project.yml file with the following snippet.

1. Enabling models and dashboards from the core repo

# cssXX.dashboards_store/dbt_project.yml
models:
  core_dashboards_store: # Enable the models from the core repo
    marts:
      educ_serv:
        +enabled: True
    dashboards:
      educ_serv:
        res_epreuves:
          +enabled: True
    interfaces:
      gpi:
        +enabled: True
      jade:
        +enabled: True

2. Setting the cod_css variable
   The cod_css variable is required to filter down the results fetched from the Jade tables and exclude students from other CSS. This variable MUST be set for the dashboard to work correctly.

# cssXX.dashboards_store/dbt_project.yml
vars:
  # res_epreuves's dashboard variables:
  dashboards:
    res_epreuves:
      cod_css: ###% -- The first three characters of your school board. Formatted as a SQL regex. E.g. '001%' for CSS001

Configuration

Adding local exams

• To add a list of local exams to track in the dashboard:
  1. Add a .csv file to your cssXX.dashboards_store/seeds/dashboards/res_epreuves folder. The file should be named rstep_epreuves_personnalisees. The file should contain the columns described in core.dashboards_store/seeds/dashboards/res_epreuves/schema.yml (which describes the seed rstep_epreuves_personnalisees).
  2. Trigger a refresh of your seeds

dbt seed --full-refresh

Adding ministerial data

• To add the regional and provincial unique exam data to the dashboard:
  1. You need to run the Charlemagne reports CHS040509R - Statistiques provisoires des résultats d'épreuves uniques for all the sessions of all the years you want to track in the dashboard.
  2. You must then save them in a single folder containing only these XML files.
  3. Use the file fichier_traitement.xlsm, which is located in the /analyses/dashboards/res_epreuves folder, to consolidate the various XML files from the different sessions into a single .csv file.
  4. Save the consolidated file in the folder cssXX.dashboards_store/seeds/dashboards/res_epreuves under the name fichier_consolide_epreuves_ministerielles.
  5. Trigger a refresh of your seeds.
  6. Repeat these steps to add the data for each session.