Convert HL7 to tab delimited file

[Mary Bodoh-Stone]

Hi,

 I need to take a HL7 charge message and convert to a tab delimited file that I can post via teload to a HPP clinic system. I have 3 required fields for this tab delimited file.  CLM1, CLM2 and SV1001.  I created 3 frls (CLM1, CLM2 and SV1001). Each field is tab delimited and the final field in the frl is a line feed.  I have the 3 frls combined into a HRL.  

 So in the cloverleaf tool I am reading a  HL7 DFT message and Iwant to output a tab delimited file which I will then post to our HPP system.  When I use the testing tool I get nothing, no output,  but if I echo the fields  (HRL) in my xlate, when I use the testing tool I get the values I would expect.

 What am I doing wrong?  Thanks much.

– Mary

Topic

[Mary Bodoh-Stone]

I changed the FRL to VRLs and am now getting data in my testing tool.

Below is a sample:

— Begin VRL Segment CLM1 —  

Length of Repeat Field:         50

Repeat Field Offset from Field: 0

              CLM1: ch >CLM1<

          Customer: nm >04637<

           DataSet: ch >EPRESCRB<

     SortIndicator: nm >2090314<

          Function: ch >TH<

       AutoRelease: ch >Y<

         Guarantor: nm >123456<

I then configured my xlate into the NetConfig and ran a test charge through.  I wrote the output to a logger file.  It looks like the whole HL7 message is being written to the very first field in the VRL depending on what detail level I use in the format option.  Output looks like this:

              CLM1: ch >MSH|<

          Customer: nm ><

           DataSet: ch ><

     SortIndicator: nm ><

          Function: ch ><

       AutoRelease: ch ><

  SupPatientNumber: nm ><

   TransactionCode: ch >GT<

I must have something configured wrong? Thanks.

– Mary

[Jim Kosloskey]

Mary,

email me and I will try to assist.

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

[Mary Bodoh-Stone]

Jim helped me discover my issue.  I had 2 threads pointing to 2 different processes. Changed the processes to be the same, cycled and I received my desired output.

Thank you Jim!!

[Mary Bodoh-Stone]

Making progress.  If I look at my charge via the SMAT file it looks good.  

CLM1    04637   EPRESCRB        2090314 TH      Y                       GT              2090314         Y

CLM2            V709

SV1001  281             20120514                510909                                  0001    000000000+      281

                               CC      000     10

But I look at the file on the backend I see this:

CLM1    04637   EPRESCRB        2090314 TH      Y                       GT              2090314         Y

CLM2            V709

SV1001  281             20120514                510909                                  0001    000000000+      281

                               CC      000     10

mc_echargemc_echarge{CONNID 0} {IPVERSION 4} {CLIENTIP 10.201.229.29} {CLIENTPORT 49684}

Is this something I have to turn off in the Network Configurator?  Thanks.

[David Barr]

The extra line is metadata in the saved message file. It isn’t actually sent through the interface.

[Author]

Replies