Hi Nancy,
I would add a dictionary item NAME giving it the next available attribute
number and it would be multivalued and associated to the phrase PARAMS.
I would make the dictionary item PARM multivalued and associated to the
phrase PARAMS
I would replace your line : <ColumnMap Node="PARAMS" Column="PARAM"/>
with these 2 lines:
<ColumnMap Node="PARMS/PARM,@name" Column="NAME"/>
<ColumnMap Node="PARMS/PARM,text()" Column="PARM"/>
After you run DBTOXML - You should have in the field NAME - Driver
ID]Driver Name]Driver Status
and you should have in the field PARM - 1234]5599 FRANKLIN, WADE]Logout
The dictionary items:
NAME
1.D
2.12
3.
4.NAME
5.10L
6.MV
7.PARMS
PARM
1.D
2.13
3.
4.PARM
5.10L
6.MV
7.PARAMS
PARMS
1.PH
2.NAME PARM
Date: Fri, 20 Jun 2008 09:53:11 -0700
From: "Nancy Fisher" <[EMAIL PROTECTED]>
Subject: [U2] 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]
[demime 1.01d removed an attachment of type image/jpeg which had a name of
1A016710.jpg]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
