Skip to content

readepi

Read Data from Relational Database Management Systems and Health Information Systems

v1.0.4 · Jan 29, 2026 · MIT + file LICENSE

Description

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'.

Downloads

208

Last 30 days

21861st

21.6K

Last 90 days

69K

Last year

Trend: -98.1% (30d vs prior 30d)

CRAN Check Status

2 ERROR
3 NOTE
9 OK
Show all 14 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc ERROR
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-macos-arm64 ERROR
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 NOTE
r-oldrel-macos-x86_64 NOTE
r-oldrel-windows-x86_64 NOTE
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK
Check details (5 non-OK)
ERROR r-devel-linux-x86_64-debian-gcc

re-building of vignette outputs

Error(s) in re-building vignettes:
  ...
--- re-building ‘design_principle.Rmd’ using rmarkdown
--- finished re-building ‘design_principle.Rmd’

--- re-building ‘install_drivers.Rmd’ using rmarkdown
--- finished re-building ‘install_drivers.Rmd’

--- re-building ‘query_parameters.Rmd’ using rmarkdown
--- finished re-building ‘query_parameters.Rmd’

--- re-building ‘readepi.Rmd’ using rmarkdown

Quitting from readepi.Rmd:167-175 [unnamed-chunk-10]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<error/httr2_http_500>
Error in `httr2::req_perform()`:
! HTTP 500 Internal Server Error.
---
Backtrace:
    ▆
 1. └─readepi::login(...)
 2.   └─readepi::dhis2_login(...)
 3.     └─httr2::req_perform(...)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Error: processing vignette 'readepi.Rmd' failed with diagnostics:
HTTP 500 Internal Server Error.
--- failed re-building ‘readepi.Rmd’

<pool> Checked-out object deleted before being returned.
<pool> Make sure to `poolReturn()` all objects retrieved with `poolCheckout().`
SUMMARY: processing the following file failed:
  ‘readepi.Rmd’

Error: Vignette re-building failed.
Execution halted
ERROR r-devel-macos-arm64

re-building of vignette outputs

Error(s) in re-building vignettes:
--- re-building ‘design_principle.Rmd’ using rmarkdown
--- finished re-building ‘design_principle.Rmd’

--- re-building ‘install_drivers.Rmd’ using rmarkdown
--- finished re-building ‘install_drivers.Rmd’

--- re-building ‘query_parameters.Rmd’ using rmarkdown
--- finished re-building ‘query_parameters.Rmd’

--- re-building ‘readepi.Rmd’ using rmarkdown

Quitting from readepi.Rmd:87-98 [unnamed-chunk-3]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<error/rlang_error>
Error in `.local()`:
! Failed to connect to database: Error: TLS/SSL error: self-signed certificate in certificate chain
---
Backtrace:
     ▆
  1. └─readepi::login(...)
  2.   └─pool::dbPool(...)
  3.     └─pool::poolCreate(...)
  4.       └─Pool$new(...)
  5.         └─pool (local) initialize(...)
  6.           └─private$createObject(error_call = error_call)
  7.             └─private$factory()
  8.               ├─DBI::dbConnect(drv, ...)
  9.               └─RMySQL::dbConnect(drv, ...)
 10.                 └─RMySQL (local) .local(drv, ...)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Error: processing vignette 'readepi.Rmd' failed with diagnostics:
Failed to connect to database: Error: TLS/SSL error: self-signed certificate in certificate chain

--- failed re-building ‘readepi.Rmd’

SUMMARY: processing the following file failed:
  ‘readepi.Rmd’

Error: Vignette re-building failed.
Execution halted
NOTE r-oldrel-macos-arm64

installed package size

installed size is  6.3Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb
NOTE r-oldrel-macos-x86_64

installed package size

installed size is  6.3Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb
NOTE r-oldrel-windows-x86_64

installed package size

installed size is  6.2Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb

Check History

ERROR 10 OK · 3 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 30, 2026
ERROR r-devel-macos-arm64

re-building of vignette outputs

Error(s) in re-building vignettes:
--- re-building ‘design_principle.Rmd’ using rmarkdown
--- finished re-building ‘design_principle.Rmd’

--- re-building ‘install_drivers.Rmd’ using rmarkdown
--- finished re-building ‘install_drivers.Rmd’

--- re-bu
...[truncated]...
led to connect to database: Error: TLS/SSL error: self-signed certificate in certificate chain

--- failed re-building ‘readepi.Rmd’

SUMMARY: processing the following file failed:
  ‘readepi.Rmd’

Error: Vignette re-building failed.
Execution halted
NOTE r-oldrel-macos-arm64

installed package size

installed size is  6.3Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb
NOTE r-oldrel-macos-x86_64

installed package size

installed size is  6.3Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb
NOTE r-oldrel-windows-x86_64

installed package size

installed size is  6.2Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb
NOTE 11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
NOTE r-oldrel-macos-arm64

installed package size

installed size is  6.3Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb
NOTE r-oldrel-macos-x86_64

installed package size

installed size is  6.3Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb
NOTE r-oldrel-windows-x86_64

installed package size

installed size is  6.2Mb
  sub-directories of 1Mb or more:
    doc   5.8Mb

Dependency Network

Dependencies Reverse dependencies checkmate cli DBI dplyr httr2 odbc pool purrr RMySQL RSQLite tidyr readepi

Version History

new 1.0.4 Mar 10, 2026
updated 1.0.4 ← 1.0.3 diff Jan 28, 2026
updated 1.0.3 ← 1.0.2 diff Oct 28, 2025
updated 1.0.2 ← 1.0.1 diff Oct 26, 2025
new 1.0.1 Sep 30, 2025