| Newsgroups |
gmane.text.xml.xsl.general.mulberrytech |
| Message-ID |
<[email protected]> |
------=_Part_476898_837908739.1621641650655
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
=20
Hi, Martin:
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 The purp=
osesof flattening the XML are:
1.=C2=A0=C2=A0=C2=A0=C2=A0After the $keepAttr is flattened to element (ther=
ewill not be any attribute ), I can further transform the flattened XML to =
JSON.That is the purpose of this post:
https://stackoverflow.com/questions/67145900/xquery-constructs-string-objec=
t-with-sequential-ancestor-node-names
The original <businessCenters> will be transformed to JSON array.
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 <calculationPeriodDatesAdjustments>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <businessDayConvention>PRECEDING</b=
usinessDayConvention>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <businessCenters id=3D"businessCent=
ers">
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <businessCenter>USNY</b=
usinessCenter>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <businessCenter>GBLO</b=
usinessCenter>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </businessCenters>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 </calculationPeriodDatesAdjustments>
=C2=A0
It is legitimate to transform id as child element of <businessCenters>. But=
data transformation is not just for convenience,if I transform that id out=
of <businessCenters> as a sibling of <businessDayConvention>. =C2=A0The co=
ntext of id=C2=A0 is completed lost. In asearch engine, index =E2=80=9Croot=
/businessCenters/id=E2=80=9D vs =E2=80=9Croot/id=E2=80=9D returns different=
value.=C2=A0=20
On Friday, May 21, 2021, 10:35:53 a.m. MST, Martin Honnen martin.honnen=
@gmx.de <[email protected]> wrote:=20=20
=20
On 21.05.2021 16:30, Sam Spade [email protected] wrote:
> |The transformation logic:
> |||
>
> |
> 1) transform namespace
>
> 2) transform root element
>
> 3) transform the selected attribute(s) to element (the attribute name is
> parameterised not hard-coded)
>
> 4) the transformed element shouldn't contain both other element
> (transformed from the attribute) and its original data
> |
>
> |
> The desired result:
>
> |<requestProduct xmlns=3D"http://fc.fasset/product"> <trade> <cal>
> <c>PRECEDING</c> <bcs> <id>businessCenters</id> <bc>USNY</bc>
> <bc>GBLO</bc> </bcs> </cal> <amount> *<currency>USD</currency>
> <id>settlementCurrency</id>*
> <referenceAmount>StandardISDA</referenceAmount>
> <cashSettlement>true</cashSettlement> </amount> </trade> </requestProduct=
>|
>
> What is wrong with my module? How can I transform the input to the
> desired result? |
What is the criteria to transform an attribute to a child element of its
parent as is done for the "id" of the "bcs" element and what is the
criteria for the other choice, to not include the new element as a child
but to make it a sibling of the (previous) parent element?
=20=20
--~----------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
EasyUnsubscribe: http://lists.mulberrytech.com/unsub/xsl-list/3329386
or by email: [email protected]
--~--
------=_Part_476898_837908739.1621641650655
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div class=3D"ydpe5c22d3ayahoo-style-wrap" style=
=3D"font-family:bookman old style, new york, times, serif;font-size:13px;">=
<div></div>
<div dir=3D"ltr" data-setdir=3D"false"><div><p class=3D"ydpf036d6de=
yiv9501170214ydpa3d97190MsoNormal"><font size=3D"3" face=3D"Helvetica Neue,=
Helvetica, Arial, sans-serif">Hi, Martin:</font></p><font size=3D"3" face=
=3D"Helvetica Neue, Helvetica, Arial, sans-serif">
</font><p class=3D"ydpf036d6deyiv9501170214ydpa3d97190MsoNormal"><font size=
=3D"3" face=3D"Helvetica Neue, Helvetica, Arial, sans-serif"><span> &n=
bsp; </span>The purpo=
ses
of flattening the XML are:</font></p><font size=3D"3" face=3D"Helvetica Neu=
e, Helvetica, Arial, sans-serif">
</font><p class=3D"ydpf036d6deyiv9501170214ydpa3d97190MsoListParagraph"><fo=
nt size=3D"3" face=3D"Helvetica Neue, Helvetica, Arial, sans-serif"><span><=
span>1.<span style=3D"font-style:normal;font-weight:normal;font-stretch:nor=
mal;font-size:7pt;line-height:normal;font-size-adjust:none;"> &n=
bsp;
</span></span></span>After the $keepAttr is flattened to element (there
will not be any attribute ), I can further transform the flattened XML to J=
SON.
That is the purpose of this post:</font></p>
<p class=3D"ydpf036d6deyiv9501170214ydpa3d97190MsoNormal"><span class=3D"yd=
pf036d6deyiv9501170214ydpa3d97190MsoHyperlink"><a shape=3D"rect" href=3D"ht=
tps://stackoverflow.com/questions/67145900/xquery-constructs-string-object-=
with-sequential-ancestor-node-names" rel=3D"nofollow" target=3D"_blank">htt=
ps://stackoverflow.com/questions/67145900/xquery-constructs-string-object-w=
ith-sequential-ancestor-node-names</a></span></p><font size=3D"3" face=3D"H=
elvetica Neue, Helvetica, Arial, sans-serif">The original </font><span styl=
e=3D"font-size:12pt;line-height:150%;font-family:Times New Roman, serif;col=
or:rgb(0, 0, 150);background-color:white;background-repeat:repeat;backgroun=
d-attachment:scroll;background-image:none;background-size:auto;"><busine=
ssCenters</span><span style=3D"font-family:Courier New;">> </span><font =
size=3D"3" face=3D"Helvetica Neue, Helvetica, Arial, sans-serif">will be tr=
ansformed to JSON array.</font>
<p class=3D"ydpf036d6deyiv9501170214ydpa3d97190MsoNormal" style=3D"margin:0=
in;line-height:normal;background-color:white;background-repeat:repeat;backg=
round-attachment:scroll;background-image:none;background-size:auto;"><span =
style=3D"font-size:12pt;font-family:Times New Roman, serif;color:black;back=
ground-color:white;background-repeat:repeat;background-attachment:scroll;ba=
ckground-image:none;background-size:auto;"><span> &n=
bsp;  =
; </span></span><span style=3D"font-size:12pt;font-family:Times New Roman, =
serif;color:rgb(0, 0, 150);background-color:white;background-repeat:repeat;=
background-attachment:scroll;background-image:none;background-size:auto;">&=
lt;calculationPeriodDatesAdjustments></span><span style=3D"font-size:12p=
t;font-family:Times New Roman, serif;color:black;background-color:white;bac=
kground-repeat:repeat;background-attachment:scroll;background-image:none;ba=
ckground-size:auto;"><br clear=3D"none">
<span> &nb=
sp; </span></span><span style=3D"=
font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, 150);back=
ground-color:white;background-repeat:repeat;background-attachment:scroll;ba=
ckground-image:none;background-size:auto;"><businessDayConvention></s=
pan><span style=3D"font-size:12pt;font-family:Times New Roman, serif;color:=
black;background-color:white;background-repeat:repeat;background-attachment=
:scroll;background-image:none;background-size:auto;">PRECEDING</span><span =
style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, =
150);background-color:white;background-repeat:repeat;background-attachment:=
scroll;background-image:none;background-size:auto;"></businessDayConvent=
ion></span><span style=3D"font-size:12pt;font-family:Times New Roman, se=
rif;color:black;background-color:white;background-repeat:repeat;background-=
attachment:scroll;background-image:none;background-size:auto;"><br clear=3D=
"none">
<span> &nb=
sp; </span></span><span style=3D"=
font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, 150);back=
ground-color:white;background-repeat:repeat;background-attachment:scroll;ba=
ckground-image:none;background-size:auto;"><businessCenters</span><span =
style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(245, 1=
32, 76);background-color:white;background-repeat:repeat;background-attachme=
nt:scroll;background-image:none;background-size:auto;"> id</span><span styl=
e=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(255, 128, =
64);background-color:white;background-repeat:repeat;background-attachment:s=
croll;background-image:none;background-size:auto;">=3D</span><span style=3D=
"font-size:12pt;font-family:Times New Roman, serif;color:rgb(153, 51, 0);ba=
ckground-color:white;background-repeat:repeat;background-attachment:scroll;=
background-image:none;background-size:auto;">"businessCenters"</span><span =
style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, =
150);background-color:white;background-repeat:repeat;background-attachment:=
scroll;background-image:none;background-size:auto;">></span><span style=
=3D"font-size:12pt;font-family:Times New Roman, serif;color:black;backgroun=
d-color:white;background-repeat:repeat;background-attachment:scroll;backgro=
und-image:none;background-size:auto;"><br clear=3D"none">
<span> &nb=
sp; </span></span><sp=
an style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, =
0, 150);background-color:white;background-repeat:repeat;background-attachme=
nt:scroll;background-image:none;background-size:auto;"><businessCenter&g=
t;</span><span style=3D"font-size:12pt;font-family:Times New Roman, serif;c=
olor:black;background-color:white;background-repeat:repeat;background-attac=
hment:scroll;background-image:none;background-size:auto;">USNY</span><span =
style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, =
150);background-color:white;background-repeat:repeat;background-attachment:=
scroll;background-image:none;background-size:auto;"></businessCenter>=
</span><span style=3D"font-size:12pt;font-family:Times New Roman, serif;col=
or:black;background-color:white;background-repeat:repeat;background-attachm=
ent:scroll;background-image:none;background-size:auto;"><br clear=3D"none">
<span> &nb=
sp; </span></span><sp=
an style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, =
0, 150);background-color:white;background-repeat:repeat;background-attachme=
nt:scroll;background-image:none;background-size:auto;"><businessCenter&g=
t;</span><span style=3D"font-size:12pt;font-family:Times New Roman, serif;c=
olor:black;background-color:white;background-repeat:repeat;background-attac=
hment:scroll;background-image:none;background-size:auto;">GBLO</span><span =
style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, =
150);background-color:white;background-repeat:repeat;background-attachment:=
scroll;background-image:none;background-size:auto;"></businessCenter>=
</span><span style=3D"font-size:12pt;font-family:Times New Roman, serif;col=
or:black;background-color:white;background-repeat:repeat;background-attachm=
ent:scroll;background-image:none;background-size:auto;"><br clear=3D"none">
<span> &nb=
sp; </span></span><span style=3D"=
font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, 150);back=
ground-color:white;background-repeat:repeat;background-attachment:scroll;ba=
ckground-image:none;background-size:auto;"></businessCenters></span><=
span style=3D"font-size:12pt;font-family:Times New Roman, serif;color:black=
;background-color:white;background-repeat:repeat;background-attachment:scro=
ll;background-image:none;background-size:auto;"><br clear=3D"none">
<span> &nb=
sp; </span></span><span style=3D"font-size:12=
pt;font-family:Times New Roman, serif;color:rgb(0, 0, 150);background-color=
:white;background-repeat:repeat;background-attachment:scroll;background-ima=
ge:none;background-size:auto;"></calculationPeriodDatesAdjustments></=
span></p>
<p class=3D"ydpf036d6deyiv9501170214ydpa3d97190MsoNormal" style=3D"margin:0=
in;line-height:normal;background-color:white;background-repeat:repeat;backg=
round-attachment:scroll;background-image:none;background-size:auto;"><span =
style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(0, 0, =
150);background-color:white;background-repeat:repeat;background-attachment:=
scroll;background-image:none;background-size:auto;"> </span></p>
<div class=3D"ydpf036d6deyiv9501170214ydpa3d97190MsoNormal" style=3D"margin=
:0in;line-height:normal;background-color:white;background-repeat:repeat;bac=
kground-attachment:scroll;background-image:none;background-size:auto;"><fon=
t size=3D"3" face=3D"Helvetica Neue, Helvetica, Arial, sans-serif"><span st=
yle=3D"color:black;">It is legitimate to transform </span></font><span styl=
e=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb(245, 132, =
76);background-color:white;background-repeat:repeat;background-attachment:s=
croll;background-image:none;background-size:auto;">id</span><span style=3D"=
color:black;"> <font style=3D"background-color:inherit;" size=3D"3" face=3D=
"Helvetica Neue, Helvetica, Arial, sans-serif">as child element of </font><=
/span><span style=3D"font-size:12pt;font-family:Times New Roman, serif;colo=
r:rgb(0, 0, 150);background-color:white;background-repeat:repeat;background=
-attachment:scroll;background-image:none;background-size:auto;"><busines=
sCenters</span><span style=3D"font-family:Courier New;color:black;">><fo=
nt style=3D"background-color:inherit;" size=3D"3" face=3D"Helvetica Neue, H=
elvetica, Arial, sans-serif">.</font></span><font size=3D"3" face=3D"Helvet=
ica Neue, Helvetica, Arial, sans-serif"><span style=3D"color:black;"> But d=
ata transformation is not just for convenience,
if I transform that </span></font><span style=3D"font-size:12pt;font-family=
:Times New Roman, serif;color:rgb(245, 132, 76);background-color:white;back=
ground-repeat:repeat;background-attachment:scroll;background-image:none;bac=
kground-size:auto;">id</span><span style=3D"color:black;"> <font style=3D"b=
ackground-color:inherit;" size=3D"3" face=3D"Helvetica Neue, Helvetica, Ari=
al, sans-serif">out of </font></span><span style=3D"font-size:12pt;font-fam=
ily:Times New Roman, serif;color:rgb(0, 0, 150);background-color:white;back=
ground-repeat:repeat;background-attachment:scroll;background-image:none;bac=
kground-size:auto;"><businessCenters</span><span style=3D"font-family:Co=
urier New;color:black;">> </span><font size=3D"3" face=3D"Helvetica Neue=
, Helvetica, Arial, sans-serif"><span style=3D"color:black;">as a sibling o=
f</span></font><span style=3D"font-family:Courier New;color:black;"> </span=
><span style=3D"font-size:12pt;font-family:Times New Roman, serif;color:rgb=
(0, 0, 150);background-color:white;background-repeat:repeat;background-atta=
chment:scroll;background-image:none;background-size:auto;"><businessDayC=
onvention></span><span style=3D"font-size:12.0pt;font-family:Times New R=
oman, serif;color:#000096;">.</span><span style=3D"font-family:Courier New;=
color:black;"> </span><font size=3D"3" face=3D"Helvetica Neue, Helvetica, A=
rial, sans-serif"><span style=3D"color:black;"><span> </span>The conte=
xt of <span><font style=3D"background-color:inherit;" size=3D"3" face=3D"He=
lvetica Neue, Helvetica, Arial, sans-serif"><span style=3D"color:black;"></=
span></font><span style=3D"font-size:12pt;font-family:Times New Roman, seri=
f;color:rgb(245, 132, 76);background-color:white;background-repeat:repeat;b=
ackground-attachment:scroll;background-image:none;background-size:auto;">id=
</span></span> is completed lost. In a
search engine, index =E2=80=9Croot/businessCenters/id=E2=80=9D vs =E2=80=9C=
root/id=E2=80=9D returns different
value. <span><br></span></span></font></div></div><div><br></div></di=
v><div><br></div>
=20=20=20=20=20=20=20=20
</div><div id=3D"ydp86f890e7yahoo_quoted_2622390277" class=3D"ydp86=
f890e7yahoo_quoted">
<div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20=20
<div>
On Friday, May 21, 2021, 10:35:53 a.m. MST, Martin Honn=
en [email protected] <[email protected]> wro=
te:
</div>
<div><br></div>
<div><br></div>
<div><div dir=3D"ltr">On 21.05.2021 16:30, Sam Spade <a sha=
pe=3D"rect" href=3D"mailto:[email protected]" rel=3D"nofollow" target=
=3D"_blank">[email protected]</a> wrote:<br clear=3D"none">> |The =
transformation logic:<br clear=3D"none">> |||<br clear=3D"none">><br =
clear=3D"none">> |<br clear=3D"none">> 1) transform namespace<br clea=
r=3D"none">><br clear=3D"none">> 2) transform root element<br clear=
=3D"none">><br clear=3D"none">> 3) transform the selected attribute(s=
) to element (the attribute name is<br clear=3D"none">> parameterised no=
t hard-coded)<br clear=3D"none">><br clear=3D"none">> 4) the transfor=
med element shouldn't contain both other element<br clear=3D"none">> (tr=
ansformed from the attribute) and its original data<br clear=3D"none">> =
|<br clear=3D"none">><br clear=3D"none">> |<br clear=3D"none">> Th=
e desired result:<br clear=3D"none">><br clear=3D"none">> |<reques=
tProduct xmlns=3D"<a shape=3D"rect" href=3D"http://fc.fasset/product" rel=
=3D"nofollow" target=3D"_blank">http://fc.fasset/product</a>"> <trade=
> <cal><br clear=3D"none">> <c>PRECEDING</c> <bc=
s> <id>businessCenters</id> <bc>USNY</bc><br cle=
ar=3D"none">> <bc>GBLO</bc> </bcs> </cal> <am=
ount> *<currency>USD</currency><br clear=3D"none">> <i=
d>settlementCurrency</id>*<br clear=3D"none">> <referenceAmo=
unt>StandardISDA</referenceAmount><br clear=3D"none">> <cash=
Settlement>true</cashSettlement> </amount> </trade> &l=
t;/requestProduct>|<br clear=3D"none">><br clear=3D"none">> What i=
s wrong with my module? How can I transform the input to the<br clear=3D"no=
ne">> desired result? |<br clear=3D"none"><br clear=3D"none">What is the=
criteria to transform an attribute to a child element of its<br clear=3D"n=
one">parent as is done for the "id" of the "bcs" element and what is the<br=
clear=3D"none">criteria for the other choice, to not include the new eleme=
nt as a child<br clear=3D"none">but to make it a sibling of the (previous) =
parent element?<br clear=3D"none"><br clear=3D"none"><br clear=3D"none"></d=
iv></div></div>
</div>
</div></body></html>
<div><!-- begin bl.html.trailer -->
<div style=3D"border-top:1px solid black; background-color: #dddddd;
color: #888888; font-size: smaller; padding: 5px; text-align: center;
font-family: arial,verdana,arial,sans-serif; margin-top:1em; clear:
both; margin: auto">
<a href=3D"http://www.mulberrytech.com/xsl/xsl-list">
XSL-List info and archive</a>
<div style=3D"text-align:center;">
<a style=3D"color: blue;"
href=3D"http://lists.mulberrytech.com/unsub/xsl-list/3329386"
>EasyUnsubscribe</a>
(<a style=3D"color: blue;"
href=3D"mailto:[email protected]?subject=3Dremove"
>by email</a>)
</div>
</div>
<!-- end bl.html.trailer --></div>
------=_Part_476898_837908739.1621641650655--