DWAPI

To upload data to the national Data warehouse you need a good internet connectivity. Make sure the internet connection is stable to complete upload.

Checks to perform when you encounter this error;

• DWAPI configurations
• Confirm if all tables have been created in DWAPI database; if incomplete, use below scripts to recreate DWAPI tables;
• Log into mysql by typing mysql -uroot -p
• Enter the correct MySQL password
• Drop dwapi database using script below;

drop database dwapi;

• Verify server on dwapi dashboard and save

Open terminal and run scripts below;

sudo docker stop dwapi

sudo docker start -i dwapi

sudo docker restart dwapi

• Reload the page on the browser and click “Verify database” and save

NB: Verify that the DWAPI version is compatible with the KenyaEMR version you are currently using.

• Navigate to configurations tab in dwapi and select EMR configurations.
• Select the default EMR which you intend to connect to.
• Navigate to the EMR endpoints section and input settings corresponding to your database.
• Follow the link below to access resources on correct DWAPI setup:

Follow this link  to access materials on DWAPI data transmission:

Link:

Follow the following link to access installation and configuration materials on DWAPI installation and configurations on Windows environment:

Link:

You need to be able to install DWAPI app on Ubuntu for data transmission from KenyaEMR system. DWAPI is installed through a Docker container on Ubuntu. The following link gives you access to resources  on how to install DWAPI on Ubuntu 16.04LTS :

https://hub.docker.com/r/kenyahmis/dwapi

Differential data upload into National Data Warehouse is now possible with DWAPI tool. Differential upload is where a facility only uploads new records that were created/updated since the last successful DWAPI upload. This technology largely saves time and internet resources.
For the technology to work effectively, the flowing conditions have to be met:

1. A facility has to Send All data at least once before using the differential feature in subsequent uploads. This applies also to new KenyaEMR and DWAPI installations and Reinstallations.
2. ETL has to be recreated prior to extracting data into DWAPI
3. For offsite (boardroom) DWAPI uploads, ETL table MUST be recreated prior to data extraction into DWAPI.

The following steps will help you solve this issue;

• Log into KenyaEMR
• Click ETL Admin
• Recreate ETL tables
• Re-load data from EMR in DWAPI and confirm if the buttons are active

If DWAPI fails to load on the browser;

• Clear browser cache and reload DWAPI page
• Confirm that the DWAPI service is running

sudo docker status dwapi [ENTER]