Import XML into a DataWindow
Chris Werner
having never used DataWindow XML Import I wonder about the
limitations of this technique. I have to import a XML file containing
order headers and order items. So I thought I can achieve that using
a grouped DataWindow but that seems to be wrong. Here is a
shortened sample of the data I like to import:
<?xml version="1.0" encoding="utf-8"?>
<ORDER xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="http://www.healy-hudson.com/XMLSchema/Schlecker/1.1"
xsi:schemaLocation="http://www.healy-hudson.com/XMLSchema/Schlecker/1.1
file:///c:/Development/Ordering%20V3/V3.NET/Schlecker/Schlecker.Schemas/orderraw.xsd">
<ORDER_HEADER>
<ORDER_ID>BNR SL1</ORDER_ID>
...
</ORDER_HEADER>
<ORDER_ITEM_LIST>
<TASK>
<CUSTOMER_ORDER_ID>61616</CUSTOMER_ORDER_ID>
<DELIVERY_DATE>2008-12-30T06:00:50.153</DELIVERY_DATE>
<CUSTOMER_ID>4711</CUSTOMER_ID>
</TASK>
<TASK>
<CUSTOMER_ORDER_ID>99999</CUSTOMER_ORDER_ID>
<DELIVERY_DATE>2008-12-30T06:00:50.153</DELIVERY_DATE>
<CUSTOMER_ID>4712</CUSTOMER_ID>
</TASK>
</ORDER_ITEM_LIST>
</ORDER>
As you see the <TASK> structure occurs more than one time.
Thanks for any hint,
Chris Werner
f+s software gmbh
Bruce Armstrong
The DataWindow currently doesn't import nested data, it only exports
it. You might want to look at using the PBDOM method to load the data
and manipulate it into the datawindow.
On 7 Jan 2010 02:18:00 -0800, "Chris Werner"
<cwAT{PleaseNoSpam}f-s.de> wrote:
-----------------------------------
My Web 2.0 Stuff
Blog: http://bruce.pbdjmagazine.com/
Facebook: http://www.facebook.com/people/Bruce-Armstrong/1600223798
Fotki: http://public.fotki.com/brucearmstrong/
LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
Twitter: http://twitter.com/bruce_armstrong
YouTube: http://www.youtube.com/user/brucearmstrong