Re: Copy HL7 record/file into PostgreSQL Table

WOW, that's some huge document, kinda meandering and not sure where it
wants to go. :)

I've written importers for such stuff in the past. Looks like a week
long job there.

a couple of points. Looks like an HL7 file is kind of a broad format.
I'd shoot for whatever subset gets you what you need.

Looks like there are there a lot of dependent tables you'll need to make
it work. Am I right?

Di you just need to parse this thing into pieces and toss it into a
generic table, or are you gonna have a lot of other processing to make
it work?

On Fri, 2006-05-12 at 12:27, Kenneth B. Hill wrote:
> An HL7 file is a tagged file used to transfer electronic health
> records. The file looks like:
>
> MSH|^~\&|EPIC|EPICADT|SMS|SMSADT|199912271408|CHARRIS|ADT^A04|1817457|
> EVN|A04|199912271408|||CHARRIS
> PID||0493575^^^2^ID 1|454721||DOE^JOHN^^^^|DOE^JOHN^^^^|19480203|M|
> NK1||CONROY^MARI^^^^|SPO||(216)731-4359||EC|||||||||||||||||||||||||||
> PV1||O|168 ~219~C~PMA^^^^^^^^^||||277^ALLEN FADZL^BONNIE^^^^||||||||||
>
> You can download a PDF for details here:
>
> http://www.hl7.org/Special/IG/final.pdf
>
> -Ken
>
> On May 12, 2006, at 10:01 AM, Scott Marlowe wrote:
>
> > On Fri, 2006-05-12 at 11:41, Kenneth B. Hill wrote:
> >> I'm looking for a way to get an HL7 file into a table. My current
> >> thinking is I need to parse the HL7 file to a flat-file and use the
> >> copy command. I would appreciate some guidance on doing this.
> >> Thank you.
> >
> > I'd love to help out.
> >
> > Just one thing... What's an HL7 file?
>