Flat File to HL7

[Josh Fishel]

Is there an easy way to get a flat file converted to an HL7 message?

I need to take two 10 byte strings and place them into an HL7 message.

Thanks!

Topic

[Max Drown (Infor)]

Josh, I think you’ll need to provide us more description of what you need.

-- Max Drown (Infor)

[Josh Fishel]

I’m using T-SQL to pull an alert and the visit ID from our patient database.  I would then like to place it into a “make-shift” HL7 message that has only the visit ID and the alert in it.  The Visit ID would be placed into PID-18 and the alert would be in a Z segment.

So, SQL would dump the data to a flat file like “1234567890, special needs”, where 1234567890 is the Visit ID and special needs is the alert.

The HL7 I would send would be blank, except for the MSH segment and those two fields.  Is this possible?

josh

[Jim Kosloskey]

Josh,

Yes – you can use an Xlate to translate FRL to HL/7.

You will need to construct the FRL definition.

You will need to construct an HL/7 variant since you may not be populating some required segments in the standard. Your own variant will describe this HL/7 message as you see fit. You will need your own variant anyway to make the Z Segment work.

Or you can do this all in Tcl…

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Josh Fishel]

so since I have never messed with the FRL option before…

When choosing the File Formats, it says FRL File.  What needs to be placed in this field?

[Josh Fishel]

nevermind, that was dumb.  i figured it out.

[Josh Fishel]

OK.  If i have two fields in my flat file, how do i determine which field is field and field1 in the FRL configurator?

[Jim Kosloskey]

Josh,

In the FRL configurator you can name the fields whatever ytou want in the order in which they appear in the file.

So let’s say there are two fields in the file and the first field is known as the MRN and the second is known as the acctno.

In the FRL configurator add a field and name it mrn (or MRN – your choice). Complete the details for this field.

Then add a second field and name it acctno (or ACCTNO) and complete its detaisl.

Save the FRL and then use that in the Xlate inbound configuration.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Josh Fishel]

what is the Fill Char and Prefix?

Again, sorry for the dumb questions — I have never used this tool before.

[Author]

Replies