REDCap Advanced TopicsREDCap Advanced Topics

University of Iowa

Institute for Clinical and Translational Science (ICTS)

https://www.icts.uiowa.edu/confluence/display/ICTSit/REDCap#REDCap-REDCapAdvancedTopicsTraining

1

Importing and Importing and Exporting DataExporting Data

Fred McClurg, fred-mcclurg@uiowa.eduHeath Davis, heather-davis@uiowa.edu

https://www.icts.uiowa.edu/confluence/download/attachments/53149797/REDCap_Import_Export_Data.pdf

2

Data Export ToolData Export Tool

Enables export of project data to the following formats:

Microsoft Excel SAS Stata R SPSS

3

Exports your entire data set.

Simple Data ExportSimple Data Export

4

Citation Notice reminder.

Excel File Data ExportExcel File Data Export

5

Data Export File FormatsData Export File Formats

6

Download raw Excel CSV file:

Excel File Data ExportExcel File Data Export

7

• Specify export fields

• Selectde-identified data

Advanced Data ExportAdvanced Data Export

8

Select fields to be exported:

Advanced Data ExportAdvanced Data Export

9

De-Identification export options:

Advanced Data ExportAdvanced Data Export

10

Hash Study Id via export options:

Advanced Data ExportAdvanced Data Export

11

Exports all records in a project to a PDF report.

Other Export OptionsOther Export Options

12

Exports all records in a project and formats the data into to a PDF report.

PDF Export DisplayPDF Export Display

13

Data Import ToolData Import Tool

Enables import of project data via a CSV format.

14

Download Data Import Template:

Importing Data from ScratchImporting Data from Scratch

15

Format Cells

Import File Preparation: Date FieldImport File Preparation: Date Field

16

Date field should be saved to a custom format:

yyyy-mm-dd

• REDCap is unable to import the data saved to a Calculated Field.

• A column of calculated fields should be deleted before importing.

• REDCap will re-compute all calculated fields after import.

Import Preparation: Calculated FieldImport Preparation: Calculated Field

17

Save file in CSV format via:1. File -> Save as …2. Save as type: CSV (Comma delimited) *.csv

Import Preparation: Calculated FieldImport Preparation: Calculated Field

18

• Indicate file by clicking the “Browse” button.

• Import file by clicking the “Upload File” button.

Upload CVS FileUpload CVS File

19

Review data import

Data Display Table ReviewData Display Table Review

20

• Review Data Display Table• Press the “Import Data” button

Import Data Display TableImport Data Display Table

21

Calculated fields can’t be imported.

Importing Calculated FieldsImporting Calculated Fields

22

The calculated field columns must be deleted from the CSV file before importing.

Importing Longitudinal DataImporting Longitudinal Data

23

In longitudinal studies, the event name can not be specified in the CSV file and imported:

Importing Logitudinal EventsImporting Logitudinal Events

24

In longitudinal studies:Upon import, the event must be

specified interactively.Records that belong to the same

event should be imported together.

Date fields must be in the format:YYYY-MM-DD

Importing DatesImporting Dates

25

The date format can be specified via the Excel menu:

Home=>Format=>Format Cells

A custom number category of the following type should be specified:

yyyy-mm-dd

This format should allow import of date fields.

Formatting Dates for ImportFormatting Dates for Import

26

• Monthly REDCap Newsletter Upcoming Training Walk-in Hours Schedule Helpful Tips New REDCap Functionality Frequently Asked Questions (and

answers) REDCap Best Practices

• REDCap LISTSERV Subscription: https://list.uiowa.edu/

scripts/wa.exe?SUBED1=REDCAP&A=1

REDCap NewsletterREDCap Newsletter

27

REDCap DocumentationREDCap Documentation

• Training within REDCap: FAQs (Help & FAQ Tab):

https://redcap.icts.uiowa.edu/redcap/index.php?action=help

Video (Training Resources Tab):https://redcap.icts.uiowa.edu/redcap/index.php?action=training

• Local REDCap documentation:https://icts.uiowa.edu/confluence/display/ICTSit/REDCap 28