Menu

#10 Conversion from Flat File to XML - some values in wrong fields...

1.0
closed
nobody
None
2019-12-03
2019-10-28
No

Hi
I took a flat file of an ORDERS D.01B message and converted it to XML.

The majority of value appear in the correct fields as far as I can determine. there are two in the attached XML that are not (they are repeats of the same segment, so bug is the same).

<s_imd>
<d_7077>F</d_7077>
<c_c273>
<d_3055>PRODUCT 1</d_3055>
</c_c273>
</s_imd>

As far as I can discern, the value PRODUCT1 should be in the field <d_7088>, <d_3055> is actually the "Code list responsible agency code" field and is maxLen 3.</d_3055></d_7088>

2 Attachments

Discussion

  • Brian Arthern

    Brian Arthern - 2019-10-28

    Hi
    I've done some experimenting and I believe the bug is that the parser is not factoring in that there is actually a field between the + and the :

    This is the line - IMD+F++:::PRODUCT 1'

    If I add a value between + and : like so

    IMD+F++A:::PRODUCT 1'

    Then it aligns correctly:

    <s_imd>
    <d_7077>F</d_7077>
    <c_c273>
    <d_7009>A</d_7009>
    <d_7008>PRODUCT 1</d_7008>
    </c_c273>
    </s_imd>

     
  • Matthias Fricke

    Matthias Fricke - 2019-12-03
    • status: open --> closed
     

Log in to post a comment.

MongoDB Logo MongoDB