conversion of BHODS HILIS to LTH application: 1) download BHODS data with "CREATE TABLE IF NOT EXIST" statements, minus _lab_tests_map table 2) run "script/deploy_new_centre.pl bristol" - WITH FINAL DATA SECTION COMMENTED!! 3) run bristol-hilis-convert-part1.sql 4) edit BHODS src data (sql dump): * email_contacts - remove entry #26 - uses type 'other' - inactive anyway * remove _lab_test_map data at end (if not excluded from data dump) 5) run "mysql -uraj -p bristol < <bhods_data>.sql" # NOT DROP TABLES!! 6) run lab-tests-update.sql 7) run bristol-hilis-convert-part2.sql 8) run update-diagnoses-table.pl (needs 2 xl files - current diagnoses table & update file) 9) run update-diagnoses-table.sql 10) run results_summary_user.pl (initially in test mode) 11) create views if not already done: * authorised_reports_view * request_report_view * request_status_view 12) adjust users table & config settings: * users.id 1 username -> 'raj', user_location_id => <BHODS> * config/settings/.bristol & bristol.txt * templates/resources/menu/local/request_forms.bristol * templates/resources/menu/local/file_uploads.bristol problems: * error_code_assignment - bhods uses 'request' hilis4 uses 'request_edit' & 'new_request' * request_diagnosis_history has some NULLS - assumed 'update'