<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic OpenOffice XSLT XML data merge in Alfresco Archive</title>
    <link>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186742#M139872</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I have created a prototype project for a standalone document service that works by applying external data to an OpenOffice document using XSLT.&amp;nbsp; &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The service works by unpacking the odf, extracting the relevant file (e.g. content.xml), and applying data from an external xml file.&amp;nbsp; 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).&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Example XSLT:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;PRE class="language-none line-numbers"&gt;&lt;CODE&gt;&amp;lt;?xml version="1.0"?&amp;gt;&lt;BR /&gt;&amp;lt;xsl:stylesheet &lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;xmlns:xsl="&lt;A href="http://www.w3.org/1999/XSL/Transform" rel="nofollow noopener noreferrer"&gt;http://www.w3.org/1999/XSL/Transform&lt;/A&gt;"&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" &lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;version="1.0"&amp;gt;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;xsl:output method="xml" indent="yes"/&amp;gt;&lt;BR /&gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;xsl:template match="node()|@*"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;xsl:copy&amp;gt;&amp;lt;xsl:apply-templates select="node()|@*"/&amp;gt;&amp;lt;/xsl:copy&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/xsl:template&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;xsl:template match="text:p[text() = 'Replace me!']"&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;xsl:copy&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;xsl:copy-of select="@*"/&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;xsl:value-of select="document('data.xml')/map/entry[@key='key1']/@value"/&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/xsl:copy&amp;gt;&lt;BR /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;/xsl:template&amp;gt;&lt;BR /&gt;&amp;lt;/xsl:stylesheet&amp;gt;&lt;BR /&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;BR /&gt;&lt;SPAN&gt;The benefit of using XSLT on the ODF file in this manner allows business users to provide document templates.&amp;nbsp;&amp;nbsp; Developers can then create the XSLT to fill the document template without having to modify the original ODF file.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Is functionality similar to above available in Alfresco?&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Many thanks in advance,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Chris&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 01 Mar 2009 01:54:06 GMT</pubDate>
    <dc:creator>snowch</dc:creator>
    <dc:date>2009-03-01T01:54:06Z</dc:date>
    <item>
      <title>OpenOffice XSLT XML data merge</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186742#M139872</link>
      <description>I have created a prototype project for a standalone document service that works by applying external data to an OpenOffice document using XSLT.&amp;nbsp; The service works by unpacking the odf, extracting the relevant file (e.g. content.xml), and applying data from an external xml file.&amp;nbsp; The new merged file</description>
      <pubDate>Sun, 01 Mar 2009 01:54:06 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186742#M139872</guid>
      <dc:creator>snowch</dc:creator>
      <dc:date>2009-03-01T01:54:06Z</dc:date>
    </item>
    <item>
      <title>Re: OpenOffice XSLT XML data merge</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186743#M139873</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Hi,&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I have the same kind of requirement.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I have a "template file" in OpenOffice text Format, whici holds some variables (like "${reference}").&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;I have a Java class that builds a HashMap of (key, value).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;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).&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;What is the best practice to do that ?&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 26 May 2009 08:11:31 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186743#M139873</guid>
      <dc:creator>jayjayecl</dc:creator>
      <dc:date>2009-05-26T08:11:31Z</dc:date>
    </item>
    <item>
      <title>Re: OpenOffice XSLT XML data merge</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186744#M139874</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;Found a solution using JodReports (you ll find it on sourceforge)&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 27 May 2009 09:46:13 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186744#M139874</guid>
      <dc:creator>jayjayecl</dc:creator>
      <dc:date>2009-05-27T09:46:13Z</dc:date>
    </item>
    <item>
      <title>Re: OpenOffice XSLT XML data merge</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186745#M139875</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;FYI: from JodReports website&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;BLOCKQUOTE class="jive-quote"&gt;Warning! This project is now unmaintained. The latest version 2.0.0 was released back in September 2006. You may still find it useful, since it is open source you are free to get the code and modify it, but be aware that the original author is no longer developing it.&lt;/BLOCKQUOTE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 27 May 2009 11:45:39 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186745#M139875</guid>
      <dc:creator>zaizi</dc:creator>
      <dc:date>2009-05-27T11:45:39Z</dc:date>
    </item>
    <item>
      <title>Re: OpenOffice XSLT XML data merge</title>
      <link>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186746#M139876</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I know, I saw it, but still, I tried and it worked.&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN&gt;FYI, a part of the project JODREPORTS is already included in Alfresco : jodconverter. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Thank you anyway&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 28 May 2009 08:58:31 GMT</pubDate>
      <guid>https://connect.hyland.com/t5/alfresco-archive/openoffice-xslt-xml-data-merge/m-p/186746#M139876</guid>
      <dc:creator>jayjayecl</dc:creator>
      <dc:date>2009-05-28T08:58:31Z</dc:date>
    </item>
  </channel>
</rss>

