Attachment 147683 Details for Bug 122206 – XSLT filter for import of XML test file.

XSLT filter for import of XML test file.

CustomerXMLimportSerenade.xslt (text/plain), 9.39 KB, created by Steve Edmonds on 2018-12-19 21:49:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Steve Edmonds

Created: 2018-12-19 21:49:45 UTC

Size: 9.39 KB

patch

obsolete

><?xml version="1.0" encoding="UTF-8"?>
><xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >
><xsl:template match="/">
>  <office:document-content 
>  xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" 
>  xmlns:vcf="me.me.me.vcf" 
>  xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" 
>  xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
>  xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" 
>  xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" 
>  xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" 
>  xmlns:xlink="http://www.w3.org/1999/xlink"   
>  xmlns:dc="http://purl.org/dc/elements/1.1/" 
>  xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" 
>  xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" 
>  xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" 
>  xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" 
>  xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" 
>  xmlns:math="http://www.w3.org/1998/Math/MathML"   
>  xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" 
>  xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" 
>  xmlns:ooo="http://openoffice.org/2004/office" 
>  xmlns:ooow="http://openoffice.org/2004/writer" 
>  xmlns:oooc="http://openoffice.org/2004/calc" 
>  xmlns:dom="http://www.w3.org/2001/xml-events" 
>  xmlns:xforms="http://www.w3.org/2002/xforms" 
>  xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
>  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
>  office:version="1.0">
>
>   <office:automatic-styles>
>
>    
>    <style:style style:name="co1" style:family="table-column">
>     <style:table-column-properties fo:break-before="auto" style:column-width="6.000cm"/>
>    </style:style>
>    <style:style style:name="co2" style:family="table-column">
>     <style:table-column-properties fo:break-before="auto" style:column-width="2.000cm"/>
>    </style:style>
><style:style style:name="co3" style:family="table-column">
>     <style:table-column-properties fo:break-before="auto" style:column-width="3.000cm"/>
>    </style:style>
><style:style style:name="co4" style:family="table-column">
>     <style:table-column-properties fo:break-before="auto" style:column-width="4.000cm"/>
>    </style:style>
>
>    
>    <number:date-style style:name="N36" number:automatic-order="true">
>     <number:day number:style="long"/>
>     <number:text>.</number:text>
>     <number:month number:style="long"/>
>     <number:text>.</number:text>
>     <number:year number:style="long"/>
>    </number:date-style>
>    <number:number-style style:name="N107">
>     <number:number number:decimal-places="4" number:min-integer-digits="1"/>
>    </number:number-style>
>
>    
>    <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default">
>     <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
>     <style:paragraph-properties fo:text-align="end"/>
>    </style:style>
>    <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N107"/>
>    <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36"/>
>
>   </office:automatic-styles>
>
>   <office:body>
>    <office:spreadsheet>
>     <table:table>
>
>      
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
>      <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
>
>
>      
>      <table:table-row>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Account Code</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Company</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Name</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Email</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Salesman</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Type</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Area</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Last Access</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Default Acct.</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Locked</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Valid Count</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Invalid Count</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Visibility Groups</text:p></table:table-cell>
>       <table:table-cell table:style-name="ce1" office:value-type="string"><text:p>Dflt. Discount</text:p></table:table-cell>
>      </table:table-row>
>
>
>      <xsl:for-each select="accounts/account">
>       <table:table-row>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="account-code"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="company"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="name"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="email"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="sales-person"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="sales-region"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="country"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="last-access"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="default-account"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="lock-account"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="valid-access-count"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="invalid-access-count"/></text:p>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>        <xsl:for-each select="customer-visibility-groups/customer-visibility-group">
>            <text:p><xsl:value-of select="name"/></text:p>
>        </xsl:for-each>
>        </table:table-cell>
>
>        
>        <table:table-cell>
>         <text:p><xsl:value-of select="default-discount"/></text:p>
>        </table:table-cell>
>
>       </table:table-row>
>      </xsl:for-each>
>     </table:table>
>    </office:spreadsheet>
>   </office:body>
>  </office:document-content>
></xsl:template>
></xsl:stylesheet>

Actions: View

Attachments on bug 122206: 147682 | 147683 | 171574