Re: [Gnumed-devel] Mirth setup, versions etc was Lab importing ...

[richard terry]

Sure, will send you my transformer code early next week.

The principal is simple.

Create the channel etc
For the transformer you can make more than one) I did both write to file.
Then add one for a database writer.

Then choose edit transformer from the side bar menu, and cut and past a hl7 
file into the tab on the upper right hand side, then choose tree view to 
browse the PID section , then drag n drop the section with patients name over 
to the step window on the left,

Then return to the transformer sql window. The connect string for postgres is 

jdbc:postgresql://localhost:5432/hl7testing (where hl7testing was my postgres 
db(
 
and the sql which you can either construct and verify in postgres looks 
something like this:

INSERT INTO haps_patients
(firstname,surname)
values(${patientIdentification_patientName_familyName},
${patientIdentification_patientName_givenName}
);

Where I've created a table in postgres called haps_patients (Hunter Area 
Pathology Service) with a couple of fields to test.

Save and enable your channel and it should pick up and transform the file 
otherwise view the error messages.

Must dash, but I'll try and do something more concrete over the weekend.

As the looping the loop through the obx files!!!, I did it in a few lines in 
basic, but damned if I can get the java script to work, which it should, as 
per the example on the Mirth website.

David, where are You?

Regards

Richard

On Wed, 23 Jan 2008 10:15:56 pm you wrote:
> Hi Richard,
>
> On 22-Jan-08, at 8:42 PM, richard terry wrote:
> > On Wed, 23 Jan 2008 12:25:49 pm Dave Cramer wrote:
> >> Ok, at this point I have 1.7 installed and running. I can take one of
> >> James' files and do a file input, file output . Has anyone managed to
> >> figure out anything else ?
> >
> > Do you mean you can take the hl7 file and having created a reader/
> > transformer, write to postgres, including all the OBR/OBX segments??
>
> Unfortunately, no, this where I'd like to go, not where I'm at. I can
> read a file in a channel, and simply write it out.
> The rest seems to be a mystery.
>
> > If so I'd like to see your code/talk to you as I became eternally
> > frustrated
> > with this after Karsten pointed me in the MIRTH direction a week
> > ago. Looks
> > like a fabulous program.
> >
> > I'm in the process of wanting to scrap all my patholgoy/incoming
> > paper but
> > hang on to my legancy database/records program.
> >
> > I thought, looking at the transformer, that one would have to use
> > java script
> > to do the segment parsing, and though I followed what seemed like
> > some good
> > examples on the web site, couldn't get it to work past writing the
> > patients
> > name/addres/ etc.
>
> Can I see what you have that does this ?
>
>
> Dave
>
> > Regards
> >
> > Richard
> >
> > PS Karsten, see, I still keep up with gnMed on a daily basis, though
> > I lurk in
> > the background.
> >
> >> Dave
> >>
> >> On 22-Jan-08, at 8:52 AM, Karsten Hilbert wrote:
> >>> On Tue, Jan 22, 2008 at 08:41:03AM -0500, Dave Cramer wrote:
> >>>> X-Mailer: Apple Mail (2.915)
> >>>> Subject: [Gnumed-devel] Mirth setup, versions etc was Lab
> >>>> importing ....
> >>>>
> >>>> Changing the thread subject to be more in line.
> >>>>
> >>>> OK, after viewing the 1.7 webinar it looks like Mirth could make
> >>>> some
> >>>> things easy.
> >>>>
> >>>> What I'd like to do is establish the baseline here.
> >>>>
> >>>> What version of Mirth do we want to work on. I vote 1.7, since it
> >>>> appears
> >>>> to have a much easier scripting engine.
> >>>
> >>> Agree.
> >>>
> >>> Karsten
> >>> --
> >>> GPG key ID E4071346 @ wwwkeys.pgp.net
> >>> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
> >>>
> >>>
> >>> _______________________________________________
> >>> Gnumed-devel mailing list
> >>> address@hidden
> >>> http://lists.gnu.org/mailman/listinfo/gnumed-devel
> >>
> >> _______________________________________________
> >> Gnumed-devel mailing list
> >> address@hidden
> >> http://lists.gnu.org/mailman/listinfo/gnumed-devel
> >
> > _______________________________________________
> > Gnumed-devel mailing list
> > address@hidden
> > http://lists.gnu.org/mailman/listinfo/gnumed-devel