Skip to Content
0
Former Member
Jul 24, 2014 at 09:57 PM

importstring with xml merging row data

38 Views

I have a simple XML import I'm trying to do, rather than manually parsing the data. There's a problem though. The following XML generates 3 rows in the datawindow instead of 4. I'm using a default template.

<?xml version="1.0"?><dw_tqxml>

<dw_tqxml_row><dosetime>AM</dosetime><qty>1</qty></dw_tqxml_row>

<dw_tqxml_row><dosetime>8pm</dosetime><qty>1.25</qty></dw_tqxml_row>

<dw_tqxml_row><dosetime>NOON</dosetime></dw_tqxml_row>

<dw_tqxml_row><qty>3.00</qty></dw_tqxml_row>

</dw_tqxml>

The first and second rows come out fine, the third row is a combination of the two last rows.

Here's the result data

"AM", "1"

"8pm", "1.25"

"NOON", "3.00"

dw sql is:

select space(10) as dosetime, space(10) as qty from dummy

It's my understanding that missing data should use the default values in the datawindow.

PB 12.5 Build 5583

Anyone have any ideas on why it's merging rows? This is the first time I've used XML import, don't really have a clue what I'm missing.