On Tuesday 17 October 2006 10:57, David Guest wrote: > I don't know which EHRs provide an api to their patient demographics. MD > doesn't but you could possibly do a SQL query directly on the tables > Tony E is the man for that on MD but its starting to get messy if you > have to write multiple if blocks for the various EHRs
Liz is using Promedicus, former Medibase It uses a no-nonsense Interbase/Firebird SQL based backend There are no artificial restrictions in accessing and / or modifying data on the backend. You can simply fire up Python, type import kinterbasdb #provide you have intalled the kinterbasdb adapter db = kinterbasdb.connect(...) cursor = db.cursor() cursor.execute(select/insert/whatever) You can use the GUI tool "flamerobin" to explore tha database first, but it is a simple and mostly denormalized schema with well chosen table and column names, no confusion there. And that's all I do with my Python and PHP interfaces to that backend (plus a few new tables which you cannot access through the original Medibase frontend, only through my scripts Horst _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
