= Hospital Status Tracking = [[TOC]] Request from White House via Crisis Commons: * http://wiki.crisiscommons.org/wiki/Hurricane_Sandy_2012#A.4_NY_Hospital_Evacuation_and_Availability * Sahana instances: * Production: http://sandy.sahanafoundation.org * Test: http://sandytest.sahanafoundation.org * Can be used to test data imports * Can be used to test new code * Database refreshed from Production to test database migration during upgrades * Please only register if you are actively working on the project * Code: Trunk with Sandy template: https://github.com/flavour/eden/tree/master/private/templates/Sandy * [wiki:UserGuidelinesHMS HMS User Guide] == Requirements == These should be written as User Stories: BluePrint/Guidelines * White House to be able to get an overview of the Hospital Statuses across the affected region * Style Map markers (Feature Query) * breakdown by region * Search widgets * breakdown by services * Search widget (although we don't have data yet) * reopening time * damage sustained * power * Requests? * Contacts? * Security Policy? (currently Simple: http://eden.sahanafoundation.org/wiki/UserGuidelines/Admin/Permissions) * Stick to HAVE: http://docs.oasis-open.org/emergency/edxl-have/emergency_edxl_have-1.0-spec-pr02.xhtml * xml2csv nice to be able to export CSV in the same format that we can import for updates == Issues == * Map not showing locations until gis.update_location_tree() run manually via CLI * Reports not defaulting the fields in the options except for the component one (fixed) * Importer no longer having errors appear in 1st rows (fixed) * also not searchable (fixed) * also have some records show up in XML (fixed) * also would be nice not to have apostrophes quoted (fixed) * Need to explain delay in Lx getting populated via gis.update_location_tree() == Data == Hospitals * http://dev.docnpi.com/ * http://codelists.wpc-edi.com/mambo_taxonomy_2_pre_production.asp Notes on uploading from csv files * Upload from spreadsheet: \\ http://sandy.sahanafoundation.org/eden/hms/hospital/import \\ Click the 'Download template' link to get a blank sample