Today I started to code a utility to bridge Port Server with our Hospital Management System. Port Server is an application that captures some laboratory devices’ output. So laboratory analyst doesn’t need to input the result to our system, instead our utility does for her.
I develop the utility that covers:
1) Map our LIS test database to machine’s test code. Because the port server works with some device, I should point to the machine also.
2) Utility to edit/alter the work order that was sent by our Laboratory Information System (LIS). This utility will usefull when a machine broke up, we can run the test to other available machine.
3) Capture the result from Port Server System and save it to our HMS database. It’s relatively easy since the Port Server and my application talk via MySQL database. The challenge is when my application must use two databases, one is our HMS database and the other is port server database. These two databases reside on two separate servers. Thank to PHP that make this task quiet easy.
I done the mapping part today. Tomorrow I’ll start to code the rest.
