<scriptsrc="deps/headroom-0.11.0/headroom.min.js"></script><scriptsrc="deps/headroom-0.11.0/jQuery.headroom.min.js"></script><scriptsrc="deps/bootstrap-toc-1.0.1/bootstrap-toc.min.js"></script><scriptsrc="deps/clipboard.js-2.0.11/clipboard.min.js"></script><scriptsrc="deps/search-1.0.0/autocomplete.jquery.min.js"></script><scriptsrc="deps/search-1.0.0/fuse.min.js"></script><scriptsrc="deps/search-1.0.0/mark.min.js"></script><!-- pkgdown --><scriptsrc="pkgdown.js"></script><metaproperty="og:title"content="REDCap Castellated Data Handling and Metadata Casting">
<metaname="description"content="Casting metadata for REDCap database creation and handling of castellated data using repeated instruments and longitudinal projects in REDCap. Keeps a focused data export approach, by allowing to only export required data from the database. Also for casting new REDCap databases based on datasets from other sources. Originally forked from the R part of REDCapRITS by Paul Egeler. See <https://github.com/pegeler/REDCapRITS>. REDCap (Research Electronic Data Capture) is a secure, web-based software platform designed to support data capture for research studies, providing 1) an intuitive interface for validated data capture; 2) audit trails for tracking data manipulation and export procedures; 3) automated export procedures for seamless data downloads to common statistical packages; and 4) procedures for data integration and interoperability with external sources (Harris et al (2009) <doi:10.1016/j.jbi.2008.08.010>; Harris et al (2019) <doi:10.1016/j.jbi.2019.103208>).">
<metaproperty="og:description"content="Casting metadata for REDCap database creation and handling of castellated data using repeated instruments and longitudinal projects in REDCap. Keeps a focused data export approach, by allowing to only export required data from the database. Also for casting new REDCap databases based on datasets from other sources. Originally forked from the R part of REDCapRITS by Paul Egeler. See <https://github.com/pegeler/REDCapRITS>. REDCap (Research Electronic Data Capture) is a secure, web-based software platform designed to support data capture for research studies, providing 1) an intuitive interface for validated data capture; 2) audit trails for tracking data manipulation and export procedures; 3) automated export procedures for seamless data downloads to common statistical packages; and 4) procedures for data integration and interoperability with external sources (Harris et al (2009) <doi:10.1016/j.jbi.2008.08.010>; Harris et al (2019) <doi:10.1016/j.jbi.2019.103208>).">
<liclass="nav-item"><aclass="external-link nav-link"href="https://github.com/agdamsbo/REDCapCAST/"aria-label="GitHub"><spanclass="fa fab fa-github fa-lg"></span></a></li>
<p>Casting metadata for REDCap database creation and handling of castellated data using repeated instruments and longitudinal projects in REDCap.</p>
<p>This is implemented with</p>
<ul>
<li><p>An app-interface for easy database creation <ahref="https://agdamsbo.shinyapps.io/redcapcast/"class="external-link">accessible here</a> or available to run locally with <code><ahref="reference/shiny_cast.html">shiny_cast()</a></code> allowing you to easily create a REDCap database based on an existing spreadsheet.</p></li>
<li><p>Export data from REDCap in different formats handling castellated data, and on default only export requested data, this is mainly through <code><ahref="reference/read_redcap_tables.html">read_redcap_tables()</a></code>.</p></li>
</ul>
<p>REDCapCAST was initially build on, and still includes code from <ahref="https://github.com/pegeler/REDCapRITS"class="external-link">pegeler/REDCapRITS</a>, and relies on functions from the <ahref="https://ouhscbbmc.github.io/REDCapR/"class="external-link"><code>REDCapR</code></a>-project</p>
<p>This package was originally forked from <ahref="https://github.com/pegeler/REDCapRITS"class="external-link">pegeler/REDCapRITS</a>. The <code>REDCapRITS</code> represents great and extensive work to handle castellated REDCap data in different programming languages. REDCapCAST has evolved into much more than just handling castellated data and so has been detatched from the original project while still relying on the main <code>REDCap_split</code> function. All access to the REDCap database is build on the outstanding work in <ahref="#id_0"><code>REDCapR</code></a>.</p>
<p>This package really started out of frustration during my PhD in health science hearing colleagues complaining about that “castellated” data formatting of REDCap exports when doing longitudinal projects and being used to wide data. This led to some bad decisions in building databases avoiding repeated instruments. This package solves these challenges, but solutions are also implemented else where like the <ahref="https://github.com/vubiostat/redcapAPI"class="external-link">redcapAPI</a> or <ahref="https://github.com/CHOP-CGTInformatics/REDCapTidieR"class="external-link">REDCapTidieR</a> packages, which are bigger project.</p>
<p>To help new PhD students and other researchers, I have also worked on creating a few helper/wrapper-functions to ease data access. Documentation is on it’s way.</p>
<p>For any more advanced uses, consider using the <ahref="https://github.com/vubiostat/redcapAPI"class="external-link"><code>redcapAPI</code></a> or <ahref="https://ouhscbbmc.github.io/REDCapR/"class="external-link"><code>REDCapR</code></a> packages.</p>
<p>The plan with this package is to be bundled with a Handbook on working with REDCap from R. This work is in progress but is limited by the time available. Please feel free to contact me or create and issue with ideas for future additions.</p>
<h2id="code-of-conduct">Code of Conduct<aclass="anchor"aria-label="anchor"href="#code-of-conduct"></a>
</h2>
<p>Please note that the REDCapCAST project is released with a <ahref="https://agdamsbo.github.io/REDCapCAST/CODE_OF_CONDUCT.html">Contributor Code of Conduct</a>. By contributing to this project, you agree to abide by its terms.</p>
<li><ahref="https://github.com/agdamsbo/REDCapCAST"class="external-link"><imgsrc="https://img.shields.io/github/r-package/v/agdamsbo/REDCapCAST"alt="GitHub R package version"></a></li>
<li><ahref="https://app.codecov.io/gh/agdamsbo/REDCapCAST?branch=master"class="external-link"><imgsrc="https://codecov.io/gh/agdamsbo/REDCapCAST/branch/master/graph/badge.svg"alt="Codecov test coverage"></a></li>
