Convert HL7 to tab delimited file

This topic has 5 replies, 3 voices, and was last updated 12 years ago by David Barr.

Creator

Topic
August 29, 2012 at 6:43 pm #53253

Mary Bodoh-Stone
Participant

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
Creator

Topic

Viewing 4 reply threads

Author

Replies
- August 31, 2012 at 6:38 pm #77059
  
  Mary Bodoh-Stone
  Participant
  
  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
- August 31, 2012 at 7:06 pm #77060
  
  Jim Kosloskey
  Participant
  
  Mary,
  
  email me and I will try to assist.
  
  email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
- September 4, 2012 at 1:47 pm #77061
  
  Mary Bodoh-Stone
  Participant
  
  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!!
- September 4, 2012 at 9:45 pm #77062
  
  Mary Bodoh-Stone
  Participant
  
  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.
- September 4, 2012 at 10:04 pm #77063
  
  David Barr
  Participant
  
  The extra line is metadata in the saved message file. It isn’t actually sent through the interface.
Author

Replies

Viewing 4 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.

Convert HL7 to tab delimited file

Forums

Forum Statistics