X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 04B409FA226 for ; Mon, 15 May 2006 12:00:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 91383-05 for ; Mon, 15 May 2006 11:59:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 1945A9FA3B3 for ; Mon, 15 May 2006 11:59:57 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 3072456431; Mon, 15 May 2006 09:59:56 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 15 May 2006 09:59:54 -0500 Date: Mon, 15 May 2006 09:59:54 -0500 From: "Jim C. Nasby" To: Sean Hamilton Cc: "Kenneth B. Hill" , pgsql-admin@postgresql.org Subject: Re: Copy HL7 record/file into PostgreSQL Table Message-ID: <20060515145954.GB26212@pervasive.com> References: <4464C26A.40300@chfund.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4464C26A.40300@chfund.org> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060515:sehamilt@chfund.org::rWn67Eg4BRVoCbU6:000000000000000000 0000000000000000000000008y75 X-Hashcash: 1:20:060515:ken@scottshill.com::jNDgYckc6a9qx56W:0000000000000000000 0000000000000000000000006Yl4 X-Hashcash: 1:20:060515:pgsql-admin@postgresql.org::xKzwF8GnMO/jyijt:00000000000 0000000000000000000000000RRU X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/176 X-Sequence-Number: 21708 On Fri, May 12, 2006 at 01:14:18PM -0400, Sean Hamilton wrote: > I'm currently working on an EHR myself and would love to hear a solution > to this.. If youget valuable feedback can you please forward that to me? > and if I hear anything I'll do the same Given how complex HL7 apparently is (someone up-thread was estimating a week to write a parser) you might want to go with more of a pre-canned solution rather than trying to roll your own. I know that folks I work with that do consulting on our data integration products know a lot about the health industry, so they might be able to turn something around very quickly, though it would mean buying one of our products. I'm sure there's also other experts in the field that could write something that would work directly with PostgreSQL. There's also a number of HL7 related projects on sourceforge (http://lnk.nu/sourceforge.net/9fj/); one of them might prove useful. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461