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

1. 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 follow in the dashboard:
  1. Add a .csv file in your cssXX.dashboards_store/seeds/dashboards/res_epreuves folder. The file should be named rstep_epreuves_personnalisees. The file should be filled with 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 exams data to the dashboard:
  1. You need to run the Charlemagne reports CHS040509R - Statistiques provisoires des résultats d'épreuves uniques of all the sessions for all the years you want to follow in the dashboard.
  2. You must then save them in a single folder where there would be only these XML files.
  3. Use the file fichier_traitement.xlsm, which is located in the folder (/analyses/dashboards/res_epreuves) 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. Redo the steps to add the data for each session.