REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 1.23.0 adds project and instance to logging

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 1.22.2 made these changes: Restore 'writexl' to Dockerfile

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 1.21.0 - 1.22.1 make these changes:

• Update run-tests.yaml to use rstudio-ci:4.3.3 (@pbchase, #157)
• Implement hacky fix for tlmgr 2023 being unable to install packages (@ChemiKyle, #156)
• Fix bug that prevented email_body from being included in email (@ljwoodley, @ChemiKyle, #155)
• Add 'Scraping one user's API tokens' section to vignettes/credential-scraping.Rmd (@pbchase, @ChemiKyle, #154)
• Update scrape_user_api_tokens() to tidyselect 1.2 standards (@pbchase, #154)
• Add attachment management to send_email() allowing lists of files or dataframes to be attached to an email (@ljwoodley, #152,
  #153, #157)

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 1.15.0 - 1.20.0 make these changes:

• Add get_redcap_credentials() (@ljwoodley, #149, #151)
• Update Dockerfile to verse:4.3.2 (@pbchase)
• Add objects_to_include param to unnest_job_summary_data_json_object() (@pbchase, #112, #115)
• Add MySQL database comparison tools (@pbchase, @ChemiKyle, #140)
• Add delete_project() (@ljwoodley, #139)
• Add dataframe_to_redcap_dictionary() (@ljwoodley, #136)
• Fixes to test failures (@pbchase, #143)
• Fixes to pkgdown errors (@pbchase, @ChemiKyle, #143

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 1.13.1 - 1.14.1 make these changes:

• Fix build issues on Apple silicon (@pbchase, #133, #134)
• Add delete_erroneous_survey_reminders.R (@pbchase, #131, #132)
• update render_report to handle qmd files (@ljwoodley, #117, #129)

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 1.7.0 - 1.13.0 make these changes:

• Add lookup tables project_status_labels, project_purpose_labels, project_purpose_other_research_labels (@pbchase, #123)
• Add conn parameter to write_summary_metrics() (@pbchase, #122)
• Add copy_entire_table_to_db() (@pbchase, #122)
• Add Quarto support in Dockerfile and render_report.R (@pbchase, #118)
• Add unnest_job_summary_data_json_object() (@pbchase, #111)
• Add project_life_cycle_descriptions (@pbchase, #106)
• Add get_project_life_cycle() (@pbchase, #106)
• Add a pkgdown website at https://ctsit.github.io/redcapcustodian/ (@pbchase, #103)
• Add a log database system for dev work (@pbchase, #110)

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 1.1.1 - 1.6.0 make these changes:

• Add randomization management functions and a sample ETL
• Add batch_size parm to dbx calls in sync_table and sync_table_2
• Add write_summary_metrics function and corresponding schema
• Add RMarkdown support via render_report
• Add get_bad_emails_from_individual_emails function
• Add email_from and email_cc params to send_email function, default to env value
• Update testing tools and techniques
• Modernize deprecated code
• Address numerous bugs

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap system, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Releases 0.7.0 - 1.1.0 make these changes:

• Restructure the Friday Call Demo for presentation
• Add logging to cleanup_bad_email_addresses.R
• Update study template
• Make breaking changes to suspend_users_with_no_primary_email to add logging
• Add send_email, sync_table2, and expire_user_project_rights functions

REDCap Custodian

REDCap Custodian simplifies data management activities on REDCap systems. It provides a framework for automating data extraction, transformation, and loading work (ETL). It supports ETL work within a REDCap, between REDCap projects, between REDCap systems, and with the REDCap database. It provides an extensible set of R functions, a Docker image, and an Rstudio Project template upon which a REDCap team can build ETL tasks that serve their REDCap systems and customers.

Release 0.6.1 is the first public release