mGramSeva - Rollout Dashboard

Objective

The purpose of the mGramSeva Rollout Dashboard Scripts to aggregate the data points from mgramseva DB and services for Rollout dashboard in Metabase.

Overview

mGramSeva Rollout Dashboard is a python script for pushing the data from the mGramSeva to a specific table in DB on a daily basis which can be loaded to Metabase and graphical dashboard built on top of this table in the Metabase.

Pre-requisites

Before you proceed with the configuration, make sure the following pre-requisites are met -

• Python 3.9

• mGramSeva DB

• mGramseva user details who has access to MDMS service API

• mGramSeva mdms service access

Key Functionalities

• Collecting the data on certain data points and inserting the data into the rollout dashboard table in the DB User Story with details of the data point: IFIX-485: [1.0.1] Rollout Dashboards on MetabaseQA SIGNOFF

Deployment Details

Please deploy the following build.

• rollout-dashboard-cronjob:develop-2a8d6a44-3

Integration

Integration Scope

mGramSeva Rollout Dashboard is not directly integrated with any of the services except this scripts fetch the data from the MDMS service and mGramSeva DB

1. Configure the username, tenantId and password of the user for which mdms service access is available on the environment specific yaml file in DevOps. Example below iFix-DevOps/mgramseva-qa.yaml at e471be940b88ccd8811b2dfb7a0e4187b0ec39cd · misdwss/iFix-DevOps

Steps to run locally

please follow the steps below

punjab-mgramseva/LOCALSETUP.md at master · misdwss/punjab-mgramseva

Loading to Metabase

The python script inserts the data into table “roll_out_dashboard“ in mgramSevaDb for every run, it cleans the old data and creates new data.

This table has to be loaded into the metabase by adding mGramSeva DB to the metabase.

​All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License