Read Data from Relational Database Management Systems and Health Information Systems
Validate user-specified organisation unit ID or name.
Validate and retrieve program IDs
Convert numeric values into POSIXct,then into Date
Establish connection to a DHIS2 instance
Check whether the user-specified fields are valid
Get DHIS2 API version
Get all data elements from a specific DHIS2 instance
Get the attribute names and ids of the tracked entities
Get tracked entity attributes
Get event data from the newer DHIS2 versions (version >= 2.41)
Get event IDs for specific tracked entity
Transform the organisation units data frame from large to long format
Extract the DHSI2 organization unit's hierarchical levels.
Retrieve DHIS2 organization units, along with their IDs, names, parent...
Get the organization units from a specific DHIS2 instance
Get organisation units that are associated with a given program
Get program stages for one or more DHSI2 programs
get all programs from a given specific DHIS2 instance
Get the request query parameters for a specific API version
Get tracked entity attributes, their corresponding IDs and event IDs
Establish a connection to the HIS of interest.
Check whether the user-provided query is valid
Import data from DHIS2
Import data from relational database management systems (RDBMS).
Import data from SORMAS
Fetch all or specific rows and columns from a table
Make an SQL query from a list of query parameters
Convert R expression into SQL expression
Create a subsetting query
Display the list of tables in a database
Download the API specification file from SORMAS
Get case data from a SORMAS instance
Get contact data from SORMAS
Download SORMAS data dictionary
Get the list of disease names from a SORMAS instance
Get pathogen tests data from SORMAS
Get personal data of cases from a SORMAS instance
Check if the value for the base_url argument has a correct structure
Import Data from Relational Database Management Systems (RDBMS) and Health Information Systems ('HIS'). The current version of the package supports importing data from RDBMS including 'MS SQL', 'MySQL', 'PostGRESQL', and 'SQLite', as well as from two HIS platforms: 'DHIS2' and 'SORMAS'.
Useful links