Oracle OpenOffice plugin and LibreOffice

So, i would like to release a quick fix for the updated OpenOffice plugin by Oracle (previously Sun Connector for Alfresco CMS)…

First, let see the error in log:

10:51:23,318 User:admin ERROR [freemarker.runtime] Expression path is undefined on line 53, column 61 in org/alfresco/office/navigation.get.xml.ftl.

Expression path is undefined on line 53, column 61 in org/alfresco/office/navigation.get.xml.ftl.
The problematic instruction:
==> ${path?url} [on line 53, column 59 in org/alfresco/office/navigation.get.xml.ftl]

Error occured by an unhandled and missing ‘path’ variable in freemarker template. Put following code before ‘notication’ XML tag (you can replace initial value of ‘path’ variable with something else of course):

<#if path??>
<#assign path="/">

Another quick tip for Alfresco-side installation, just use repository instead of local filesystem to override (no need to overwrite) ‘office’ webscript templates in deployed Alfresco:

And finally, the plugin works with LibreOffice 3.3 too:

FreeMarker tutorial

I’ve found a very interesting post about an interface to learn FreeMarker templating engine: FreeMarker sketchbook

FreeMarker sketchbook is a Java WebStart application with following features:
– realtime output processing and view
– page and tag view
– variable editor
– help and examples included

FreeMarker is a template engine and language which we are using in the content management system of our new application. For next week I have been preparing training material for web-developers and something I was missing, was a simple way for them to learn and try out FreeMarker. The best way to learn is by playing and experiencing something yourself, so I created a simple java application with an editor and FreeMarker renderer.
At the same time this has been a good exercise for me as well, as this is my first Swing and Java™ Web Start application. After I received some feedback, added a few more features and cleaned-up the code, I will probably release it as open source project. I think this is a handy little application for those who want to create FreeMarker templates. If you want to try it out, just click on the button below. You should have Java 1.5 or higher installed.

You can find another solution on site which offers similar functionality:

These interfaces are useful to know Alfresco templating, and Web Script interface customization…

Link: FreeMarker Manual: Learning by example

Simple browser for Alfresco

I’ve made a simple content and hierarchy browser for Alfresco – using the WebScript interface – inspired by Dr. Q’s Dead Simple UI (just try the iPhone Navigator too). This is a really quick browser, but has got a quick search input on the left-top corner. That’s all, no more.

1. Download to your local storage
2. Login to Alfresco, navigate into Company Home/Data Dictionary/Web Scripts Extensions space and select Import from Administration Console menu
3. Import the downloaded zip file (import script will unpack into the space)
4. Load the service browser by link
5. Click on Refresh list of Web Script button to register new service
6. Start browsing on this startup URL: