Modifying a database

INSTRUCTIONS:

  • Create a template file with the "Generate Template" batch file
  • Open the Excel file sent by researcher and copy all data (Ctrl-A,Ctrl-C)
  • Copy the data dictionary into the METADATA_fooproj_TEMPLATE.xls (Ctrl-V)
  • run the cleaning macro (Ctrl-Q) and check for any errors highlighted in red.
  • Once all errors have been corrected, run the macro to produce the SQL (Ctrl-A). The SQL for creating the project tables will be copied to your clipboard.
  • Execute the SQL in the MySQL database where you wish to store this project. It will create a "fooproj_new" table
  • Find the correct project and click "make modifications"