1 / 28

REDCap Advanced Topics

REDCap Advanced Topics. University of Iowa Institute for Clinical and Translational Science (ICTS) https://www.icts.uiowa.edu/confluence/display/ICTSit/REDCap#REDCap-REDCapAdvancedTopicsTraining. Importing and Exporting Data.

oliana
Download Presentation

REDCap Advanced Topics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. REDCap Advanced Topics University of Iowa Institute for Clinical and Translational Science (ICTS) https://www.icts.uiowa.edu/confluence/display/ICTSit/REDCap#REDCap-REDCapAdvancedTopicsTraining

  2. Importing and Exporting 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

  3. Data Export Tool Enables export of project data to the following formats: • Microsoft Excel • SAS • Stata • R • SPSS

  4. Simple Data Export Exports your entire data set.

  5. Excel File Data Export Citation Notice reminder.

  6. Data Export File Formats

  7. Excel File Data Export Download raw Excel CSV file:

  8. Advanced Data Export Specify export fields Selectde-identified data

  9. Advanced Data Export Select fields to be exported:

  10. Advanced Data Export De-Identification export options:

  11. Advanced Data Export Hash Study Id via export options:

  12. Other Export Options Exports all records in a project to a PDF report.

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

  14. Data Import Tool Enables import of project data via a CSV format.

  15. Importing Data from Scratch Download Data Import Template:

  16. Import File Preparation: Date Field • Date field should be saved to a custom format: • yyyy-mm-dd Format Cells

  17. Import Preparation: Calculated Field 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.

  18. Import Preparation: Calculated Field Save file in CSV format via: • File -> Save as … • Save as type: CSV (Comma delimited) *.csv

  19. Upload CVS File Indicate file by clicking the “Browse” button. Import file by clicking the “Upload File” button.

  20. Data Display Table Review Review data import

  21. Import Data Display Table Review Data Display Table Press the “Import Data” button

  22. Importing Calculated Fields The calculated field columns must be deleted from the CSV file before importing. Calculated fields can’t be imported.

  23. Importing Longitudinal Data • In longitudinal studies, the event name can not be specified in the CSV file and imported:

  24. Importing Logitudinal Events • In longitudinal studies: • Upon import, the event must be specified interactively. • Records that belong to the same event should be imported together.

  25. Importing Dates Date fields must be in the format: YYYY-MM-DD

  26. Formatting Dates for Import 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.

  27. REDCap Newsletter • 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

  28. REDCap 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

More Related