Replacing dummy attribute with string of xml

[jtric]

Very new to XML/XSL, so please forgive me if this is an incredibly simple question. I've been pulling my hair out over this for several days now.

I'm working on an internal application that takes the output from a custom Excel spreadsheet, and creates a Final Cut Pro sequence in XML. Due to the way Excel handles nested repeating elements, I need to find a way to replace a dummy element I have created with a whole series of repeating elements. I could use a simple find and replace text editor method, but I would prefer to take care of everything in the xslt transform if possible. Any ideas?

Thanks!


My existing XSL (which just strips out the empty tags) is posted at the bottom.

The code is as follows.

<effect>
    <name>Text</name>
    <effectid>Text</effectid>
    <effectcategory>Text</effectcategory>
    <effecttype>generator</effecttype>
    <mediatype>video</mediatype>
    <parameter>
              <parameterid>str</parameterid>
          <name>Text</name>
          <value>Tuesday at 10:00</value>
    </parameter>
    <dummyattr>replace_me</dummyattr>
</effect>
 

I need to replace <dummyattr>repl ace_me</dummyattr>
with the following (these are not variables, elements and data will always be the same):

<parameter>
      <parameterid>fontname</parameterid>
      <name>Font</name>
      <value>ITC Officina Sans</value>
</parameter>
<parameter>
      <parameterid>fontsize</parameterid>
      <name>Size</name>
      <value>39</value>
</parameter>
<parameter>
      <parameterid>fontstyle</parameterid>
      <name>Style</name>
      <value>1</value>
      </parameter>
<parameter>
      <parameterid>fontalign</parameterid>
      <name>Alignment</name>
      <value>1</value>
</parameter>
<parameter>
      <parameterid>fontcolor</parameterid>
      <name>Font Color</name>
      <value>
            <alpha>255</alpha>
        <red>1</red>
            <green>2</green>
            <blue>3</blue>
      </value>
</parameter>
<parameter>
      <parameterid>origin</parameterid>
      <name>Origin</name>
      <value>
            <horiz>-0.101389</horiz>
            <vert>0.383604</vert>
      </value>
</parameter>

Existing XSL:

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">    
    <xsl:output method="xml" indent="yes"/>    
    <xsl:strip-space elements="*"/>    
    <xsl:template match="node()//*">        
        <xsl:if test="normalize-space(.)">            
            <xsl:copy>                
                <xsl:apply-templates select="@*|node()"/>            
            </xsl:copy>        
        </xsl:if>    
    </xsl:template>    
    <xsl:template match="@*|node()">        
        <xsl:copy>            
            <xsl:apply-templates select="@*|node()"/>        
        </xsl:copy>    
    </xsl:template>
</xsl:stylesheet>

[dorinbogdan]

Welcome to TSDN...

I'm not sure what is the desired output.
Please post the final structure you expect to obtain too.

[jtric]

Welcome to TSDN...

I'm not sure what is the desired output.
Please post the final structure you expect to obtain too.

Thanks!

Sorry, here is the final structure:

<effect>
    <name>Text</name>
    <effectid>Text</effectid>
    <effectcategory>Text</effectcategory>
    <effecttype>generator</effecttype>
    <mediatype>video</mediatype>
    <parameter>
              <parameterid>str</parameterid>
          <name>Text</name>
          <value>Tuesday at 10:00</value>
    </parameter>
    <parameter>
                 <parameterid>fontname</parameterid>
                 <name>Font</name>
                 <value>ITC Officina Sans</value>
        </parameter>
        <parameter>
                <parameterid>fontsize</parameterid>
                <name>Size</name>
                <value>39</value>
         </parameter>
         <parameter>
               <parameterid>fontstyle</parameterid>
               <name>Style</name>
               <value>1</value>
         </parameter>
         <parameter>
              <parameterid>fontalign</parameterid>
              <name>Alignment</name>
              <value>1</value>
         </parameter>
         <parameter>
              <parameterid>fontcolor</parameterid>
              <name>Font Color</name>
              <value>
                  <alpha>255</alpha>
              <red>1</red>
                  <green>2</green>
                  <blue>3</blue>
              </value>
         </parameter>
         <parameter>
             <parameterid>origin</parameterid>
              <name>Origin</name>
              <value>
                    <horiz>-0.101389</horiz>
                    <vert>0.383604</vert>
              </value>
          </parameter>
</effect>
 

[dorinbogdan]

So you will use 2 XML files to get the result.
Then you need a merge/concat method.
For the moment I only can point you to some links.
See if
Merge two files or
Merging XML Documents help.

[jtric]

So you will use 2 XML files to get the result.
Then you need a merge/concat method.
For the moment I only can point you to some links.
See if
Merge two files or
Merging XML Documents help.

Solution two in that link looks like exactly what I need. I will tool around with it.

Thanks for pointing me in the right direction! Will post my solution if I'm able to figure it out.

[jtric]

Solution two in that link looks like exactly what I need. I will tool around with it.

Thanks for pointing me in the right direction! Will post my solution if I'm able to figure it out.

Not sure who else might benefit from this, but I figured I would post what ended up working. Thanks again for pointing me in the right direction.

(I did not end up needing to use the dummy tag)

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">    
    <xsl:output method="xml" encoding="UTF-8" standalone="yes" indent="yes"/>    
    <xsl:variable name="textinfo">        
        <parameter>            
            <parameterid>fontname</parameterid>            
            <name>Font</name>            
            <value>ITC Officina Sans</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontsize</parameterid>            
            <name>Size</name>            
            <value>39</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontstyle</parameterid>            
            <name>Style</name>            
            <value>1</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontalign</parameterid>            
            <name>Alignment</name>            
            <value>1</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontcolor</parameterid>            
            <name>Font Color</name>            
            <value>                
                <alpha>255</alpha>                
                <red>1</red>                
                <green>2</green>                
                <blue>3</blue>            
            </value>        
        </parameter>        
        <parameter>            
            <parameterid>origin</parameterid>            
            <name>Origin</name>            
            <value>                
                <horiz>-0.101389</horiz>                
                <vert>0.383604</vert>            
            </value>        
        </parameter>    
    </xsl:variable>    
    <xsl:strip-space elements="*"/>    
    <xsl:template match="node()//*">        
        <xsl:if test="normalize-space(.)">            
            <xsl:copy>                
                <xsl:apply-templates select="@*|node()"/>            
            </xsl:copy>        
        </xsl:if>    
    </xsl:template>    
    <xsl:template match="//generatoritem/effect">    
        <xsl:copy>    
            <xsl:copy-of select="*"/> 
            <xsl:copy-of select="$textinfo"/> 
        </xsl:copy>    
    </xsl:template>    
    <xsl:template match="@*|node()">        
        <xsl:copy>            
            <xsl:apply-templates select="@*|node()"/>        
        </xsl:copy>    
    </xsl:template>
</xsl:stylesheet>

[dorinbogdan]

Glad to see it is working.

Who knows, sometime it may be helpful for others too.

[dorinbogdan]

Since the problem was solved I'll close the thread.

[dorinbogdan]

I re-open the thread in order to allow further comments or suggestions from other members or experts, as per adim request.

[jtric]

I'm glad that you re-opened the thread, as I seem to have borked my solution by adding what I thought was a simple modification.

The structure I am working with is essentially this (simplified, but this is the section I need to modify):

<xmeml>
   <sequence>
       <media>
          <video>
             <track>
                  <generatoritem id = "Text">
                   <name>Text</name>
                   <effect>
                        <name>Text</name>
                        <parameter>
                              <parameterid>Text</parameterid>
                         </parameter>
                   </effect>
                  </generatoritem>
               </track>
           <video>
        <media>
  <sequence>
<xmeml>

I need to insert two sets of tags that are held in variables in my xsl.
One goes in generatoritem/effect
One goes in generatoritem


The previous posts illustrate how I accomplished the former. I added the following to the xslt to accomplish the latter, thinking I understood fully how it worked.

<xsl:template match="generatoritem[@id='Text']">        
        <xsl:copy-of select="*"/>
        <xsl:copy-of select="$dropshadow"/>
</xsl:template>

However, when I add that, nothing gets added to generatoritem/effect and it seems that my generatoritem tags get stripped completely? Perhaps someone could point me in the right direction to fix this?

Thanks in advance for any guidance anyone can offer!

My full xsl is below:

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">    
    <xsl:output method="xml" encoding="UTF-8" standalone="yes" indent="yes"/>    
    <xsl:variable name="textinfo">        
        <parameter>            
            <parameterid>fontname</parameterid>            
            <name>Font</name>            
            <value>ITC Officina Sans</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontsize</parameterid>            
            <name>Size</name>            
            <value>39</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontstyle</parameterid>            
            <name>Style</name>            
            <value>1</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontalign</parameterid>            
            <name>Alignment</name>            
            <value>1</value>        
        </parameter>        
        <parameter>            
            <parameterid>fontcolor</parameterid>            
            <name>Font Color</name>            
            <value>                
                <alpha>255</alpha>                
                <red>1</red>                
                <green>2</green>                
                <blue>3</blue>            
            </value>        
        </parameter>        
        <parameter>            
            <parameterid>origin</parameterid>            
            <name>Origin</name>            
            <value>                
                <horiz>-0.101389</horiz>                
                <vert>0.383604</vert>            
            </value>        
        </parameter>    
    </xsl:variable>    
    <xsl:variable name="dropshadow">        
        <filter>            
            <effect>                
                <name>Drop Shadow</name>                
                <effectid>dropshadow</effectid>                
                <effectcategory>motion</effectcategory>                
                <effecttype>motion</effecttype>                
                <mediatype>video</mediatype>                
                <parameter>                    
                    <parameterid>offset</parameterid>                    
                    <name>offset</name>                    
                    <value>0</value>                
                </parameter>                
                <parameter>                    
                    <parameterid>angle</parameterid>                    
                    <name>angle</name>                    
                    <value>135</value>                
                </parameter>                
                <parameter>                    
                    <parameterid>color</parameterid>                    
                    <name>color</name>                    
                    <value>                        
                        <alpha>0</alpha>                        
                        <red>255</red>                        
                        <green>255</green>                        
                        <blue>255</blue>                    
                    </value>                
                </parameter>                
                <parameter>                    
                    <parameterid>softness</parameterid>                    
                    <name>softness</name>                    
                    <value>36</value>                
                </parameter>                
                <parameter>                    
                    <parameterid>opacity</parameterid>                    
                    <name>opacity</name>                    
                    <value>100</value>                
                </parameter>            
            </effect>        
        </filter>    
    </xsl:variable>    
    <xsl:strip-space elements="*"/>    
    <xsl:template match="node()//*">        
        <xsl:if test="normalize-space(.)">            
            <xsl:copy>                
                <xsl:apply-templates select="@*|node()"/>            
            </xsl:copy>        
        </xsl:if>    
    </xsl:template>                
    <xsl:template match="generatoritem[@id='Text']/effect">        
        <xsl:copy>            
            <xsl:copy-of select="*"/>            
            <xsl:copy-of select="$textinfo"/>        
        </xsl:copy>    
    </xsl:template>    
    <xsl:template match="generatoritem[@id='Text']">        
        <xsl:copy-of select="*"/>
        <xsl:copy-of select="$dropshadow"/>
    </xsl:template>
    <xsl:template match="@*|node()">        
        <xsl:copy>
            <xsl:apply-templates select="@*|node()"/>
        </xsl:copy>
    </xsl:template>
</xsl:stylesheet>