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