Contents

On this page we collect migration issues that will still have to be looked at for a full migration to the Target Technology Stack .

REST API

• Impact:

  • Mobile Apps will not work any more

  • GOTHOMIS & Payment Layer in TZ

  • stuck to MS SQL because of stored procedures that are called from REST API (ca. 45)

• Discussion:

  • C#-part can be re-used, but depend on stored procedures

  • done - needs to be compiled for .net core per Windows and Linux (done in Docker)

  • Mobile App on REST

    • Need new mobile app on FHIR → budget needed

    • Mobile Strategy

  • ePayment on REST

    • migrate APIs to python = new adapter to payment switch → budget needed

  • Interoperability on REST

    • e.g. GOTHOMISs & afyacare

    • will remain on rest - will need to be done by GOTHOMIS & Afyacare

  • done - Added to Docker packaging

    • done - issue with env variables (ex. DB connection string)

    • done - sharing of files (ex. Insuree pictures)

  • rejected - Test REST API against PostgreSQL - not practical as REST-API will not be migrated on PostgreSQL

  • list of interactions with DB: https://docs.google.com/spreadsheets/d/1XdamXxLejmPRzM5xN8dCSPSIbfNv1PgJ/edit#gid=1496686413 - will not be needed after

  • create/modify payment layer adapter on the openIMIS side for TZ

Custom Modifications

• Impact: depends, will have to be collected per country by implementation partners

• push for customizations based on module configuration

Custom Modifications in Nepal

• a lot of custom functionality

• wip (tender in preparation as part of a general openIMIS maintenance contract)

Custom Modifications in Tanzania

• payment layer through REST API

• mobile apps on REST API

• specific reports: capitation payment, commission

• done - capitation payment configuration in Product

• done - batch run

  • done - capitation payment SP

  • done - batch run SP

Custom Modifications in Cameroon

HIV

• report on migration needs done by STPH (-> Implementers)

EDUCASH

• Cash-Transfer scheme => to be migrated to modular?

Custom Modifications in Gambia

• Cash-Transfer scheme is in progress of migration

Stored Procedures

• Impact: depends

• Discussion: need to list remaining stored procedures that will not be migrated

• https://docs.google.com/spreadsheets/d/18XxbBsPXvHrq7Enu7Bj02WpE1GiIaslNP1aMK6ECQcU/edit#gid=0

• done:

  • in modular version: everything needed was migrated either to Python (business logic) or PostgreSQL (a few small queries)

  • SPs for REST API will not be migrated - need to run on MS SQL (-> see there)

Lock Mechanism

• will need to be migrated to PostgreSQL?

• testing - PostgesSQL uses low isolation level by default - might solve the problem

• might not be needed

• wip

Legacy Offline Mode

• Impact: none

• doesn't work in legacy version, not used

• needs popping up but will have to be addressed as new features

MS-SQL Driver in Django

• Impact:

  • Custom Access to MS-SQL DB

  • affects JSON-B column access

  • hinders upgrade to Django 4

• Discussion:

  • only a problem as long as s.o. is using MS SQL

  • maybe there are new drivers

  • solved - there is an official MS driver for Django now

DB-Initialisation Script

• Impact:

  • new installations (new, empty DB) not yet using all attributes

  • migration script need to know DB version to adjust to all scenarios

• Discussion:

  • Database compatibility PostgreSQL & MS SQL Server

  • testing

  • done - DB - initialisation:

    • two separate INIT scripts for PostgreSQL & MS SQL available

  • done - legacy migration:

    • migration script for the legacy data available

  • done - future development will be against PostgreSQL

    • other DB will have to use Django Migration scripts to fork to their DB system (automatically through Django “make migration“ - might need manual adaptations)

    • documentation needed

Reports

• Report module

• wip - which reports still need to be migrated? which ones are still used?

Documentation How-To / Best-Practices of Migration

• https://openimis.atlassian.net/wiki/spaces/OP/pages/3312025601/Implementer+s+Checklist+for+Modular+Migration

Admin Tools

List of tools that make it easier for windows server admins to switch to linux/postgresql