OpenOffice XSLT XML data merge

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

snowch

I have created a prototype project for a standalone document service that works by applying external data to an OpenOffice document using XSLT. 

The service works by unpacking the odf, extracting the relevant file (e.g. content.xml), and applying data from an external xml file.  The new merged file is then repackaged into the odf and a conversion process allows you to convert the file to various formats (pdf, etc).

Example XSLT:

<?xml version="1.0"?>
<xsl:stylesheet 
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
   xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" 
   version="1.0">

   <xsl:output method="xml" indent="yes"/>

   <xsl:template match="node()|@*">
     <xsl:copy><xsl:apply-templates select="node()|@*"/></xsl:copy>
   </xsl:template>
   
   <xsl:template match="text:p[text() = 'Replace me!']">
         <xsl:copy>
            <xsl:copy-of select="@*"/>
            <xsl:value-of select="document('data.xml')/map/entry[@key='key1']/@value"/>
         </xsl:copy>
   </xsl:template>
</xsl:stylesheet>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The benefit of using XSLT on the ODF file in this manner allows business users to provide document templates.   Developers can then create the XSLT to fill the document template without having to modify the original ODF file.

Is functionality similar to above available in Alfresco?

Many thanks in advance,

Chris

jayjayecl

Hi,

I have the same kind of requirement.
I have a "template file" in OpenOffice text Format, whici holds some variables (like "${reference}").
I have a Java class that builds a HashMap of (key, value).
I'd like to generate a PDF document from de odf template file, and the Map of data (as I would be able to do easily with freemarker).
What is the best practice to do that ?