How to map CSV file into HL7 fields

[Sheetal Kairawala]

Hi Everyone,

We are on ensemble 2011 and we need to convert CSV file into HL7 ADT messages.

Has anyone implemented this? Any suggestions?

Please let me know.

Thank you
Sheetal

[Andrew Makinson]

Yes, but its not straight forward

Do you have an example CSV file and I can write up some code for you.

Sent from my iPhone

> --
> You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
> To post to this group, send email to Ensemble-in...@googlegroups.com
> To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com
> For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
> ---
> You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Marc Lang]

I would approach this by the following steps:

1. Create a series of classes that represented the data in your CSV file.

2. Write a business service that parses the CSV files and populates the classes.

3. Create a transform, transforming the classes into HL7.

I've done something very very similar, and this is how I went about it.

[David Loveluck]

The record mapper (and possibly the complex record mapper) does a lot of this for you. Take a look  at

 

http://docs.intersystems.com/ens20131/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_recmap

 

then let us know what else you need

 

dave

[Sheetal Kairawala]

Thanks Andrew. I will get back to you.

Sent from my iPhone 4S

[Sheetal Kairawala]

Hi Dave,

We're on ensemble 2011. Do we have re it's mapper in this version?

Thanks

Sheetal 

Sent from my iPhone 4S

[Joshua Goldman]

Record Mapper was introduced in 2012.1. All records must have the same structure, that is, a series of flat records.

Complex Record Mapper was introduced in 2013.1. A complex record is made up of a pattern of heterogeneous records. The pattern can include repeating records and optional records. The Complex Record Mapper can describe a hierarchal record.

[David Loveluck]

Sheetal

 

Can you clarify the version you are running. Ensemble releases (unlike Cache) jumped from 2010.2 to 2012.1.

 

Thanks

 

dave

[Sheetal Kairawala]

Hi Dave,

We're on ensemble 2011.

Sent from my iPhone 4S

[David Loveluck]

HealthShare 2011 is based on the 2010.2 core technology and does not include the record mapper.

 

The only option with that version is to parse the text directly as others have suggested. Parsing a CSV string isn’t hard, just tedious.

 

dave

[Sheetal Kairawala]

Thank you Dave for your help!!

Sent from my iPhone 4S

[Sheetal Kairawala]

Hi Dom,

 

Can you help me with this? Attaced is the CSV file.

 

Thank you

Sheetal

On Tuesday, July 9, 2013 11:37:20 AM UTC-4, Dom wrote:

Yes, but its not straight forward

Do you have an example CSV file and I can write up some code for you.

Sent from my iPhone

On 9 Jul 2013, at 15:56, Sheetal Kairawala <sheetalk...@gmail.com> wrote:

> Hi Everyone,
>
> We are on ensemble 2011 and we need to convert CSV file into HL7 ADT messages.
>
> Has anyone implemented this? Any suggestions?
>
> Please let me know.
>
> Thank you
> Sheetal
>
> --
> You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
> To post to this group, send email to Ensemble-in...@googlegroups.com

> To unsubscribe from this group, send email to Ensemble-in-Healthcare-unsub...@googlegroups.com

> For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
> ---
> You received this message because you are subscribed to the Google Groups "InterSystems:  Ensemble in Healthcare" group.

> To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healthcare+unsub...@googlegroups.com.

[Andrew Makinson]

you have 3 fields in the example CSV file .

an HL7 message contains hundreds of fields.

whete are the other fields coming from?

which HL7 message do you need? 

Sent from my iPhone

To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com

For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

<removediag.csv>

[Sheetal Kairawala]

<?xml version="1.0" ?>
<transform targetClass='EnsLib.HL7.Message' targetDocType='2.5:ADT_A01' sourceClass='LIPIX.Common.DiagnosisCSVStruct' create='new' language='objectscript'>
<assign property='target.{MSH:SendingApplication}' value='"PMS"' action='set'/>
<assign property='target.{MSH:SendingFacility}' value='"NSUH"' action='set'/>
<assign property='target.{MSH:ReceivingApplication}' value='"HealthShare Edge Gateway"' action='set'/>
<assign property='target.{MSH:ReceivingFacility}' value='"LIPIX"' action='set'/>
<assign property='target.{MSH:DateTimeOfMessage}' value='"20131026120000"' action='set'/>
<assign property='target.{MSH:MessageType}' value='"A08"' action='set'/>
<assign property='target.{EVN:EventTypeCode}' value='"A08"' action='set'/>
<assign property='target.{EVN:RecordedDateTime}' value='"20131026120000"' action='set'/>
<assign property='target.{PID:PatientIdentifierList(1).AssigningAuthority}' value='"NSUH"' action='set'/>
<assign property='target.{PID:PatientIdentifierList(1).IdentifierTypeCode}' value='"MRN"' action='set'/>
<assign property='target.{DG1(1):SetIDDG1}' value='""""""' action='set'/>
<assign property='target.{DG1(1):DiagnosisActionCode}' value='"D"' action='set'/>
<assign property='target.{PID:PatientIdentifierList(1).IDNumber}' value='source.MRN' action='set'/>
</transform>

[Don]

I attached a sample that I had created prior to seeing this post.  It will show the RecordMap, a production to test in, and a transformation similar to below.

Good Luck,

   Don

> To unsubscribe from this group, send email to Ensemble-in-Healthcare-unsubscri...@googlegroups.com

> For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
> ---
> You received this message because you are subscribed to the Google Groups "InterSystems:  Ensemble in Healthcare" group.

> To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healthcare+unsubscri...@googlegroups.com.

> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com
To unsubscribe from this group, send email to Ensemble-in-Healthcare-unsub...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healthcare+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

<removediag.csv>

--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com

[Sheetal Kairawala]

Thanks so much Andy. I will try this out

and let you know.

Sent from my iPhone 4S

> To unsubscribe from this group, send email to Ensemble-in-Healthcare-unsub...@googlegroups.com
> For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
> ---
> You received this message because you are subscribed to the Google Groups "InterSystems:  Ensemble in Healthcare" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healthcare+unsub...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--

You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com

To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com

For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

<removediag.csv>

--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com

To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com

For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com

To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com

For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.

To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

<Export-User_NewProduction-20131029144938.xml>