I have an xml map that looks like: (partial)
<ColumnMap Node="REASON" Column="REASON"/>
<ColumnMap Node="ODOMETER" Column="ODOMETER"/>
<ColumnMap Node="TRAVELTIME" Column="TRAVELTIME"/>
The record is built and each of the Columns is a dictionary item.
The xml used to look like this (partial):
<VEHICLE ID="23485">
<REASON>u</REASON>
<ODOMETER>39781632</ODOMETER>
<TRAVELTIME>3406182</TRAVELTIME>
</VEHICLE>
and the record looks like this (partial):
0013: u
0014: 39781632
0015: 3406182
(Has worked fine for years!)
The vendor has just has changed the driver and driver status to this (partial)
inside a PARAMS tag.
............................
<VEHICLE ID="23485">
<REASON>u</REASON>
<ODOMETER>39781632</ODOMETER>
<TRAVELTIME>3406182</TRAVELTIME>
<PARAMS>
<PARAM name="Driver ID">1234</PARAM>
<PARAM name="Driver Name">5599 FRANKLIN, WADE</PARAM>
<PARAM name="Driver Status">Logout</PARAM>
</PARAMS>
</VEHICLE>
To my map I added:
<ColumnMap Node="PARAMS" Column="PARAM"/>
And I added a dictionary item called PARAM.
I now get 3 blank lines returned in the new dictionary field.
(I was willing to parse it myself as there can be other things in the PARAMS
besides driver info)
I've tried lots of stuff in the map like: ..Node="PARAMS/PARAM" etc but the
program usually bombs.
Does anyone have something I could try? Do I need a more complete path to the
new items?
thanks so much,
Nancy
[EMAIL PROTECTED]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
