conversion of BHODS HILIS to LTH application: 1) download BHODS data with "CREATE TABLE IF NOT EXIST" statements, no DROP TABLES statements, minus _lab_tests_map table 2) run: "perl script/deploy_new_centre.pl -c bristol --no-data" 3) run bristol-hilis-convert-part1.sql 4) edit BHODS src data (sql dump): * email_contacts - remove entry #26 - uses type 'other' - inactive anyway * error_code_assignment data - change request -> request_edit and add (new_request,1) * remove _lab_test_map data at end (if not excluded from data dump) 5) run "mysql -uraj -p bristol < <bhods_data>.sql" # ENSURE NO DROP TABLES STATEMENTS!! 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 MANUALLY update-diagnoses-table.sql (1st query is a check on diagnoses) 10) run results_summary_user.pl 11) run MANUALLY results_summary_user.sql (has a check query) 12) run bristol-practices.pl & update GP's manually in HILIS 13) run update-referral-sources.sql 14) create views if not already done: * authorised_reports_view * request_report_view * request_status_view 15) 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 check: new/relapsed diagnoses loads for external users problems: * request_diagnosis_history has some NULLS - assumed 'update'