Importing data into redcap software

Redcap collecting data umkc center for health insights. Project metadata includes project attributes, such as customized dashboards, events, and arms, as well as variable names and field labels. Using the api through r to automate redcap exports some updates. It is widely used in the academic research community. For each of these, the download consists of at least 2 different files. From the data import tool, download your data import template click download your data import template and save it to your computer as a csv file. This guide contains written and illustrated tutorials for the statistical software sas. Redcap and webbased data exports what is api some changes to redcaps api a new tool to interface with redcaps api in r how to use it incorporating the data pulls into your work ow can also save the data but note date of last export 1 separate export code le export data from redcap save data as. Data import tool the data import tool was meant to import legacy data into redcap. Regulatory compliance redcap can be installed in a variety of environments for compliance with such standards as hipaa, 21 cfr part 11, fisma low, moderate, high, and international standards. Redcap data files as covered in the guide to the redcap export module, redcap allows the user to export data in specific formats for a number of different analysis software excel, stata, sas, spss and r. This is often more convenient than downloading a csv, because you can specify specific data you want, including data that isnt easily.

Using this method, you would export the data from redcap and redcap event names in the export file to the new arm before re importing the data. To import this to r, of course, make sure of the internet connection first. Importing data to redcap nutterbredcapapi wiki github. Make certain that the event names match the events in the new arms. My initial experience with importing data to redcap through the api was horrific. Reddi refers to the infrastructure being built for importing data into redcap. Existing redcap projects can be directly imported into a labkey server study using the redcap api.

Using redcaps streamlined process for rapidly developing projects, you may create and design projects using 1 the online method from your web browser using the online designer. Importing data into redcap xml 2 set the url variable. Getting data into redcap csv 2 set the url variable. If the data are in an excel spreadsheet, use import excel to read them. If your dataset is in binary format or the internal format of some software package, you have several options. From the data import tool, download your data import template. A data file exported from a redcap longitudinal project may contain many data rows for a given record. There are several different patterns used to delineate the start and end of a particular variable, and spss must know what pattern to follow in order to read the data correctly. Using the redcap api for data import and export jack baty feb 2019 division of biostatistics sda seminar series. Imports are done using a csv import template, though events for imported data must be assigned manually. Clicking on the buttons enables the scsd to enter data into the redcap database for the selected participant. Redcap penn state clinical and translational science.

Jan 08, 2016 matching redcap structure to mismatched external dataset. Start from a data table and move insertion point to the cell that will become the upperleft corner of the imported data. Getting redcap data into r we can access redcap data using the api and bring it directly into r for analysis. Dbhis talented team of data scientists, programmers, and bioinformatics scientists combine both technological and scientific expertise to transform research and clinical data into innovative solutions that directly impact patient.

If the data are in a spreadsheet, copy and paste the data into statas data editor. The buttons change color, depending on whether data has been entered and whether the data are complete figure 2. This tutorial shows how to import excel files into sas, depending on your version of sas. Using redcap api to import data biomedical informatics core. Deidentification methods for data exporting redcap provides advanced deidentification options that can be optionally used when exporting data, such as removing known identifier fields, removing invalidated text fields, notes fields, or date fields, date shifting and hashing of the record names. Data entry in this format is textbased, so you will most likely use some kind of delimiter.

An intuitive interface for data entry with data validation audit trails for tracking data manipulation and export procedures. The values are converted to lower case for validation, so any combination of lower and upper case values will pass ie, the data frame is not casesensitive. In excel, copy all of your data except the column headers to this template. Mar 30, 20 there are times, however, when the text data are saved in the internet, here is an example. Whenever possible, transfer data from excel using copy and paste. Labkey server can import data collected using redcap research electronic data capture online surveys and forms. For more information on importing your data dictionary i. Yesno fields permit any of the values yes, no, 0, 1 to be imported to redcap with 0no, and 1yes. The redcap api and the brilliant r developers made things possible. Research electronic data capture redcap used as an audit. For each arm you are importing, you must define the events, and for each arm you must enable the forms for those events. Repeating instruments and events university of florida.

The department of biomedical and health informatics dbhi explores how technology can impact both research and patient care. There are quite a few posts introducing how to export data from redcap using r packages such as rcurl and redcapr, but rarely i find information on how to import back to a different project after. Redcap is a secure, webbased application designed to support data capture for research studies. A software programtool which helps to visualize the data from multiple data source example. Redcap getting started deidentification methods for data. A quick and easy software installation process so that you can get redcap running and fully functional in a matter of minutes. Redcap research electronic data capture is a secure, webbased application designed exclusively to support data capture for research studies. As a result, the erdd application must create a data dictionary first, and the honest broker needs to upload the data dictionary into the redcap project requiring one manual step. These options provide greater security and data protection when a user is exporting. If you download and utilize an instrument from the redcap shared library, please cite the rsl manuscript.

Redcap is strict about what it will accept for data, and in most cases, it only accepts the coded data. The order of the fields or the number of fields being imported does not matter, except that the record identifier e. Mar 31, 2014 using php and redcap api to import data. Redcap pricing clinical and translational science institute. Redcap software center for clinical and translational. In this example, we are attempting to import a single record into redcap which also includes 4 field along with their values. The argument header true tells r that the first row of the data are the labels of every column. Graphpad prism 7 user guide importing text and excel.

While redcap can be used to collect virtually any type of data including 21 cfr part 11, fisma, and hipaacompliant environments, it is specifically geared to support online or offline data capture for research studies and operations. Online using the online designer or offline using a data dictionary template in microsoft excel that can be uploaded later into redcap. As a result, the erdd application must create a data dictionary first, and the honest broker needs to upload the data dictionary into. However, several people have found when they import into repeating forms the import is incomplete. It is especially useful if the formatting of the data in the file is nonstandard. Data transformation and data imports automated importing of epic data into a redcap project standalone redcap instances needed for 21 cfr part 11 compliance or fisma compliance. In iu redcap, use the data import tool to import data from a commadelimited csv file. Online electronic data capture and research data repository. Download the data import template with records in rows or columns.

For ease of data transfer, ensure that the order of the variables is the same on both your external source and your redcap data forms. Using the api through r to automate redcap exports some. This process imports the data and the project structure, also called the project metadata. How can i transpose redcap longitudinal data in spss or r. Using this method, you would export the data from redcap and redcap event names in the export file to the new arm before reimporting the data. It is a great solution for research and clinical data collection as it supports multiple types of data, can utilize a study calendar, and calculates descriptive statistics. Data can be uploaded to redcap via the data import tool, an application provided by redcap.

Healthmeasures are currently available in many data collection tools. If set to false, means the first row of the data are not the labels, but are considered as data points. The columns in the template should mirror exactly the columns in the data import template however, they should be all in lower case with no spaces. If you are using 32bit sas, you can use the import wizardproc import. Redcap will provide you with a report of the data imported. Allows redcap to communicate with another it system without human intervention three main uses. Contribute to redcap toolspycap development by creating an account on github. Redcap frequently asked questions redcap knowledge bank.

In future projects the diversities of redcap functionalities could be. When no record is defined, which is true in this case, redcap will automatically append a record. The redcap electronic data importer redi is a tool which is used to automate the process of loading clinical data from electronic medical records emr systems into redcap study data capture systems. Redcap research electronic data capture is a secure web application for building and managing online surveys and databases. I wonder if someone has created a generic routine or programprocedure that processes such a file to generate a new file having one data row for all records including needed variable relabeling. The infile statement in a data step can be used as an alternative to the import wizard for importing existing data from file. Nov 04, 2015 download the data import template with records in rows or columns. Repeating instruments and events redcap has the ability to repeat a data collection instrument or an entire event of instruments an unlimited number of times without having to specify the amount needed.

Using redcap s streamlined process for rapidly developing projects, you may create and design projects using 1 the online method from your web browser using the online designer. Build online surveys and databases quickly and securely. Start stata and open the data editor type edit at the stata dot prompt. Using redcap can help meet these data requirements. Next, copy the url of the data and assign this to any variable name, then apply read. This is sometimes called onetomany data collection, in which a project can have one or more repeating parts. The sc sd will then click on the top button in the program enrollment column figure 2. Open the template and enter the data you want to import. A partnership approach for electronic data capture in small. For instance, it is possible to use the redcap application programming interface api which is external software that provide data to be programmatically downloaded from one source and uploaded into redcap projects. In cases where i received labelled data that needed to be imported to redcap, i found it quite time consuming to properly encode the data so that redcap would.

Redcap research electronic data capture is a secure, webbased application for databases and online surveys for research purposes. Importing data pushing exporting data pulling redcap mobile app synchronization requires coding skills for most uses redcap is only half of the equation consider the required effort and the reward before you go down the rabbit hole. Consider the data below, and say this is saved as data1. Using redcap api to import data biomedical informatics. Research data and metadata must be collected, stored, retained, used and disposed of in a manner that protect the rights, safety, and wellbeing of the research participants and the wider community, maintains data security and integrity, and is in accordance with all applicable requirements. To import data into prism windows only directly from an excel xls file. The goal is to streamline research data flow into redcap from multiple data sources such as rpdr and epic. A partnership approach for electronic data capture in.

Using r and redcap api to automate exportimport dataset. Multiple choice questions, sliders, and checkboxes. Data can be imported into redcap using the data import tool. Redcap is a secure web application for building and managing online surveys and databases. Redcap penn state clinical and translational science institute. The tool provides several options for exporting data, including a simple oneclick option for a quick dump of all records for your project. In iu redcap, use the data export tool, accessed from your project using the link in the menu on the left, to export data.

This page is only accessible from within the redcap community website as a loggedin user. Once logged into redcap, users click on the data import tool and a set of basic step by step instructions will enable you to import data. Redcap has many more features than used in our project. Graphpad prism 7 user guide importing text and excel files. Part 5 of the university of colorado denvers advanced redcap tutorials. Secondly, the independent research environment often lacks the informatics and other multidisciplinary support necessary for effective it integration into research protocols. Paste data into editor by selecting edit and clicking paste. This section deals with importing data records into your project.

Use of redcap at melbourne health the royal melbourne hospital. Use of redcap at melbourne health the royal melbourne. Redi is a general purpose tool for redcap data importing suitable for use in any study in any redcap system. Redcap research electronic data capture is a browserbased, metadatadriven edc software and workflow methodology for designing clinical and translational research databases. Conception to productionlevel surveydatabase in less than one day.

The redcap software as distributed through the redcap consortium attempts to facilitate informatics support for clinical researchers and foster a collaborative network of. The data import tool requires that data to be imported is in csv comma separated variables format. Options for data import such as record format, format for date and date time values. In redcap, return to the data import tool and browse to that csv file. Csv most commonly used, limited due to simplistic code comma separeted values only use if you dont need to modify things. The emphasis in redcap on ease of use and quick turnaround worked very well in our environment.