将平面 XML 转换为嵌套 XML [英] Converting a Flat XML to a Nested XML

问题描述

我想弄清楚如何使用 xslt 将平面 xml 文件转换为嵌套的 xml 文件.下面是我试图转换的平面 xml 的示例.我正在使用 xslt 2，所以我可以使用分组命令，但我不知道如何.

I'm trying to figure out how to convert a flat xml file to a nested xml file using xslt. Below is an example of the flat xml that I'm trying to transform. I'm using xslt 2 so I can us the grouping commands but I don't know how.

我正在寻找的结果结构是:

The resulting structure I'm looking for is:

<sources>
 <sourcetype>
   <sourcetypename>Career Fair</sourcetypename>
   <sourcelist>
     <source>
     <sourcename>Ann Arbor News Fair</sourcename>
     <sourceid>CFE-10001</sourceid>
     <eventlist>
       <event>
         <eventname></eventname>
         <eventid></eventid>
       </event>
     </eventlist>
     </source>
   </sourcelist>
</sourcetype>
</sources>

--- 平面 XML ----

--- Flat XML ----

<?xml version="1.0" encoding="UTF-8"?>
<ExportXML xmlns:ns1="http://www.taleo.com/ws/integration/toolkit/2005/07" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.taleo.com/ws/integration/toolkit/2005/07" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <record>
        <field name="TypeName">Billboards</field>
        <field name="SourceName">Billboard</field>
        <field name="SourceID">BLD-200284</field>
        <field name="EventName"></field>
        <field name="EventID"></field>
        <field name="State">Active</field>
    </record>
    <record>
        <field name="TypeName">Career Fair</field>
        <field name="SourceName">Ann Arbor News Fair</field>
        <field name="SourceID">CFE-10001</field>
        <field name="EventName"></field>
        <field name="EventID"></field>
        <field name="State">Active</field>
    </record>
    <record>
        <field name="TypeName">Career Fair</field>
        <field name="SourceName">Black Data Processing Association (BDPA) </field>
        <field name="SourceID">CFE-10002</field>
        <field name="EventName"></field>
        <field name="EventID"></field>
        <field name="State">Active</field>
    </record>
    <record>
        <field name="TypeName">Career Fair</field>
        <field name="SourceName">Career Concepts</field>
        <field name="SourceID">CFE-10760</field>
        <field name="EventName"></field>
        <field name="EventID"></field>
        <field name="State">Active</field>
    </record>
    </ExportXML>

推荐答案

嵌套一堆 for-each-group 元素开始看起来很讨厌，但它完成了工作:

Nesting a bunch of for-each-group elements starts to look pretty nasty, but it gets the job done:

<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:t="http://www.taleo.com/ws/integration/toolkit/2005/07">
    <xsl:output omit-xml-declaration="yes" indent="yes"/>
    <xsl:template match="/">
        <sources>
            <xsl:for-each-group select="/*/t:record"
                group-by="t:field[@name='TypeName']">
                <sourcetype>
                    <sourcetypename>
                        <xsl:value-of select="current-grouping-key()"/>
                    </sourcetypename>
                    <sourcelist>
                        <xsl:for-each-group select="current-group()"
                            group-by="t:field[@name='SourceID']">
                            <source>
                                <sourcename>
                                    <xsl:value-of select="t:field[@name='SourceName']"/>
                                </sourcename>
                                <sourceid>
                                    <xsl:value-of select="current-grouping-key()"/>
                                </sourceid>
                                <eventlist>
                                    <xsl:for-each-group
                                        select="current-group()" group-by="t:field[@name='EventID']">
                                        <event>
                                            <eventname>
                                                <xsl:value-of
                                                    select="t:field[@name='EventName']"/>
                                            </eventname>
                                            <eventid>
                                                <xsl:value-of
                                                    select="current-grouping-key()"/>
                                            </eventid>
                                        </event>
                                    </xsl:for-each-group>
                                </eventlist>
                            </source>
                        </xsl:for-each-group>
                    </sourcelist>
                </sourcetype>
            </xsl:for-each-group>
        </sources>
    </xsl:template>
</xsl:stylesheet>

输出:

<sources xmlns:t="http://www.taleo.com/ws/integration/toolkit/2005/07">
   <sourcetype>
      <sourcetypename>Billboards</sourcetypename>
      <sourcelist>
         <source>
            <sourcename>Billboard</sourcename>
            <sourceid>BLD-200284</sourceid>
            <eventlist>
               <event>
                  <eventname/>
                  <eventid/>
               </event>
            </eventlist>
         </source>
      </sourcelist>
   </sourcetype>
   <sourcetype>
      <sourcetypename>Career Fair</sourcetypename>
      <sourcelist>
         <source>
            <sourcename>Ann Arbor News Fair</sourcename>
            <sourceid>CFE-10001</sourceid>
            <eventlist>
               <event>
                  <eventname/>
                  <eventid/>
               </event>
            </eventlist>
         </source>
         <source>
            <sourcename>Black Data Processing Association (BDPA) </sourcename>
            <sourceid>CFE-10002</sourceid>
            <eventlist>
               <event>
                  <eventname/>
                  <eventid/>
               </event>
            </eventlist>
         </source>
         <source>
            <sourcename>Career Concepts</sourcename>
            <sourceid>CFE-10760</sourceid>
            <eventlist>
               <event>
                  <eventname/>
                  <eventid/>
               </event>
            </eventlist>
         </source>
      </sourcelist>
   </sourcetype>
</sources>

这篇关于将平面 XML 转换为嵌套 XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！