If I put this in the XML MAP:
<ColumnMap Node="PARAMS/PARAM/@name" Column="PARAM"/>
will return "Driver ID" but just the title - not the data of 1234.
AND THIS:
<ColumnMap Node="PARAMS/PARAM,@name" Column="PARAM"/>
brings back Driver Id @vm Driver Name @vm Driver Status: but titles only
- no data
Nancy
[EMAIL PROTECTED]
Subject: XML ISSUE
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/
