1. HILIS4.git
  2. setup
  3. bhods_convert
 RSS Git Download  Clone
..
  README.txt 1kB remove recent change to report tt, retained by mistake after testing; adjust test count 8 years ago
  bristol-hilis-convert-part1.sql 2kB Bristol/BHODS db conversion scripts 8 years ago
  bristol-hilis-convert-part2.sql 4kB bugfix to Utils::last_working_date() - datetime object passed to method was changed internally, DT needs to be cloned before applying object methods * only affected new version of daily/reports.pl (others use throw-away DT objects where any changes have no consequence) 8 years ago
  bristol-practices.pl 4kB make biopsy_site/anatomical-site optional field; BHODS conversion updates 8 years ago
  lab-tests-update.sql 12kB BHODS conversion update 8 years ago
  recreate-fks.sql 2kB BHODS - update diagnoses table in situ to avoid FK re-assignment 8 years ago
  update-diagnoses-table.pl 5kB BHODS - update diagnoses table in situ to avoid FK re-assignment 8 years ago
  update-diagnosis-table.sql 774B Bristol conversion & genomic xml_validate 8 years ago
  README.txt
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 * error_code_assignment - 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" # 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) run bristol-practices.pl 12) create views if not already done: * authorised_reports_view * request_report_view * request_status_view 13) 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: * request_diagnosis_history has some NULLS - assumed 'update'