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

redcapcustodian 1.27.0 (released 2024-12-11)

• Allow multiple EHR IDs in gethipaadisclosurelogfromehrfhir_logs() (@pbchase, #173, #174)
• Include dependency setup in gh-action for tests (@saipavan10-git, #171)
• Improve logging for delete_project function (@saipavan10-git, #171)
• Use parameters in gethipaadisclosurelogfromehrfhir_logs.R (@pbchase, @saipavan10-git #162)

redcapcustodian 1.26.2 (released 2024-11-20)

• Add new production status (@saipavan10-git, #168, #170)
• Add log event tables 10,11,12 (@saipavan10-git, #168, #170)

redcapcustodian 1.26.1 (released 2024-11-03)

• Use latest rstudio-ci in run-tests.yaml (@pbchase, #167)
• Address check errors (@pbchase, #167)
• remove log and output folder from study_template (@ljwoodley, #167)
• write log file to tempdir (@ljwoodley, #167)

redcapcustodian 1.26.0 (released 2024-10-30)

• Update Dockerfile to rocker/verse:4.4.1 (@pbchase)

redcapcustodian 1.25.0 (released 2024-10-24)

• Add report crash logging to render_report.R (@ljwoodley, #166)
• Update renderreport.R to use renderreport() function (@ljwoodley, #166)
• Add render_report() (@ljwoodley, #166)

redcapcustodian 1.24.0 (released 2024-10-17)

• Add job failure alerts with runetl.R and updates to sendmail() (@ljwoodley, #100, #165)
• Add Sai as author in DESCRIPTION (@pbchase)
• Filter out deleted projects in scrapeuserapi_tokens() (@pbchase, #163, #164)
• Move Roxygen2 to 7.3.2 (@pbchase)
• Add gethipaadisclosurelogfromehrfhir_logs() (@pbchase, #158)
• Update run-tests.yaml to use rstudio-ci:4.3.3 (@pbchase)

- R
Published by pbchase about 1 year ago

redcapcustodian - 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

- R
Published by pbchase over 1 year ago

redcapcustodian - 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

- R
Published by pbchase almost 2 years ago

redcapcustodian - 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 emailbody 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 scrapeuserapitokens() 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)

- R
Published by pbchase almost 2 years ago

redcapcustodian - 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 deleteerroneoussurvey_reminders.R (@pbchase, #131, #132)
• update render_report to handle qmd files (@ljwoodley, #117, #129)

- R
Published by pbchase almost 2 years ago

redcapcustodian - 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 getredcapcredentials() (@ljwoodley, #149, #151)
• Update Dockerfile to verse:4.3.2 (@pbchase)
• Add objectstoinclude param to unnestjobsummarydatajson_object() (@pbchase, #112, #115)
• Add MySQL database comparison tools (@pbchase, @ChemiKyle, #140)
• Add delete_project() (@ljwoodley, #139)
• Add dataframetoredcap_dictionary() (@ljwoodley, #136)
• Fixes to test failures (@pbchase, #143)
• Fixes to pkgdown errors (@pbchase, @ChemiKyle, #143

- R
Published by pbchase almost 2 years ago

redcapcustodian - 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 projectstatuslabels, projectpurposelabels, projectpurposeotherresearchlabels (@pbchase, #123)
• Add conn parameter to writesummarymetrics() (@pbchase, #122)
• Add copyentiretabletodb() (@pbchase, #122)
• Add Quarto support in Dockerfile and render_report.R (@pbchase, #118)
• Add unnestjobsummarydatajson_object() (@pbchase, #111)
• Add projectlifecycle_descriptions (@pbchase, #106)
• Add getprojectlife_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)

- R
Published by pbchase over 2 years ago

redcapcustodian - 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 batchsize parm to dbx calls in synctable and synctable2
• Add writesummarymetrics function and corresponding schema
• Add RMarkdown support via render_report
• Add getbademailsfromindividual_emails function
• Add emailfrom and emailcc params to send_email function, default to env value
• Update testing tools and techniques
• Modernize deprecated code
• Address numerous bugs

- R
Published by pbchase about 3 years ago

redcapcustodian - 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 cleanupbademailaddresses.R - Update study template - Make breaking changes to suspenduserswithnoprimaryemail to add logging - Add sendemail, synctable2, and expireuserproject_rights functions

- R
Published by pbchase over 3 years ago

redcapcustodian - 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

- R
Published by pbchase over 3 years ago