Need to create an 835 edi file from a flat file.

Clovertech Forums Read Only Archives Cloverleaf Cloverleaf Need to create an 835 edi file from a flat file.

  • Creator
    Topic
  • #55304
    Lisa Heaton
    Participant

      Need to create an 835 edi file from a flat file.  I’ve gone from edi to flat, this is my first flat to edi.

      I’ve got things working to a certain degree.  My question concerns going to the next record (CLP and SVC)  Going to a flat file, we have iterations we can do but what do you do going the other direction.

      Had the basic all fields, one record working yesterday but today I’m not getting all the fields. Grrr.  I’ll get that working again.

      I can’t seem to find clear documentation.  

      How do you:

      Get it to repeat?

      Create the Envelope as well as the STSE segment?

      Do you have to use a counter to get the record count?

      Any help would be appreciated.

      Thank you,

      Llisa

    Viewing 2 reply threads
    • Author
      Replies
      • #84898
        Brenda Carpenter
        Participant

          Hi Lisa,

          I have built a FF to 834 x12 file in cloverleaf and needed to use multiple HRLs.

          Each input record was defined as FRL, then built HRLs to do the repeating, this HRL within the HRL repeats for x amount of times.  Then within that LOOP, I have other HRL loops  to repeat data as necessary.  I think the 834 is much easier than the 835 will be tho.

          ie: FF HRL:

          STHDRSEG

          BGNSEG

          DTPFSEG

          N1SSEG

          N1PSEG

          INSLOOPHRL  –  REPEATS X AMT OF TIMES

          SETRLRSEG

          EXAMPLE OF INSLOOP:

          INSSEG

          REFLOOP    – REPEATS X AMT OF TIMES

          DTPLOOP   – REPEATS WHILE… LOGIC

          NM1SEG

          PERSEG

          ETC….

          Hope that helps.. it took quite a while to get this just right, so keep tweaking!

          Brenda

        • #84899
          Brenda Carpenter
          Participant

            Forgot to answer the other two questions,

            I modified the X12 variant to include the ISA/IEA and formatted them to receivers spec in the xlate

            and yes, I used a counter for the total record count on the trailers.

            PM me if you need more detailed info!

            -Brenda

          • #84900
            Lisa Heaton
            Participant

              Thank you Brenda, I’ll give it a shot.

          Viewing 2 reply threads
          • The forum ‘Cloverleaf’ is closed to new topics and replies.