{ "_id": "6ad71c6c4b18b90089999049", "Package": "readepi", "Title": "Read Data from Relational Database Management Systems and Health\nInformation Systems", "Version": "1.0.6", "Authors@R": "c(\nperson(\"Karim\", \"Mané\", , \"karim.mane@lshtm.ac.uk\", role = \"aut\",\ncomment = c(ORCID = \"0000-0002-9892-2999\")),\nperson(\"Emmanuel\", \"Kabuga\", , \"kabuga@aims.ac.za\", role = \"aut\",\ncomment = c(ORCID = \"0009-0006-2291-709X\")),\nperson(\"Bubacarr\", \"Bah\", , \"Bubacarr.Bah1@lshtm.ac.uk\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0003-3318-6668\")),\nperson(\"Bankolé\", \"Ahadzie\", , \"Bankole.Ahadzie@lshtm.ac.uk\", role = \"ctb\"),\nperson(\"Nuredin\", \"Mohammed\", , \"Nuredin.Mohammed@lshtm.ac.uk\", role = \"ctb\"),\nperson(\"Abdoelnaser\", \"Degoot\", , \"abdoelnaser-mahmood.degoot@lshtm.ac.uk\", role = \"ctb\"),\nperson(\"Hugo\", \"Gruson\", , \"hugo@data.org\", role = \"rev\",\ncomment = c(ORCID = \"0000-0002-4094-1476\")),\nperson(\"Pratik\", \"Gupte\", , \"pratik.gupte@lshtm.ac.uk\", role = \"rev\",\ncomment = c(ORCID = \"0000-0001-5294-7819\")),\nperson(\"Andree\", \"Valle-Campos\", , \"andree.valle-campos@lshtm.ac.uk\", role = \"rev\",\ncomment = c(ORCID = \"0000-0002-7779-481X\")),\nperson(\"London School of Hygiene and Tropical Medicine, LSHTM\", role = \"cph\"),\nperson(\"data.org\", role = \"fnd\")\n)", "Description": "Import Data from Relational Database Management Systems\n(RDBMS) and Health Information Systems ('HIS'). The current\nversion of the package supports importing data from RDBMS\nincluding 'MS SQL', 'MySQL', 'PostGRESQL', and 'SQLite', as\nwell as from two HIS platforms: 'DHIS2' and 'SORMAS'.", "License": "MIT + file LICENSE", "URL": "https://epiverse-trace.github.io/readepi/,\nhttps://github.com/epiverse-trace/readepi/,\nhttps://github.com/epiverse-trace/readepi", "BugReports": "https://github.com/epiverse-trace/readepi/issues", "VignetteBuilder": "knitr", "Config/Needs/website": "epiverse-trace/epiversetheme", "Config/testthat/edition": "3", "Encoding": "UTF-8", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.3.3", "SystemRequirements": "odbc, libmariadbclient-dev", "Config/pak/sysreqs": "make libicu-dev libmysqlclient-dev unixodbc-dev\nlibssl-dev", "Repository": "https://epiverse-trace.r-universe.dev", "Date/Publication": "2026-04-23 11:01:23 UTC", "RemoteUrl": "https://github.com/epiverse-trace/readepi", "RemoteRef": "HEAD", "RemoteSha": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "NeedsCompilation": "no", "Packaged": { "Date": "2026-10-20 07:43:42 UTC", "User": "root" }, "Author": "Karim Mané [aut] (ORCID: ),\nEmmanuel Kabuga [aut] (ORCID: ),\nBubacarr Bah [aut, cre] (ORCID:\n),\nBankolé Ahadzie [ctb],\nNuredin Mohammed [ctb],\nAbdoelnaser Degoot [ctb],\nHugo Gruson [rev] (ORCID: ),\nPratik Gupte [rev] (ORCID: ),\nAndree Valle-Campos [rev] (ORCID:\n),\nLondon School of Hygiene and Tropical Medicine, LSHTM [cph],\ndata.org [fnd]", "Maintainer": "Bubacarr Bah ", "_user": "epiverse-trace", "_type": "src", "_file": "readepi_1.0.6.tar.gz", "_fileid": "https://r2.ropensci.org/53a15506c9ef1782eb6c67c2711a87ed54a824332d98a010f6a0fd15e619828c", "_filesize": 341626, "_sha256": "53a15506c9ef1782eb6c67c2711a87ed54a824332d98a010f6a0fd15e619828c", "_expires": "2027-01-28T07:46:51.000Z", "_created": "2026-10-20T07:43:42.000Z", "_published": "2026-10-20T07:46:52.635Z", "_upstream": "https://github.com/epiverse-trace/readepi", "_status": "success", "_maintainer": { "name": "Bubacarr Bah", "email": "bubacarr.bah1@lshtm.ac.uk", "login": "bbah74", "description": "2022 - now: Assoc Prof and Head of Data Science, MRC Unit The Gambia at LSHTM.\n\n2016 - 2022: German Research Chair of Mathematics in Data Science at AIMS", "uuid": 28865380, "orcid": "0000-0003-3318-6668" }, "_jobs": [ { "job": 118513969483, "time": 154, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12248343229" }, { "job": 118513969540, "time": 126, "config": "linux-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12248053658" }, { "job": 118513969504, "time": 83, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "12248641571" }, { "job": 118513969802, "time": 112, "config": "macos-release-arm64", "r": "4.6.1", "check": "OK", "artifact": "12248313208" }, { "job": 118511360811, "time": 421, "config": "source", "r": "4.6.1", "check": "OK", "artifact": "12248097944" }, { "job": 118513969541, "time": 127, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "12248905798" }, { "job": 118513969424, "time": 105, "config": "windows-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "12248178694" }, { "job": 118513969390, "time": 60, "config": "windows-oldrel-x86_64", "r": "4.5.3", "check": "OK", "artifact": "12248776161" }, { "job": 118513969450, "time": 91, "config": "windows-release-x86_64", "r": "4.6.1", "check": "OK", "artifact": "12248841115" } ], "_buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818", "_commit": { "id": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "author": "Degoot-AM ", "committer": "Abdoelnaser M Degoot ", "message": "fix lintr issue\n", "time": 1776942083 }, "_distro": "resolute", "_host": "GitHub-Actions", "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "checkmate", "role": "Imports" }, { "package": "cli", "role": "Imports" }, { "package": "DBI", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "httr2", "role": "Imports" }, { "package": "odbc", "role": "Imports" }, { "package": "pool", "role": "Imports" }, { "package": "purrr", "role": "Imports" }, { "package": "RMySQL", "role": "Imports" }, { "package": "RSQLite", "role": "Imports" }, { "package": "tidyr", "role": "Imports" }, { "package": "cyclocomp", "role": "Suggests" }, { "package": "DiagrammeR", "role": "Suggests" }, { "package": "httptest", "role": "Suggests" }, { "package": "kableExtra", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "epiverse-trace", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-43", "n": 2 }, { "week": "2025-44", "n": 20 }, { "week": "2026-04", "n": 1 }, { "week": "2026-05", "n": 1 }, { "week": "2026-16", "n": 12 }, { "week": "2026-17", "n": 22 } ], "_tags": [ { "name": "v1.0.2", "date": "2025-10-27" }, { "name": "v1.0.3", "date": "2025-10-29" } ], "_topics": [ "data-import", "epidemiology", "epiverse", "health-information-systems" ], "_stars": 6, "_contributors": [ { "user": "karim-mane", "count": 224, "uuid": 84502011 }, { "user": "degoot-am", "count": 48, "uuid": 19929487 }, { "user": "thibautjombart", "count": 20, "uuid": 10757154 }, { "user": "bisaloo", "count": 19, "uuid": 10783929 }, { "user": "bahadzie", "count": 2, "uuid": 41001537 }, { "user": "kabuga1987", "count": 2, "uuid": 33763198 } ], "_userbio": { "uuid": 101338582, "type": "organization", "name": "Epiverse-TRACE", "followers": 255 }, "_downloads": { "count": 373, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/readepi" }, "_devurl": "https://github.com/epiverse-trace/readepi", "_pkgdown": "https://epiverse-trace.github.io/readepi/", "_searchresults": 12, "_rbuild": "4.6.1", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/manual.pdf", "extra/NEWS.html", "extra/NEWS.txt", "extra/readepi.html", "extra/readme.html", "extra/readme.md", "LICENSE" ], "_homeurl": "https://github.com/epiverse-trace/readepi", "_realowner": "epiverse-trace", "_cranurl": true, "_releases": [ { "version": "1.0.1", "date": "2025-10-03" }, { "version": "1.0.2", "date": "2025-10-27" }, { "version": "1.0.3", "date": "2025-10-29" }, { "version": "1.0.4", "date": "2026-01-29" }, { "version": "1.0.5", "date": "2026-04-22" }, { "version": "1.0.6", "date": "2026-04-23" } ], "_exports": [ "dhis2_login", "get_api_version", "get_data_elements", "get_organisation_units", "get_program_org_units", "get_program_stages", "get_programs", "get_tracked_entities", "login", "read_dhis2", "read_rdbms", "read_sormas", "show_tables", "sormas_get_api_specification", "sormas_get_data_dictionary", "sormas_get_diseases" ], "_datasets": [ { "name": "lookup_table", "title": "Lookup table", "object": "lookup_table", "class": [ "data.frame" ], "fields": [ "r", "dhis2", "sql" ], "rows": 11, "table": true, "tojson": true }, { "name": "request_parameters", "title": "Request parameters", "object": "request_parameters", "class": [ "data.frame" ], "fields": [ "version", "e_endpoint", "e_orgunit", "e_teid", "e_oumode", "e_response", "te_endpoint", "te_orgunit", "te_teid", "te_oumode", "te_response", "paging" ], "rows": 3, "table": true, "tojson": true } ], "_help": [ { "page": "dhis2_login", "title": "Establish connection to a DHIS2 instance", "topics": [ "dhis2_login" ] }, { "page": "get_api_version", "title": "Get DHIS2 API version", "topics": [ "get_api_version" ] }, { "page": "get_data_elements", "title": "Get all data elements from a specific DHIS2 instance", "topics": [ "get_data_elements" ] }, { "page": "get_organisation_units", "title": "Get the organization units from a specific DHIS2 instance", "topics": [ "get_organisation_units" ] }, { "page": "get_program_org_units", "title": "Get organisation units that are associated with a given program", "topics": [ "get_program_org_units" ] }, { "page": "get_program_stages", "title": "Get program stages for one or more DHSI2 programs", "topics": [ "get_program_stages" ] }, { "page": "get_programs", "title": "get all programs from a given specific DHIS2 instance", "topics": [ "get_programs" ] }, { "page": "get_tracked_entities", "title": "Get tracked entity attributes, their corresponding IDs and event IDs", "topics": [ "get_tracked_entities" ] }, { "page": "login", "title": "Establish a connection to the HIS of interest.", "topics": [ "login" ] }, { "page": "lookup_table", "title": "Lookup table", "topics": [ "lookup_table" ] }, { "page": "read_dhis2", "title": "Import data from DHIS2", "topics": [ "read_dhis2" ] }, { "page": "read_rdbms", "title": "Import data from relational database management systems (RDBMS).", "topics": [ "read_rdbms" ] }, { "page": "read_sormas", "title": "Import data from SORMAS", "topics": [ "read_sormas" ] }, { "page": "request_parameters", "title": "Request parameters", "topics": [ "request_parameters" ] }, { "page": "show_tables", "title": "Display the list of tables in a database", "topics": [ "show_tables" ] }, { "page": "sormas_get_api_specification", "title": "Download the API specification file from SORMAS", "topics": [ "sormas_get_api_specification" ] }, { "page": "sormas_get_data_dictionary", "title": "Download SORMAS data dictionary", "topics": [ "sormas_get_data_dictionary" ] }, { "page": "sormas_get_diseases", "title": "Get the list of disease names from a SORMAS instance", "topics": [ "sormas_get_diseases" ] } ], "_pkglogo": "https://github.com/epiverse-trace/readepi/raw/HEAD/man/figures/logo.svg", "_readme": "https://github.com/epiverse-trace/readepi/raw/HEAD/README.md", "_rundeps": [ "askpass", "backports", "bit", "bit64", "blob", "cachem", "checkmate", "cli", "cpp11", "curl", "DBI", "dplyr", "fastmap", "generics", "glue", "hms", "httr2", "later", "lifecycle", "magrittr", "memoise", "odbc", "openssl", "pillar", "pkgconfig", "pool", "purrr", "R6", "Rcpp", "rlang", "RMySQL", "RSQLite", "stringi", "stringr", "sys", "tibble", "tidyr", "tidyselect", "utf8", "vctrs", "withr" ], "_vignettes": [ { "source": "install_drivers.Rmd", "filename": "install_drivers.html", "title": "Installing drivers", "engine": "knitr::rmarkdown", "headings": [ "MS SQL drivers for OSX-based systems", "MS SQL drivers for Linux-based systems" ], "created": "2025-09-19 09:44:53", "modified": "2026-01-23 08:55:52", "commits": 7 }, { "source": "design_principle.Rmd", "filename": "design_principle.html", "title": "Package design vignette for {readepi}", "engine": "knitr::rmarkdown", "headings": [ "Concept and motivation", "Scope", "Output", "Design decisions", "Authentication", "Data import", "Dependencies", "Contribute" ], "created": "2024-06-10 12:08:23", "modified": "2026-04-21 10:18:09", "commits": 34 }, { "source": "query_parameters.Rmd", "filename": "query_parameters.html", "title": "Query parameters", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "RDBMS query parameters", "Examples", "DHIS2 query parameters", "SORMAS query parameters" ], "created": "2025-09-19 09:44:53", "modified": "2026-04-23 11:01:23", "commits": 13 }, { "source": "readepi.Rmd", "filename": "readepi.html", "title": "readepi: Reading data from health information systems", "engine": "knitr::rmarkdown", "headings": [ "Overview", "Need for MS drivers", "Authentication", "Reading data from RDBMS", "Reading data from HIS", "Importing data from DHIS2", "Importing data from SORMAS" ], "created": "2023-05-09 22:51:25", "modified": "2026-04-23 11:01:23", "commits": 55 } ], "_score": 6.635483746814912, "_indexed": true, "_nocasepkg": "readepi", "_universes": [ "epiverse-trace", "bbah74" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.6", "date": "2026-10-20T07:46:24.000Z", "distro": "resolute", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/6a56f60bc82be228b4dbf13477ff02c58dc7f09a395e62415bf6423a2dcba24c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" }, { "r": "4.6.1", "os": "linux", "version": "1.0.6", "date": "2026-10-20T07:45:54.000Z", "distro": "resolute", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/b29bfd121125435566988278392cf3267d42d735159618cd9dc927912ae01eaf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" }, { "r": "4.5.3", "os": "mac", "version": "1.0.6", "date": "2026-10-20T07:45:19.000Z", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/25b44598c66204ea3bc10871ea1f535b20b0301d999fbec550382d85d16228f0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" }, { "r": "4.6.1", "os": "mac", "version": "1.0.6", "date": "2026-10-20T07:45:44.000Z", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/747c5ce23a00add1db2e8ab07f18a55bd48d034a932883598a72d95c30faa793", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.6", "date": "2026-10-20T07:46:10.000Z", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/07be465a250bf13d31cf98b452a320ad909a649787e1a4a4a4ad2d9b8256e0f8", "status": "success", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" }, { "r": "4.7.0", "os": "win", "version": "1.0.6", "date": "2026-10-20T07:45:27.000Z", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/7ce67e2eca7df6ad90daf944d3777ecffa33d63f30e65263caa6468be25eb544", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" }, { "r": "4.5.3", "os": "win", "version": "1.0.6", "date": "2026-10-20T07:44:48.000Z", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/dd363466ebe5318271a758ce1daaee998e798d5c42ec8a36b9475eda709026dc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" }, { "r": "4.6.1", "os": "win", "version": "1.0.6", "date": "2026-10-20T07:45:12.000Z", "commit": "13ac0da0e7584b62e5911d2f3a1abf68e56cff95", "fileid": "https://r2.ropensci.org/467b9eac7c3f2b372aac5b4a1f19a1a6481ab4d42cc22c673f328f669a2f20ed", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/epiverse-trace/actions/runs/39387626818" } ] }