Skip to content

Customised OpenMRS ETL for Report Requirements in OpenSRP Projects

License

Notifications You must be signed in to change notification settings

opensrp/opensrp-scripts

Repository files navigation

opensrp-scripts

Customized Scripts for OpenSRP Projects

Concept Constants Dictionary:

  • Location Concept ID: 163531
  • Place of Birth Concept ID: 16650
  • Date of Encounter Concept ID: 163138
  • Lives outside of catchment area Concept ID: 160636

Encounter Types Constants Dictionary

  • Birth Registration encounter type ID 1
  • Growth Monitoring encounter type ID: 2
  • Vaccination encounter type ID: 4

Patient Identifier's Constants Dictionary

  • ZEIR ID: 17
  • M_ZEIR ID: 18

Person Attribute Type Constants Dictionary

  • Child Register Card Number ID: 20

OpenMrs Concepts

How to use files inside openmrs-concepts

  • openmrs_concepts_{date-created}.sql this is fully tested openmrs_concepts dump which works in openmrs version 2.1.4
  • concept_migration_{date-created}.sql this script should only be used after import of a openmrs concept db dump from openmrs forum which causes conflicts with the entity models of openmrs.war

Notes

  • There is a high probability that the encounter date may be different from the vaccination date in the case where the vaccination date has time values. This has the potential of breaking the update vaccine data sql script

Travis encryption script

This script helps in encrypting a file using Travis CI. The -f flag specifies the file path and the -t flag specifies the github token to use when logging into Travis.

The syntax is : ./travis-encrypt.sh -f <file-path> -t <github-token>.

The github token has to be valid and have all the required permissions listed here.

About

Customised OpenMRS ETL for Report Requirements in OpenSRP Projects

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages