[George Kulz]

Thank you Levy. This seems to do the trick, although I’ve found through some experimentation that it’s the “” character that denotes a subcomponent, not “&”. “&” doesn’t seem to do anything at all.

-George

[George Kulz]

Hi Jim

I managed to solve most of my problem.

What I’ve done is parsed each message into one or more lines using an FRL. So basically, at the end of the day, I have a bunch of lines in a file, each one being a separate charge.

What I need to do now is at the end of the day, somehow take that entire file, stick a header and trailer on it, and then put it somewhere to be picked up by another application. I also need to wipe out the file to prepare for the next day’s charges.

First, is there a way to define an HRL that’s simply a series of FRLs? That would be the template for the input file to the process that puts a header and trailer on. Then the output file template would be an HRL with a header FRL, a bunch of body FRLs, and a trailer FRL, which I’ve done before. Then I somehow need to delete or move the input file so that the next time a charge comes in, it’ll create a brand new file, which I’m not sure how to accomplish either. Do you have any suggestions on that part?

Thanks for your response earlier. I apologize for not getting back to you sooner, but the way things are around here, I’m always off on another project just when I start making headway on the one I’m working on. I’m finally back to this billing file problem now.

-George

[George Kulz]

Hi Jim

Eventually, our billing system needs to receive a flat file that looks kind of like this:

H

Record #1 (includes account number, quantity, unit price, etc.)

Record #2

Record #3

T 20110609

Unfortunately, from the vendor sending the billing file, all the charges are split up by patient, with one HL7 record for each patient. I need to get all of that into the above format.

-George

[George Kulz]

Thank you Mike, I would like to see this code. I appreciate all of your help.

-George

[George Kulz]

Thanks Mike. That seems to work, at least when using a notification window. Now I’m trying to figure out how to print a line out to a file every time the alert occurs, and I’m not having much luck with that. I’ve tried a couple different ways. The first way, I set up an exec to simply append a message to a file, like this:

“This is a test.” >> /opt/quovadx/qdx5.5/integrator/test/data/alert_file

This didn’t seem to work at all. So then I tried writing some simple code using tcl, like this:

set fileId [open /opt/quovadx/qdx5.5/integrator/test/data/alert_file a]

puts $fileId “This is a test.”

close $fileId

This didn’t seem to work either. Any idea on what I might be doing wrong? Does this have anything to do with not having permission to write to the directory I’m specifying? Although I don’t know why that would be the case since the file in question is set to read/write/execute for all, and it’s owned by hci and the group idenfier is set to staff, which should be fine for any file Cloverleaf needs to access I thought.

Any suggestions? Is there a better way I can be doing this instead?

-George

[George Kulz]

Thanks Robert, this worked beautifully.

-George

[George Kulz]

Thank Jim. I had a feeling this would be the answer. I think I know how to do this with code so I should be good, but if I run into any trouble I’ll let you know.

[George Kulz]

James

Sorry, I don’t know how to reference other messages within this one except by topic. The topic I posted under was this:

CR/LF in FRL

Let me know if you can’t find it and I’ll try to copy the text of the messages to this topic.

[George Kulz]

James,

It looks like what might be happening is that at the end of every FRL is a line feed but no carriage return. You might want to insert one at the end of every FRL in order to fix this. I recently posted a question regarding how to insert CR/LF characters at the end of every line in the flat file. Basically, the answer that I received involved creating placeholders for both the CR and the LF characters in each FRL, and then in the Xlate copying the CR character into the corresponding placeholder and coping the LF into the corresponding placeholder.

There was also another solution offered to my question, and you might want to look at that answer as well. I’ll hunt down the question I wrote and post where you can find it here.

[George Kulz]

Thank you all for your responses.

Jeff, I’m not familiar with using masks at all, but if I have time I might try that solution. Your example will be a good exercise in learning how to use them. My guess is that for now I’ll have to write myself a note regarding this and move on since it works at the moment and I’m on a tight deadline to finish this.

[George Kulz]

Jim

Thank you. This seemed to work just fine. The system processing the flat file on the other end wants to see CR/LF after every single line in the flat file, which is why I needed to put them in myself.

-George

[George Kulz]

Hi all

I did manage to get this accomplished with lots of help from Jim Kosloskey (thanks Jim!). I took the same approach as you recommended Robert. Tim, thanks for your  input as well, but I decided not to go that route, prefering to try keeping this within the engine as much as possible. I managed to do the entire translation using mostly Xlate functions, with one place where I had to use a proc (which I’m having trouble with at the moment, but I’ll post elsewhere if I can’t figure it out).

Thanks again to all who offered to help.

George Kulz

Senior Java Programmer

Memorial Hospital of Rhode Island

[George Kulz]

Robert

They will allow us to send customized user data in other fields, but only to store them in Meditech. They will not, however, give us back those fields in any messages coming out. So I won’t be able to link up any of their records to other hospital records from any other system here.

-George

[George Kulz]

Thanks for all the suggestions.

The vendor will not modify the MRNs for us. Nor do they have any suggestions for us, except to switch the entire hospital to their numbers, which is ludicrous for so many reasons.

Also, to make a DB within the pharmacy system will require extra coding, which will cost extra money.

I COULD go the route of coming up with a reference table/DB/what have you within Cloverleaf, or even outside of Cloverleaf through programming on the hospital’s end, but someone already said it best in that it’s not very maintainable, even if it’s outside of Cloverleaf.

The pharmacy is using Meditech btw.

I suppose I could see what others have dealt with in regards to using Meditech. I’ll see if there are other forums for Meditech users.

Thanks for your help so far. If anyone else has suggestions, I’m all ears.

-George

[George Kulz]

Thank you Gary, those are exactly what I need.

-George

[Author]

Replies