How can we transform event data and client data into readable form for analysis of the data?

Created user,location and assign team from dashboard must reflect in openMRS

We need to add the standard license to this repository.

BD-Family-Planning data transfer into postgres for MIS1 report generation

Sub Tasks Under This Issue:

• Transfer Data from CouchDB to PostgreSQL (Creating Different Entity classes, Services and Repositories, implementing utilities, resolving related issues)
• Writing Raw SQL Queries for each field of MIS Report (Around 150 SQL queries)
• Writing Web Services for fetching JSON
• Writing Procedure to produce a final table to get counts of each forms field values of MIS Report
• Producing the Final MIS Report
• Future Improvement Issues

• Analyzing existing table client, event and their json data column

• Searching for process to convert json column to other format of data and study their implementation for example: json_each(json), jsonb_array_elements_text(jsonb), etc.

• Study Materialized view.

• Finally convert the data to table view so that can be directly loaded to visualize Charts form in GUI and sql deployments.

• Show view data in GUI

Some visit code showing in both pending and completed views, which should be corrected. Some visit code showing more than once that also need to be corrected.

If any user sync data from Tab with late submission and by this time another schedule generated with another alert status in action table, some mismatch happened in data. To solve this, action data correction needed.

Transfer and convert event-client data from couchDB to postgres

Accessing opensrp data from third party tool like Tableau, Pentaho and creation of dynamic report for field activity monitoring of openSRP projects.

• Adding functionality for user role and permissions.

• Password authentication for login

• Password Encoding during registration and authentication

• Registration: validation of fields, email verification, matching passwords, etc.

Show scheduled, completed, expired and percentage of expired Count report form wise and provider wise

• form wise report

• provider wise report