OpenEMR offers a few examples for migration that can provide a start for those looking to migrate data to OpenEMR which I was able to use to start the process. Since the example code was for a system different than our custom Django application I had to re-write it to migrate our participant data. This was an iterative process as we added our custom OpenEMR forms and continued into the early stages of OpenEMR deployment. Creating a custom migration script requires intimate knowledge of the schemas and API's of both systems.
SJI upgraded its service offering by moving into a shared space with API Wellness and project Open Hand over on Polk St. This move involved setting up a new VoIP system with a Digium TDM410, 2 analog trunks, and 5 sip trunks. The Snom M9 handset is their deskphone solution.
St. James Infirmary makes use of a custom python web application based on the Django admin interface. Using a custom web application for tracking participant care as opposed to using the cities electronic medical records system allows the organization to further protect it's participants from law enforcement surveillance. The application replicates paper forms that make up a participant chart. My contribution to the application involved upgrading the system to a modern python and Django version, migration from sqlite to MySQL, managing releases and development environments, fixing bugs, and adding features. The organization is planning on migrating the system to OpenEMR.
St. James Infirmary, the sex-worker lead occupational resource center located at 730 Polk St., previously at 234 Eddy St, was at the first floor of a 6 story building that created a cellphone dead zone. An amplifier was required to provide service to the first floor office. From the roof a directional antenna was installed pointing towards one of the downtown towers, LMR 400 was run down the side of the building into the server closet connecting a WeBoost Connect 4G-x, from where more LMR 400 connects to the internal antenna. There is still not complete coverage to the whole office with a single antenna, but this kit could be upgraded with an additional 3 indoor antennas that would complete service to the entire office if there was sufficient funding.
St. James Infirmary was forced to move under the financial pressure of the tech industry in SOMA [1, 2, 3, 4, 5]. Fortunately for them and their community they were able to move to the Tenderloin where they are surrounded by other overlapping neighborhood social services. The office opened with a working intranet with wifi coverage, analog voice service, and a number of printers. Coming soon: DTMF door access control, and extended cell phone service via micro-cell amplifier.