OHDSI / Achilles

Automated Characterization of Health Information at Large-scale Longitudinal Evidence Systems (ACHILLES) - descriptive statistics about a OMOP CDM database
https://ohdsi.github.io/Achilles/
130 stars 121 forks source link

exportToAres relies on case sensitive table names #709

Closed alondhe closed 1 year ago

alondhe commented 1 year ago

Describe the bug exportAO uses a few if statements to see if a table exists in the CDM schema, but uses a case sensitive pattern to do so. This fails when CDM table names are in lowercase.

https://github.com/OHDSI/Achilles/blob/main/R/exportAO.R#L624 https://github.com/OHDSI/Achilles/blob/main/R/exportAO.R#L531

To Reproduce Steps to reproduce the behavior:

  1. Have CDM table names in lowercase
  2. Try running exportAO() on it, and see that some CSV exports don't generate.

Expected behavior exportAO should be case insensitive on table name checks.

Desktop (please complete the following information):