Subject:Convertic EDI files into XML Author:Rob den Boer Date:14 Apr 2009 10:35 AM
I am evaluating Stylus Studio to see if this software can do the job for us.
I have watched the EDI to XML video, and started my own conversion, I converted the EDI to XML, and I am working with xQuery to map the data in the required XML format.
I want to know how to deal with multiple segments, for instance in the EDI file:
DTM+11:20090406:102'
DTM+17:20090406:102'
DTM+137:200904061319:203'
translates to:
<DTM>
<DTM01>
<DTM0101><!--2005: Date/time/period qualifier-->11<!--Despatch date and/or time--></DTM0101>
<DTM0102><!--2380: Date/time/period-->20090406</DTM0102>
<DTM0103><!--2379: Date/time/period format qualifier-->102<!--CCYYMMDD--></DTM0103>
</DTM01>
</DTM>
<DTM>
<DTM01>
<DTM0101><!--2005: Date/time/period qualifier-->17<!--Delivery date/time, estimated--></DTM0101>
<DTM0102><!--2380: Date/time/period-->20090406</DTM0102>
<DTM0103><!--2379: Date/time/period format qualifier-->102<!--CCYYMMDD--></DTM0103>
</DTM01>
</DTM>
<DTM>
<DTM01>
<DTM0101><!--2005: Date/time/period qualifier-->137<!--Document/message date/time--></DTM0101>
<DTM0102><!--2380: Date/time/period-->200904061319</DTM0102>
<DTM0103><!--2379: Date/time/period format qualifier-->203<!--CCYYMMDDHHMM--></DTM0103>
</DTM01>
</DTM>
Now I want to map the first DTM segment with qualifier 11 to a field in my xQuery target. Now I get all DTM segments.
Subject:Convertic EDI files into XML Author:Rob den Boer Date:22 Apr 2009 03:38 AM
Hi Ivan,
When I put the predicate expression in my xQuery, it worked.
However I donot get the visual XPath predicate to work in the mapper.
I connect the output to my date field in the target.
then connect my datefield to data.
connect the qualifier to the predictate, and change the value so that is reads the requested qualifier 137.
the xQuery code remains empty, like: created="{}"
so I guess I am not using the tool correctly?