Service Class for delimited file

[Scott Roth]

What service class should I be using to read in a | delimited file? I went ahead and created the record map for the file but I am having problems reading the file in so I can transform it to HL7 DFT-P03 for our charging system.

Thanks

Scott Roth

Sr. Applications Development Analyst, Integration - Interfaces
Information Technology
The Ohio State University Wexner Medical Center
640 Ackerman, 1/13
PO Box 183111
Columbus OH 43218-3111

Scott...@osumc.edu

[David Loveluck]

Look at  EnsLib.RecordMap.Service.FileService.

 

Also look at the production Demo.RecordMap.Production in ENSDEMO for examples.

 

dave

--
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/d/optout.

[Bear, Alex]

Scott,

 

Try EnsLib.RecordMap.Service.FileService. All of the classes for consuming a record that requires a record map should be in the EnsLib.RecordMap class.

 

Thanks,

Alex Bear

IT Programmer/Analyst

4 BAP

3200 Burnet Ave

Cincinnati, OH 45229

513-585-7345

 

 

 

From: Ensemble-in...@googlegroups.com [mailto:Ensemble-in...@googlegroups.com] On Behalf Of Scott Roth
Sent: Monday, April 21, 2014 10:43 AM
To: Ensemble-in...@googlegroups.com
Subject: [InterSystems-EnsHlth] Service Class for delimited file

 

What service class should I be using to read in a | delimited file? I went ahead and created the record map for the file but I am having problems reading the file in so I can transform it to HL7 DFT-P03 for our charging system.

--

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/d/optout.

---

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

[Scott Roth]

I tried that but I am receiving the following when it tries to read in my test file...

ID: 179 Type: Error Text: ERROR #5002: Cache error: <ZODAT>zDOSDisplayToLogical+1 ^OSUWMC.OSUP.ERCODER.EXTRACT.Record.1 Logged: 2014-04-21 11:16:50.834 Source: OSUP.ERCODER.IN Session: (none) Job: 6872 Class: EnsLib.RecordMap.Service.FileService Method: OnTask Trace: (none) Stack: $$^zDOSDisplayToLogical+1 ^OSUWMC.OSUP.ERCODER.EXTRACT.Record.1 +5 $$^zGetRecord+64^OSUWMC.OSUP.ERCODER.EXTRACT.1 +1 $$^zGetObject+23^OSUWMC.OSUP.ERCODER.EXTRACT.1 +1 $$^zGetObject+2^EnsLib.RecordMap.Service.Base.1 +1 $$^zOnProcessInput+12 ^EnsLib.RecordMap.Service.FileService.1 +1 $$^zProcessInput+11 ^Ens.BusinessService.1 +1 $$^zprocessFile+127 ^EnsLib.File.InboundAdapter.1 +1 $$^zOnTask+45^EnsLib.File.InboundAdapter.1 +1 $$^zOnTask+29^Ens.BusinessService.1 +1 DO^zStart+62^Ens.Job.1 +2 Thanks Scott

To post to this group, send email to Ensemble-i...@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/d/optout.

[Bear, Alex]

Have you tested you file against your record map in the record map building tool?

 

Thanks,

Alex

 

 

 

From: Ensemble-in...@googlegroups.com [mailto:Ensemble-in...@googlegroups.com] On Behalf Of Scott Roth
Sent: Monday, April 21, 2014 10:43 AM
To: Ensemble-in...@googlegroups.com
Subject: [InterSystems-EnsHlth] Service Class for delimited file

 

What service class should I be using to read in a | delimited file? I went ahead and created the record map for the file but I am having problems reading the file in so I can transform it to HL7 DFT-P03 for our charging system.

 

Thanks

Scott Roth

Sr. Applications Development Analyst, Integration - Interfaces
Information Technology
The Ohio State University Wexner Medical Center
640 Ackerman, 1/13
PO Box 183111
Columbus OH 43218-3111

Scott...@osumc.edu

--
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-i...@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/d/optout.

 

---

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

--

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/d/optout.

[Dale du Preez]

The problem is likely related to the date format in play. You should start by having a look at the documentation for the $zdateh() function so you can specify the correct date format on import (which you'd specify as FORMAT=3 under the Datatype Parameters field). If your date doesn't fit any of the default date formats, you can consider building your own datatype class or just treat the data as a string by defining the type as %String instead of %Date.

I hope that helps,
Dale