|
| I am trying to map XML to flat file format. I managed to
do this without any problems until I submitted an XML file
containing empty elements, at which point the resultant
flat file contains the TAGS of empty (or missing) mapped
XML elements without any delimiters, resulting in an
invalid file!
E.g.
<test>
<REC1 a="a"/>
<REC2 b="b"/>
<REC3/>
<REC4/>
<REC5/>
</test>
Ends up as:
REC1^a^b|REC2REC3REC4REC5|
(REC1-REC5 are tags of records in flat file spec)
Where is should be:
REC1^a^b|REC2|REC3|REC41
The record delimiter (shown as | but which is actually LF)
is set to postfix and the field delimiter is ^ set to
prefix.
Append NewLine is NO, Skip CR is YES, Skip Line Feed is NO.
Any help would be great as I just can't understand why
this is happening.
N.B all of the records in the flat file definition (which
is using standard custom) is set as min occurrence of 0
and max occurrence of 1 and all fields are set to not
required. Also an outbound envelope is specified and all
flat files are generated correctly where the mapped
elements contain >= 1 data item.
Thanks.
|
|