ANSI 834 File Formatting

I’m attempting to compile data from a mapper snap into a .txt file formatted in the ANSI 834 file format - examples can be found here:

I’m unsure what snap(s) I could use to do this or if there’s a known and simplified approach to doing so in SnapLogic.

Does anyone have experience compiling these types of files?

Thank you!

I worked with a VARIANT of that, known as HL7 v2 I at least had a methodology to work it out on another ETL tool but the company, being a medical service provider, already had a special purpose ETL tool. I guess it couldn’t do much, because they didn’t use it for regular ETL, but what we did was I created a little star with a place for all of the available fields, and told them how to locate them, and where to put them. They used that product, and I just then read the fields from the highly normalized star structure I setup. They were happy with it for the 4 years I was there, and apparently are still happy with it.

The complexity depends on how the data is setup in the message, how you read it, and possibly the number of arrays that you have. The message that you have here makes it look like you may not have to worry about arrays. The characters in the first part of the line indicate what this relates to and then the * indicates that you are dealing with the next part of the line.

It LOOKS like Snaplogic may actually have a snappack for EDI, that has a lot of the grunt work handled by some template or something. If this is the case, you might find it worthwhile talking to your representative about this. Their snappack would effectively be doing be doing the same thing that the tool the company I spoke about was using!

Based on what I can see about the EDI snappack makes it seem like it effectively takes the EDI input, that it pulls, and converts it to an easy to read JSON that snaplogic handles throughout. If I were doing it without such a thing, I would be tempted to use another script. You can do that, and it would seem transparent, but it is more work, and less obvious.

1 Like

Thank you very much for the reply, your response was helpful. I reached out to my SnapLogic representative after you suggested it who sadly suggested that the EDI snap pack wouldn’t work in my case in assembling this type of file.

The quickest solution in our case looks to just be using a mapper snap to assemble incoming variables in a string that mimics the format. Luckily the format is very restrictive which actually plays to our favor in that it’s easy to logically assemble the data.

Once again, appreciate the feedback.