Cannot process 811 Transaction

May 24, 2013 at 4:17 PM
Edited May 24, 2013 at 4:57 PM
When I run the command line tool, it only outputs XML for the header part - not the actual data. Convert to hierarchy only produces 1 line.
Sample:
ISA*00*          *00*          *ZZ*STFM   SF00014 *ZZ*043028799AU    *130517*135
5*U*00304*000000038*0*T*:~GS*CI*LIENH811S000000*043028799*130517*1355*380001*X*0
03041~ST*811*0001~BIG*130517*1~N1*IN*STATE FARM INSURANCE*NI*25178~REF*BF*28~N1*
SQ*SOME CUSTOMER (AUTO)*FI*043028799~HL*1**1*1~NM1*LM*2*SOME BANK*****F
I*043028799~HL*2*1*2*1~NM1*AG*2*SOME PERSON*****93*0170~N3*1913 SILAS DE
ANE HWY~N4*ROCKY HILL*CT*060671309~PER*AM**TE*860-563-7283~HL*3*2*4*1~NM1*IL*1*C
ITRO*ANNETTE~N3*125 CAROLINE RD~N4*BOZRAH*CT*06334**RJ*28~IT1**1*IP*0~SI*AD*08*R
EW~SI*AD*09*CON~REF*NF*25178~REF*IG* 466249B2707A~DTM*007*130227***20~DTM*009*13
0326***20~HL*4*3*5*1~LX*1~VEH**1C3CCBCG2CN122380*20*12~PID*X**AD*VEHMK*CHRYSLER~
PID*X**AD*VEHMD*200~PID*X**AD*VEHTY*4DR~III*CV*COMP~AMT*PH*500~III*CV*COLL~AMT*P
H*500~III*CV*LP~HL*5*4*8*0~SLN*1**I*0*EA~NM1*LM*2*SOME BANK~TDS*1~SE*39
*0001~ST*811*0002~BIG*130517*1~N1*IN*STATE FARM INSURANCE*NI*25178~REF*BF*22~N1*
SQ*SOME CUSTOMER (AUTO)*FI*043028799~HL*1**1*1~NM1*LM*2*ANOTHER BANK
*****FI*043028799~N2*TRUST COMPANY~HL*2*1*2*1~NM1*AG*2*PAT THERIOT INSURANCE AGC
Y INC*****93*1801~N3*400 S MAIN ST STE A~N4*ST MARTINVLLE*LA*705824544~PER*AM**T
E*337-394-6006~HL*3*2*4*1~NM1*IL*1*PREJEAN*JEREMY*C~N3*1100 NURSERY HWY~N4*BREAU
X BRIDGE*LA*70517**RJ*22~IT1**1*IP*0~SI*AD*08*CER~SI*AD*09*CON~REF*NF*25178~REF*
IG*U040635C2018J~DTM*007*130322***20~DTM*009*130326***20~HL*4*3*5*1~LX*1~VEH**3G
TEC230X9G224079*20*09~PID*X**AD*VEHMK*GMC~PID*X**AD*VEHMD*C1500~PID*X**AD*VEHTY*
PICKUP~III*CV*COMP~AMT*PH*50~III*CV*COLL~AMT*PH*500~III*CV*LP~HL*5*4*8*0~SLN*1**
I*0*EA~NM1*LM*2*ANOTHER BANK~TDS*1~CTT*2~SE*41*0002~GE*2*380001~IEA*
1*000000038~
Here is the output:
<?xml version="1.0"?>
<Interchange segment-terminator=":" element-separator="*" sub-element-separator="*">
  <ISA>
    <!--Author Information Qualifier-->
    <ISA01>00<!--No Authorization Information Present--></ISA01>
    <!--Author Information-->
    <ISA02>          </ISA02>
    <!--Security Information Qualifer-->
    <ISA03>00<!--No Security Information Present--></ISA03>
    <!--Security Information-->
    <ISA04>          </ISA04>
    <!--Interchange ID Qualifier-->
    <ISA05>ZZ<!--Mutually Defined--></ISA05>
    <!--Interchange Sender ID-->
    <ISA06>STFM   SF00014 </ISA06>
    <!--Interchange ID Qualifier-->
    <ISA07>ZZ<!--Mutually Defined--></ISA07>
    <!--Interchange Receiver ID-->
    <ISA08>043028799AU    </ISA08>
    <!--Interchange Date-->
    <ISA09>130517</ISA09>
    <!--Interchange Time-->
    <ISA10>135
5</ISA10>
    <!--Inter Control Standards Identifier-->
    <ISA11>U<!--U.S. EDI Community of ASC X12, TDCC, and UCS--></ISA11>
    <!--Inter Control Version Number-->
    <ISA12>00304</ISA12>
    <!--Inter Control Number-->
    <ISA13>000000038</ISA13>
    <!--Acknowlegment Requested-->
    <ISA14>0<!--No Acknowledgment Requested--></ISA14>
    <!--Usage Indicator-->
    <ISA15>T<!--Test Data--></ISA15>
    <ISA16 />
  </ISA>
</Interchange>
Jun 1, 2013 at 1:00 AM
Any thoughts, suggestions, etc?
Jun 14, 2013 at 1:18 PM
bump
Coordinator
Jul 14, 2013 at 9:32 PM
I was able to parser and reformat your x12 message after I removed the extra endlines from your file:
ISA*00*          *00*          *ZZ*STFM   SF00014 *ZZ*043028799AU    *130517*1355*U*00304*000000038*0*T*:~
  GS*CI*LIENH811S000000*043028799*130517*1355*380001*X*003041~
    ST*811*0001~
      BIG*130517*1~
      N1*IN*STATE FARM INSURANCE*NI*25178~
        REF*BF*28~
      N1*SQ*SOME CUSTOMER (AUTO)*FI*043028799~
      TDS*1~
      HL*1**1*1~
        NM1*LM*2*SOME BANK*****FI*043028799~
        HL*2*1*2*1~
          NM1*AG*2*SOME PERSON*****93*0170~
            N3*1913 SILAS DEANE HWY~
            N4*ROCKY HILL*CT*060671309~
            PER*AM**TE*860-563-7283~
          HL*3*2*4*1~
            NM1*IL*1*CITRO*ANNETTE~
              N3*125 CAROLINE RD~
              N4*BOZRAH*CT*06334**RJ*28~
            IT1**1*IP*0~
              SI*AD*08*REW~
              SI*AD*09*CON~
              REF*NF*25178~
              REF*IG* 466249B2707A~
              DTM*007*130227***20~
              DTM*009*130326***20~
            HL*4*3*5*1~
              LX*1~
                VEH**1C3CCBCG2CN122380*20*12~
                PID*X**AD*VEHMK*CHRYSLER~
                PID*X**AD*VEHMD*200~
                PID*X**AD*VEHTY*4DR~
              III*CV*COMP~
                AMT*PH*500~
              III*CV*COLL~
                AMT*PH*500~
              III*CV*LP~
              HL*5*4*8*0~
                SLN*1**I*0*EA~
                  NM1*LM*2*SOME BANK~
    SE*39*0001~
    ST*811*0002~
      BIG*130517*1~
      N1*IN*STATE FARM INSURANCE*NI*25178~
        REF*BF*22~
      N1*SQ*SOME CUSTOMER (AUTO)*FI*043028799~
      TDS*1~
      HL*1**1*1~
        NM1*LM*2*ANOTHER BANK*****FI*043028799~
          N2*TRUST COMPANY~
        HL*2*1*2*1~
          NM1*AG*2*PAT THERIOT INSURANCE AGCY INC*****93*1801~
            N3*400 S MAIN ST STE A~
            N4*ST MARTINVLLE*LA*705824544~
            PER*AM**TE*337-394-6006~
          HL*3*2*4*1~
            NM1*IL*1*PREJEAN*JEREMY*C~
              N3*1100 NURSERY HWY~
              N4*BREAUX BRIDGE*LA*70517**RJ*22~
            IT1**1*IP*0~
              SI*AD*08*CER~
              SI*AD*09*CON~
              REF*NF*25178~
              REF*IG*U040635C2018J~
              DTM*007*130322***20~
              DTM*009*130326***20~
            HL*4*3*5*1~
              LX*1~
                VEH**3GTEC230X9G224079*20*09~
                PID*X**AD*VEHMK*GMC~
                PID*X**AD*VEHMD*C1500~
                PID*X**AD*VEHTY*PICKUP~
              III*CV*COMP~
                AMT*PH*50~
              III*CV*COLL~
                AMT*PH*500~
              III*CV*LP~
              HL*5*4*8*0~
                SLN*1**I*0*EA~
                  NM1*LM*2*ANOTHER BANK~
      CTT*2~
    SE*41*0002~
  GE*2*380001~
IEA*1*000000038~
I noticed that the way you have pasted the message in the file an end line occurs after every 80 characters. This is actually not allowed in X12. The ISA segment is fixed-witdh and must be exactly 126 characters. It looks for 3 delimiters in 3 precise locations within the first 126 characters.
I have had a few other users report this same problem, but it's because your sender is doing this for some reason as part of the transmission. You will need to remove these extra end line characters in some kind of pre-processing step.
Jul 15, 2013 at 2:28 AM
Thanks for answer.
Since these are not allowed, why not just remove all end lines from any file before you process it?
Coordinator
Jul 15, 2013 at 12:38 PM
End line characters are allowed as delimiters. But the X12 defines delimiters very specifically. The end segment delimiter must occur at position 107 in the file. So valid end line delimiters cannot be removed.

What is happening to your file is not part of valid X12 so the process of removing these end lines is to correct for some transmission protocol by your sender.

Because the first end-line got inserted within the first 126 characters it has invalidated the file.