Changes between Initial Version and Version 1 of RedCap


Ignore:
Timestamp:
06/25/09 14:38:46 (9 years ago)
Author:
joshuadf
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RedCap

    v1 v1  
     1= Modifying a database = 
     2 
     3INSTRUCTIONS: 
     4 
     5 * Create a template file with the "Generate Template" batch file 
     6 
     7 * Open the Excel file sent by researcher and copy all data (Ctrl-A,Ctrl-C) 
     8 
     9 * Copy the data dictionary into the METADATA_fooproj_TEMPLATE.xls (Ctrl-V) 
     10 
     11 * run the cleaning macro (Ctrl-Q) and check for any errors highlighted in red. 
     12 
     13 * Once all errors have been corrected, run the macro to produce the SQL (Ctrl-A). 
     14   The SQL for creating the project tables will be copied to your clipboard. 
     15 
     16 * Execute the SQL in the MySQL database where you wish to store this project. It will create a "fooproj_new" table 
     17 
     18 * Go to the [https://shibsp.biostr.washington.edu/redcap/redcap_v2.3.2/index.php?pnid=redcap_controlcenter Basic Project Info] page in the REDCap Control Center 
     19 
     20 * Find the correct project and click "make modifications"