How to use XSLT to convert a XML to Table [CODE UPDATED 11/6] -

-

i have xml file want convert table or csv xslt. tried altova mapforce 2014to map columns still,not able gen out outcomes. lot.

xml file have

<records>     <person id="756252" date="15-oct-2014">         <gender>male</gender>         <namedetails>             <name nametype="primary name">                 <namevalue>                     <firstname>ken</firstname>                     <surname>wu</surname>                 </namevalue>             </name>             <name nametype="aka">                 <namevalue>                     <firstname>kenneth</firstname>                     <surname>wu</surname>                 </namevalue>             </name>             <name nametype="aka2">                 <namevalue>                     <firstname>can</firstname>                     <surname>wu</surname>                 </namevalue>             </name>         </namedetails>         <descriptions>             <description description1="11" description2="12" description3="13"/>             <description description1="21" description2="22" description3="23"/>             <description description1="31" description2="32" description3="33"/>         </descriptions>         <datedetails>         <date datetype="date of birth">             <datevalue year="1990" />             <datevalue year="1991" />         </date>         <date datetype="date of issue">             <datevalue year="2000" />             <datevalue year="2001" />         </date>         </datedetails>     </person>     <person id="253555" date="14-oct-2014">         <gender>male</gender>         <namedetails>             <name nametype="primary name">                 <namevalue>                     <firstname>peter</firstname>                     <surname>lai</surname>                 </namevalue>             </name>         </namedetails>         <descriptions>             <description description1="11" description2="12" description3="13"/>             <description description1="21" description2="22"/>         </descriptions>         <date datetype="date of birth">             <datevalue year="1992" />         </date>     </person> </records>

expected outcome

|id     |date        |gender |nametype     |firstname |surname |description1 |description2 |description3 |datetype      |year| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |11           |12           |13           |date of birth |1990| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |21           |22           |23           |date of birth |1990| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |31           |32           |33           |date of birth |1990| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |11           |12           |13           |date of birth |1990| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |21           |22           |23           |date of birth |1990| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |31           |32           |33           |date of birth |1990| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |11           |12           |13           |date of birth |1990| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |21           |22           |23           |date of birth |1990| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |31           |32           |33           |date of birth |1990| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |11           |12           |13           |date of issue |1991| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |21           |22           |23           |date of issue |1991| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |31           |32           |33           |date of issue |1991| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |11           |12           |13           |date of issue |1991| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |21           |22           |23           |date of issue |1991| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |31           |32           |33           |date of issue |1991| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |11           |12           |13           |date of issue |1991| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |21           |22           |23           |date of issue |1991| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |31           |32           |33           |date of issue |1991| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |11           |12           |13           |date of issue |2000| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |21           |22           |23           |date of issue |2000| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |31           |32           |33           |date of issue |2000| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |11           |12           |13           |date of issue |2000| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |21           |22           |23           |date of issue |2000| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |31           |32           |33           |date of issue |2000| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |11           |12           |13           |date of issue |2000| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |21           |22           |23           |date of issue |2000| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |31           |32           |33           |date of issue |2000| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |11           |12           |13           |date of issue |2001| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |21           |22           |23           |date of issue |2001| |756252 |15-oct-2014 |male   |primary name |ken       |wu      |31           |32           |33           |date of issue |2001| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |11           |12           |13           |date of issue |2001| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |21           |22           |23           |date of issue |2001| |756252 |15-oct-2014 |male   |aka          |kenneth   |wu      |31           |32           |33           |date of issue |2001| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |11           |12           |13           |date of issue |2001| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |21           |22           |23           |date of issue |2001| |756252 |15-oct-2014 |male   |aka2         |can       |wu      |31           |32           |33           |date of issue |2001| |253555 |14-oct-2014 |male   |primary name |peter     |lai     |11           |12           |13           |date of issue |1992| |253555 |14-oct-2014 |male   |primary name |peter     |lai     |21           |22           |             |date of issue |1992|

xsl create testing

<?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform">  <xsl:template match="/">   <html>    <head>     <title>records</title>    </head>    <body>     <table border="1">      <tr>       <th>id</th>       <th>date</th>       <th>gender</th>       <th>nametype</th>       <th>firstname</th>       <th>surname</th>       <th>description1</th>       <th>description2</th>       <th>description3</th>      </tr>      <xsl:for-each select="records/person/namedetails/name">      <tr>       <td><xsl:value-of select="../../@id"/></td>       <td><xsl:value-of select="../../@date"/></td>       <td><xsl:value-of select="../../gender"/></td>       <td><xsl:value-of select="@nametype"/></td>       <td><xsl:value-of select="namevalue/firstname"/></td>       <td><xsl:value-of select="namevalue/surname"/></td>       <td><xsl:value-of select="../../descriptions/description/@description1"/></td>       <td><xsl:value-of select="../../descriptions/description/@description2"/></td>       <td><xsl:value-of select="../../descriptions/description/@description3"/></td>      </tr>      </xsl:for-each>     </table>    </body>   </html>  </xsl:template> </xsl:stylesheet>

you need 2 nested loops here:

... <xsl:for-each select="records/person/namedetails/name">     <xsl:variable name="nametype" select="@nametype"/>     <xsl:variable name="firstname" select="namevalue/firstname"/>     <xsl:variable name="surname" select="namevalue/surname"/>         <xsl:for-each select="../../descriptions/description">             <tr>                 <td><xsl:value-of select="../../@id"/></td>                 <td><xsl:value-of select="../../@date"/></td>                 <td><xsl:value-of select="../../gender"/></td>                 <td><xsl:value-of select="$nametype"/></td>                 <td><xsl:value-of select="$firstname"/></td>                 <td><xsl:value-of select="$surname"/></td>                 <td><xsl:value-of select="@description1"/></td>                 <td><xsl:value-of select="@description2"/></td>                 <td><xsl:value-of select="@description3"/></td>             </tr>         </xsl:for-each> </xsl:for-each> ...

edit:

to avoid storing name details in individual variables, can do:

<xsl:for-each select="records/person/namedetails/name">     <xsl:variable name="name" select="."/>     <xsl:for-each select="../../descriptions/description">         <tr>             <td><xsl:value-of select="../../@id"/></td>             <td><xsl:value-of select="../../@date"/></td>             <td><xsl:value-of select="../../gender"/></td>             <td><xsl:value-of select="$name/@nametype"/></td>             <td><xsl:value-of select="$name/namevalue/firstname"/></td>             <td><xsl:value-of select="$name/namevalue/surname"/></td>             <td><xsl:value-of select="@description1"/></td>             <td><xsl:value-of select="@description2"/></td>             <td><xsl:value-of select="@description3"/></td>         </tr>     </xsl:for-each> </xsl:for-each>

edit 2:

here's example of 3 nested loops, adding dates have added in latest edit. 

<xsl:for-each select="records/person/namedetails/name">     <xsl:variable name="name" select="."/>     <xsl:for-each select="../../datedetails/date/datevalue">         <xsl:variable name="dateval" select="."/>         <xsl:for-each select="../../../descriptions/description">             <tr>                 <td><xsl:value-of select="../../@id"/></td>                 <td><xsl:value-of select="../../@date"/></td>                 <td><xsl:value-of select="../../gender"/></td>                 <td><xsl:value-of select="$name/@nametype"/></td>                 <td><xsl:value-of select="$name/namevalue/firstname"/></td>                 <td><xsl:value-of select="$name/namevalue/surname"/></td>                 <td><xsl:value-of select="@description1"/></td>                 <td><xsl:value-of select="@description2"/></td>                 <td><xsl:value-of select="@description3"/></td>                 <td><xsl:value-of select="$dateval/../@datetype"/></td>                 <td><xsl:value-of select="$dateval/@year"/></td>             </tr>         </xsl:for-each>     </xsl:for-each> </xsl:for-each>

Comments

Post a Comment

Popular posts from this blog

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
Read more

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more