How would I do an iterate on a inbound flat file it is VRL…

[Tom Gilbert]

I need help with creating an iterate on a VRL to VRL flat file. I have about 11 of 17 of my segments that I need to iterate. Trying to see how the best way to do this. Please let me know if any questions.

Topic

[Jim Kosloskey]

Repetitions do not exist within a VRL rather one would use an HRL in which one could specify a repeating VRL, etc.

To specify how that would be configured we would need to know more about the record/message structure.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Tom Gilbert]

Hello Jim, Been a long time…:) Hope all is well.

I set this up and getting the following error when testing. Not sure what this is.

Please Wait ……
Command Issued: hcixlttest -a -i -e ASCII -d 1 -f eof infor_deltadental_inscvg.xlt /quovadx/cis5.8/integrator/kdtest_miln/Testing_VRL2.CONTINUE
Command output:

MESSAGE 1

Field Number: 1 (empty)
Field Name: OB_HIPAA_834

Thanks,

Tom

[Tom Gilbert]

You mention record structure. This is a HIPAA 834 record structure. This is employee insurance coverage for deltadental. The have segment name like ISA, GS, ST, BGNN… This file they give me is fixed length and because that is not quite true I had to put it through a tickle proc and not it is a delimited file so made it a vrl. There are 22 total segments but 11 repeat.

8 – These are header information and only done once

11 – Main body that gets repeated for every employee and there dependent

3 – Are the Footer and only done once

Please let me know if any questions…

Thanks,

Tom

[Jim Kosloskey]

That is the Xlate Testing tool showing you the resultant output of your Xlate.

Looks like one empty field – probably not what you want.

More information needed regarding the structure of the IB file and what is desired OB.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Jim Kosloskey]

Why not use the X12 format since that is what it is. Cloverleaf supports X12 as a valid format. Probably simplify life for you.

There are some things you need to do though when working with X12. If you would like to discuss this off-line, email me.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Tom Gilbert]

Hello Jim,

I think that would be great. Would it be good sometime between 7:30am PT to 1:00pm PT. My number is below or I can call you whatever is convenient.

My number is 559-624-5386 or 1-559-936-4785

Thank you

[Jim Kosloskey]

My email address is with my signature of my replies.

Email me there and I will assist.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Author]

Replies