Entering data

DO NOT ENTER DATA INTO REDCap UNLESS YOU HAVE SPOKEN TO DRS. CAMPBELL AND WENK AND KNOW EXACTLY WHAT YOU ARE DOING

Overview

In general, there are three ways.

• Log into REDCap (see the docs home page for instructions on getting an account)
  • enter data manually (slow and safer)
  • use the data import tool (faster and potentially disastrous)
• Use the API
  • Ken has not tried this yet

Data import tool

REDCap’s data import tool allows you to upload data from a csv file.

The formatting is tricky.

• The columns should be labeled with the REDCap field name, e.g. mouse_sex in lower case.
• Drop-down lists and radio buttons have to be replaced by their numeric codes
  • So, for example
    • Male = 1
    • Female = 2
  • and
    • RLC Murine WT = 1
    • RLC Human WT = 2
    • RLC Human K104E = 3
  • Check the Online Designer in REDCap if you are not sure of the codes
• Repeating instruments
  • names (echo, mri, etc.) only work in lower case
  • repeat instance (1, 2, 3) need to be provided

Helpful functions

• softmouse_output_to_redcap_import.m
  • takes a full dump of the inventory from SoftMouse and makes an entry for each mouse with
    • mouse SID (the unique identifier for the animal)
    • date of birth
    • sex
    • genotype
    • death date (if mouse is dead)

Initial build

Ken built the initial version of the REDCap database on 25 June 2019 from files in repo\data\initial_build:

• import_file_initial_build.csv - made by softmouse_output_to_redcap_import.m
• echo_initial_build.csv - made by hand from data on Teams
• mri_initial_build.csv - made by hand from data on Teams