tim.frith

tim.frith

Alfresco Certified Engineer

Senior ECM Consultant
Tim holds a diploma in Computer Systems Technology from Camosun College as well as a Bachelor of Commerce Degree with a Finance specialization from the University of Alberta. He has over 10 years of experience developing web applications with Java as well as extensive database development experience with Oracle, IBM DB2, MS SQL Server, and MySQL.

In recent years he has focused on Enterprise Content Management, with specific training and experience in Alfresco's content management suite.

And finally, Tim is a strong believer that the Edmonton Oilers will soon reclaim their rightful place at the top of the hockey world. Yes, Stanley will once again come to town.

Alfresco ScriptNodes and jsonUtils

I’m using Alfresco Enterprise v4.1.1 for a project and I found a bit of a hole in the jsonUtils object.

Here’s what I tried to do in a webscript:

var users = people.getMembers(people.getGroup("GROUP_MyGroup"));
var json = jsonUtils.toJSONString(users);

 

The first line returns a javascript array of org.alfresco.repo.jscript.ScriptNodes (3 persons). These are the node objects you use in your webscripts.
The second line is supposed to provide a valid JSON string representing the user array.
The “jsonUtils” object available in webscripts uses org.springframework.extensions.webscripts.json.JSONUtils.

What I get for my array of 3 users looks something like this:

"Node Type: {http://www.alfresco.org/model/content/1.0}person, Node Aspects: [...]",
"Node Type: {http://www.alfresco.org/model/content/1.0}person, Node Aspects: [...]",
"Node Type: {http://www.alfresco.org/model/content/1.0}person, Node Aspects: [...]"

 

I’ve done some slight editing to save space here but it’s not valid JSON and not very useful at all. It turns out this is the output from ScriptNode.toString() for each user.

However ScriptNode also provides a handy toJSON() method.
Here’s some Java I wrote to add support for both a single ScriptNode and an array of ScriptNodes:

public String toJSONString(Object object) throws IOException {

  JSONUtils jsonUtils = new JSONUtils();

  if (object instanceof ScriptNode) {
    // the true tells it to use short QNames
    // eg. cm:name instead of {http://www.alfresco.org/model/content/1.0}name
    return ((ScriptNode) object).toJSON(true);

  } else {
    // is it an array of ScriptNodes?
    if (object instanceof NativeArray) {

      NativeArray array = (NativeArray) object;

      // get first item and see if it's a ScriptNode
      Object firstItem = array.get(0, array);

      if (firstItem instanceof ScriptNode) {
        StringBuffer json = new StringBuffer("[");
        ScriptNode node = (ScriptNode) firstItem;
        json.append(node.toJSON(true));

        for (int i = 1; i < array.getLength(); i++) {

          json.append(",");
          Object value = array.get(i, array);
          node = (ScriptNode) value;
          json.append(node.toJSON(true));
        }
        json.append("]");
        return json.toString();
      }
    }

    // if it's not a ScriptNode or array of ScriptNodes let jsonUtils handle it
    return this.jsonUtils.toJSONString(object);
  }
}

 

I expose this code to javascript with an extension name of ‘jsonUtilsTim’ and now the webscript looks like this:

var users = people.getMembers(people.getGroup("GROUP_MyGroup"));
var json = jsonUtilsTim.toJSONString(users);

 

Now I get the following which is valid JSON and actually useful:

[
 {
 "mimetype": "application/octet-stream",
 "aspects": [
 "app:configurable",
 "cm:ownable",
 "sys:referenceable",
 "sys:localized"
 ],
 "nodeRef": "workspace://SpacesStore/770df4a0-78ff-4c46-aca9-0de5ff12345",
 "properties": {
 "cm:name": "770df4a0-78ff-4c46-aca9-0de5ff512345",
 "sys:node-dbid": 27,
 "cm:email": "admin@alfresco.com",
 "cm:organizationId": "",
 "sys:store-identifier": "SpacesStore",
 "sys:locale": "en_US",
 "cm:homeFolderProvider": "bootstrapHomeFolderProvider",
 "cm:userName": "admin",
 "cm:sizeCurrent": null,
 "cm:owner": "admin",
 "sys:node-uuid": "770df4a0-78ff-4c46-aca9-0de5ff512345",
 "cm:lastName": "",
 "sys:store-protocol": "workspace",
 "cm:homeFolder": "workspace://SpacesStore/4f4ff00d-c94f-4a99-a304-cbe2e2912345",
 "cm:firstName": "Administrator"
 },
 "type": "cm:person"
 },
 {
 "mimetype": "application/octet-stream",
 "aspects": [
 "cm:ownable",
 "sys:referenceable",
 "sys:localized",
 "cm:personDisabled",
 "cm:preferences"
 ],
 "nodeRef": "workspace://SpacesStore/b6d80d49-21cc-4f04-9c92-e70630312345",
 "properties": {
 "sys:locale": "en_US",
 "cm:companyaddress3": "UK",
 "cm:homeFolderProvider": "userHomesHomeFolderProvider",
 "cm:companytelephone": "",
 "cm:owner": "admin",
 "cm:jobtitle": "Web Site Manager",
 "cm:preferenceValues": "contentUrl=store://2012/10/26/15/16/146c1e27-3980-4c21-b66c-397d97512345.bin|mimetype=text/plain|size=817|encoding=UTF-8|locale=en_US_|id=127",
 "cm:homeFolder": "workspace://SpacesStore/5da679f6-e7f3-4f8d-9506-554ed7312345",
 "cm:instantmsg": "",
 "cm:sizeQuota": -1,
 "cm:googleusername": "",
 "cm:firstName": "Jane",
 "cm:emailFeedId": 442,
 "cm:name": "b6d80d49-21cc-4f04-9c92-e70630312345",
 "cm:userStatusTime": "Tue Feb 15 13:13:09 MST 2011",
 "sys:node-dbid": 562,
 "cm:email": "jane.doe@example.com",
 "sys:store-identifier": "SpacesStore",
 "cm:companyfax": "",
 "sys:node-uuid": "b6d80d49-21cc-4f04-9c92-e70630312345",
 "cm:lastName": "Doe",
 "cm:persondescription": "contentUrl=store://2012/10/26/15/16/8f13b84b-f797-4176-bcce-cdff90912345.bin|mimetype=application/octet-stream|size=54|encoding=UTF-8|locale=en_US_|id=128",
 "cm:companyemail": "",
 "cm:sizeCurrent": null,
 "cm:userName": "jane.doe",
 "sys:store-protocol": "workspace"
 },
 "type": "cm:person"
 },
 {
 "mimetype": "application/octet-stream",
 "aspects": [
 "app:configurable",
 "cm:ownable",
 "sys:referenceable",
 "sys:localized"
 ],
 "nodeRef": "workspace://SpacesStore/c530d479-9a78-4c14-94c7-933b46412345",
 "properties": {
 "cm:name": "c530d479-9a78-4c14-94c7-933b46412345",
 "sys:node-dbid": 6939,
 "cm:organizationId": "",
 "cm:email": "john.doe@example.com",
 "sys:store-identifier": "SpacesStore",
 "sys:locale": "en_US",
 "cm:presenceUsername": "",
 "cm:homeFolderProvider": "userHomesHomeFolderProvider",
 "cm:owner": "john.doe",
 "cm:organization": "",
 "cm:jobtitle": "",
 "sys:node-uuid": "c530d479-9a78-4c14-94c7-933b46412345",
 "cm:lastName": "Doe",
 "cm:homeFolder": "workspace://SpacesStore/15a8f7fb-87ee-4a7e-9b4d-c2f3a8f12345",
 "cm:presenceProvider": "",
 "cm:location": "",
 "cm:sizeQuota": -1,
 "cm:sizeCurrent": null,
 "cm:userName": "john.doe",
 "sys:store-protocol": "workspace",
 "cm:firstName": "John"
 },
 "type": "cm:person"
 }
 ]

Alfresco Sub-groups

My goal: add a group as a sub-group of another group – ie. nest groups.

Alfresco Version: Enterprise – v3.4.7 (572)

My first try – the Alfresco Explorer UI

The problem with this is that although it will show you sub-groups it will only let you add users to groups, not other groups.

My second try – the Alfresco Share UI

I started by searching for my parent group by name.
Found it – great. Next I clicked the Edit icon.
Turns out this only lets you edit the display name of the group.
So I clicked the Browse button.
In the browse interface when you click on a group you can add sub-groups and users – perfect.
BUT…for some reason my parent group did not show up on the list. It’s not a system list or anything special, just a local Alfresco group I created.

My third try – script it

I took a look at my trusty Alfresco javascript API (http://wiki.alfresco.com/wiki/3.4_JavaScript_API)
Adding a sub-group this way is pretty simple:

  1. Find the parent group
  2. Find the child group
  3. Add the child to the parent

Here is the javascript (NOTE the “GROUP_” prefix when finding a group):

var parentGrp = people.getGroup("GROUP_My Parent Group"); 
var childGrp = people.getGroup("GROUP_My Child Group"); 
people.addAuthority(parentGrp, childGrp);

 

I don’t really understand why, in Share, searching for a specific group and browsing groups offer different options on the results.

But scripting it is a quick, easy work-around.

Eclipse Run As Java Application – NoClassDefFound

I started having a problem in Eclipse trying to run a Java class with a main() method. (Run As… Java Application).

It kept giving me a NoClassDefFoundException on the class I was trying to run. I swear this worked for this project before. It works fine if I create a new Java project.

I finally managed to fix it by adding a missing buildCommand to my .project file.

This was so frustrating that now that I finally figured it out I decided to share it. I’m using Eclipse Indigo on 64-bit Windows 7 by the way.

Before:

<?xml version="1.0" encoding="UTF-8"?>
<projectDescription>
  <name>MyJavaProject</name>
    <comment></comment>
    <projects>
    </projects>
    <buildSpec>
    </buildSpec>
    <natures>
      <nature>org.eclipse.jdt.core.javanature</nature>
    </natures>
</projectDescription>

After:

<?xml version="1.0" encoding="UTF-8"?>
<projectDescription>
  <name>MyJavaProject</name>
  <comment></comment>
  <projects>
  </projects>
  <buildSpec>
    <buildCommand>
      <name>org.eclipse.jdt.core.javabuilder</name>
      <arguments>
      </arguments>
    </buildCommand>
  </buildSpec>
  <natures>
    <nature>org.eclipse.jdt.core.javanature</nature>
  </natures>
</projectDescription>

Show Users In Logs – Alfresco NDC

I was trying to debug a user’s issue on one of our alfresco servers.  I looked through the alfresco log file but of course there are entries from many users there so it was tough to pinpoint the relevant ones.

One of our other alfresco servers adds the user name to the log statements and that would be very helpful in this case.  I couldn’t figure out why our 3.2 server included user names but our 3.4 server did not.

Here’s what I found out:Alfresco’s AuthenticationUtil class (unchanged from 3.2 to 3.4) has a logNDC() method that adds the user name.

NDC (Nested Diagnostic Contexts) is part of Log4j.  Look for “Nested Diagnostic Contexts” way down this page for an explanation: http://logging.apache.org/log4j/1.2/manual.html

Instead of directly using Apache’s NDC, Alfresco uses a delegate to avoid any dependancy. AuthenticationUtil uses org.alfresco.util.log.NDC instead of org.apache.log4j.NDC.

The first thing Alfresco’s NDC class does is to instantiate its delegate (org.alfresco.util.log.log4j.Log4JNDC) which then uses org.apache.log4j.NDC.

HOWEVER

It only does this if org.alfresco.util.log.NDC’s logger has debug enabled.  If not then the delegate is null and any NDC calls do nothing at all.

How to Fix It

The solution is simple, set Alfresco’s NDC logger to debug in your log4j properties file like so:

log4j.logger.org.alfresco.util.log.NDC=debug

That class doesn’t actually log any messages so this won’t add anything to your log files except the user name.

Now just make sure the File appender includes the NDC information by adding %x to the conversion pattern like so:

log4j.appender.File.layout.ConversionPattern=%d{ABSOLUTE} %x %-5p [%c] %m%n

You just get this:

12:25:00,018 User:System DEBUG [org.alfresco.repo.jscript.ScriptLogger] start clean user home script

instead of this:

12:25:00,018 DEBUG [org.alfresco.repo.jscript.ScriptLogger] start clean user home script

NOTE

Usually you set your log4j overrides in a file in tomcat/shared/classes/alfresco/extension called custom-log4j.properties or dev-log4j.properties or something like that.  You can go ahead and put the NDC=debug line in this file.  However if you put your new conversion pattern in this file in 3.4 it will be ignored.  (See https://issues.alfresco.com/jira/browse/ALF-13742). Instead you must change the conversion pattern in tomcat/webapps/alfresco/WEB-INF/classes/log4j.properties.

About Alfresco Versions

This has been annoying me for a long time.  I looked at Alfresco’s NDC class in 3.2 and it does NOT check if debug is enabled – it just finds org.apache.log4j.NDC and uses it.  I’m not sure when this changed (I haven’t looked at 3.3) but I do know that you need to set NDC to debug in 3.4 and 4.0 as org.alfresco.util.log.NDC is the same in both of those.

 

Alfresco – Version Stamp Your AMP

I always find myself renaming AMP files after building them – I add the module version to the name. Being relatively lazy I decided to see if I could have Alfresco’s ANT build do this for me.

After a bit of trial and error I figured it out and created an ANT macro to do it for me.

I put my macro in a separate file called abstractive-macros.xml.

It has 2 parameters:

  1. modpropsdir is the directory containing the module.properties file. This is where we read the module version. It’s probably already defined in your build.properties under a property called dir.module.MYPROJECT.property.
  2. ampnameproperty is the NAME of the property that contains the AMP file name. We just want the name of the property (not its value) because we want to update the property itself so anything else that uses it will have the new name.

The macro:

  • pulls in the contents of module.properties
  • pulls the extension from the amp file name
  • gets the “module.version” from module.properties
  • builds a new amp file name that includes the version

It turns out you can use javascript within an ANT script – I didn’t know that. You can also use all kinds of other scripts such as groovy, ruby, jython, judoscript, etc.

Here’s the complete macro xml.

abstractive-macros.xml

<project name="abstractive-macros">

   <macrodef name="versionamp" description="Appends the module version to the amp file name">

      <!-- modpropsdir is the VALUE of the dir.module.XXXXX.property -->
      <attribute name="modpropsdir" />

      <!-- ampnameproperty is the NAME of the file.name.amp.XXXXX property
           and its value will be updated to include the module version -->
      <attribute name="ampnameproperty" />

      <sequential>
        <!-- append module version to amp file name -->
        <property file="@{modpropsdir}/module.properties"/>
        <script language="javascript"> <![CDATA[
          amp = project.getProperty("@{ampnameproperty}");
          title = amp.substring(0, amp.indexOf(".amp"));

          version = project.getProperty("module.version");
          project.setProperty("@{ampnameproperty}", title + "_" + version + ".amp");
        ]]> </script>
      </sequential>
   </macrodef>
</project>

The only change to build.xml is to include our new macro xml file.

build.xml

...
  <import file="macros.xml" />
  <import file="abstractive-macros.xml" />
  <import file="projects.xml" />
  ...

And in projects.xml we make the call to the macro. This is done in the package-MYMODULE-extension target. I pass it the path to module properties and the NAME of the property that contains the amp file name.

projects.xml

...
  <target name="package-MYMODULE-extension" depends="package-MYMODULE-jar">

    <versionamp modpropsdir="${dir.module.MYMODULE.property}"
      ampnameproperty="file.name.amp.MYMODULE" />

    <zip destfile="${dir.module.MYMODULE.dist}/${file.name.amp.MYMODULE}" update="true">
      <zipfileset file="${dir.module.MYMODULE.property}/module.properties" />
      <zipfileset file="${dir.module.MYMODULE.dist}/${file.name.jar.MYMODULE}" prefix="lib" />
      <zipfileset dir="${dir.module.MYMODULE}/${dir.name.lib}" prefix="lib" />
      <zipfileset dir="${dir.module.MYMODULE.config}" prefix="config">
        <exclude name="**/module.properties" />
      </zipfileset>
    </zip>
  </target>
  ...

And that’s all there is to it.  So if:

  • your module.properties contains module.version=1.10
  • in your build.properties your file.name.amp.MYPROJECT=MYPROJECT.amp

and you run the package-MYPROJECT-extension target it will generate an amp called MYPROJECT_1.10.amp.

Better Alfresco Script Logging

I was working on some web scripts recently and using log statements to help my development. Does it ever bother you that the only log level available to web scripts is DEBUG? It bugs me.

So I made a simple JavaScript extension that exposes the various log levels of the ScriptLogger to JavaScript.

If you are not familiar with creating Alfresco JavaScript extensions read the Alfresco JavaScript API wiki entry.

The Java class extends BaseScopableProcessorExtension. It provides two log methods for each of these log levels:

  • DEBUG
  • INFO
  • WARN
  • ERROR
  • FATAL

Here are the debug methods an example, the full source code is below:

public void debug(Object message) {
    logger.debug(message);
}

public void debug(Object message, Throwable t) {
    logger.debug(message, t);
}

As you will see below there is not much to the code.

I’ve called it atcLogger (ATC = Abstractive Technology Consulting)

This is nice if, for example, you have a server with the log level set to WARN and you want to quickly toss in a log statement. If you used logger.log(“Some message”) you wouldn’t see the output in the log since that uses DEBUG level. You could use atcLogger.warn(“Some message”) and this would appear in the log without having to change the log level on the server. Even if you change the log level through JMX it’s slightly more effort than lazy developers like me want to expend.

Here is the spring bean for the extension:

<bean id="atc_atcLogger" parent="baseJavaScriptExtension">
    <property name="extensionName">
        <value>atcLogger</value>
    </property>
</bean>

ATCLogger.java:

package ca.abstractive.ecm.alfresco.jscript.io;

import org.alfresco.repo.jscript.BaseScopableProcessorExtension;
import org.alfresco.repo.jscript.ScriptLogger;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

/**
 * Extends Alfresco's JavaScript API to expose a wider range of
 * logging levels.
 *
 * Refer to this class in JavaScript using the alias "atcLogger".
 *
 * @author Tim.Frith
 */
public class ATCLogger extends BaseScopableProcessorExtension {

    // Commons logger
    protected static final Log logger = LogFactory.getLog(ScriptLogger.class);

    /**
     * Standard constructor
     */
    public ATCLogger() {
    }

    /* ------------------------------------------------------------ */
    /* Public methods - available to JavaScript */
    /* ------------------------------------------------------------ */

    /**
     * @see org.apache.log4j.Logger#debug(Object)
     */
    public void debug(Object message) {
        logger.debug(message);
    }

    /**
     * @see org.apache.log4j.Logger#debug(Object, Throwable)
     */
    public void debug(Object message, Throwable t) {
        logger.debug(message, t);
    }

    /**
     * @see org.apache.log4j.Logger#info(Object)
     */
    public void info(Object message) {
        logger.info(message);
    }

    /**
     * @see org.apache.log4j.Logger#info(Object, Throwable)
     */
    public void info(Object message, Throwable t) {
        logger.info(message, t);
    }

    /**
     * @see org.apache.log4j.Logger#warn(Object)
     */
    public void warn(Object message) {
        logger.warn(message);
    }

    /**
     * @see org.apache.log4j.Logger#warn(Object, Throwable)
     */
    public void warn(Object message, Throwable t) {
        logger.warn(message, t);
    }

    /**
     * @see org.apache.log4j.Logger#error(Object)
     */
    public void error(Object message) {
        logger.error(message);
    }

    /**
     * @see org.apache.log4j.Logger#error(Object, Throwable)
     */
    public void error(Object message, Throwable t) {
        logger.error(message, t);
    }

    /**
     * @see org.apache.log4j.Logger#fatal(Object)
     */
    public void fatal(Object message) {
        logger.fatal(message);
    }

    /**
     * @see org.apache.log4j.Logger#fatal(Object, Throwable)
     */
    public void fatal(Object message, Throwable t) {
        logger.fatal(message, t);
    }
}

Possible improvements:

  • expose isDebugEnabled, isInfoEnabled(), etc. to JavaScript

Alfresco List Installed Modules in Explorer Template

UPDATE: I realized that if Alfresco is started with alf_start.bat then this works fine. However if you start it as a service then ALF_HOME and CATALINA_HOME environment variables are not available and it fails. So I’ve updated getCommonArgs() to use hard-coded paths as a work around for now.

Did you ever want to see which modules (AMPs) are currently installed but don’t want to have to log into the server to call the MMT (module management tool) for a list? Or you don’t have access to the MMT on the server. Or maybe you just want to see module version or install dates.

I decided to make this information available in the Alfresco Explorer to make my life easier.

Since the MMT already has a list command I decided just to call it with Java’s ProcessBuilder and parse the output.

Originally I planned to do this as a JavaScript extension that would return a JSON object with the module details. But then I thought this would work nicely in a presentation template that I could tack onto my Alfresco home space or wherever I wanted. So I ended up creating a template extension for Freemarker. The ModuleInfo class is shown below and extends BaseTemplateProcessorExtension.

If you aren’t familiar with extending Freemarker in Alfresco or using custom templates, see the Alfresco Template Guide.

Here is the command we need to run to have the MMT list installed Alfresco modules:

%JAVA_HOME%/bin/java -jar %ALF_HOME%bin/alfresco-mmt.jar list %CATALINA_HOME%/webapps/alfresco.war

And for Share modules we just change the war file it points to:

%JAVA_HOME%/bin/java -jar %ALF_HOME%bin/alfresco-mmt.jar list %CATALINA_HOME%/webapps/share.war

I don’t use ProcessBuilder often at all, but I figured since it has JAVA_HOME, ALF_HOME and CATALINA_HOME in its environment map that it should substitute the values as it’s making the call. Apparently not. Or I wasn’t calling it correctly. In any case I didn’t want to spend much time on that so I “manually” substituted the environment variable values before making the call. This is in the getCommonArgs() method (the full source is included below).

I split the Alfresco module list from the Share module list, having one call for each.

I put the module properties into a map using the names from the MMT output as the keys and I added the Name. So the map includes these properties:

  • Name
  • Title
  • Version
  • Install Date
  • Desription (this isn’t my spelling mistake! The MMT outputs it this way)

Once the template extension is deployed, we just need to make a presentation template that calls it. In the repository in Company Home/Data Dictionary/PresentationTemplates I created ModuleInfo.ftl.

It just calls the Java class to get the module details and throws it into a plain table. Here’s how one of the calls looks:

<#assign alfMods = moduleInfo.getAlfrescoModules()>

Finally, I chose a repository space and set it to use my new custom view.

Here’s what it looks like:

Here is the spring bean for the template extension:

<bean id="moduleInfoTemplate" parent="baseTemplateImplementation">
    <property name="extensionName">
        <value>moduleInfo</value>
    </property>
</bean>

ModuleInfo.java:

package ca.abstractive.ecm.alfresco.template;

import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.alfresco.error.AlfrescoRuntimeException;
import org.alfresco.repo.template.BaseTemplateProcessorExtension;
import org.apache.commons.io.IOUtils;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

/**
 * Extends Alfresco's FreeMarker API with functions for retrieving
 * information about installed modules.
 * 
 * Refer to this class in FreeMarker templates using the alias "moduleInfo".
 *
 * @author Tim.Frith
 */
public class ModuleInfo extends BaseTemplateProcessorExtension {

    // Commons logger
    protected static final Log logger = LogFactory.getLog(ModuleInfo.class);

    /* ------------------------------------------------------------ */
    /* Public methods - available to FreeMarker */
    /* ------------------------------------------------------------ */

    /**
     * Returns a list of modules currently installed in the Alfresco war.
     *
     * @return a List of module property maps (Name, Title, Version, Install Date, Desription)
     * @throws AlfrescoRuntimeException
     */
    public List<Map<String,String>> getAlfrescoModules() throws AlfrescoRuntimeException {
    	ProcessBuilder processBuilder = new ProcessBuilder();

	String[] args = this.getCommonArgs(processBuilder);
	args[4] += "alfresco.war";

    	return this.getInstalledModules(processBuilder, args);
    }

    /**
     * Returns a list of modules currently installed in the Share war.
     *
     * @return a List of module property maps (Name, Title, Version, Install Date, Desription)
     * @throws AlfrescoRuntimeException
     */
    public List<Map<String,String>> getShareModules() throws AlfrescoRuntimeException {
    	ProcessBuilder processBuilder = new ProcessBuilder();

	String[] args = this.getCommonArgs(processBuilder);
	args[4] += "share.war";

    	return this.getInstalledModules(processBuilder, args);
    }

    /**
     * Gets detailed information about installed modules.
     *
     * @param processBuilder the process builder to be used to execute the command
     * @param args an array containing the command to execute and its args
     * @return a List with a Map for each module
     * @throws AlfrescoRuntimeException if errors retrieving module info
     */
    public List<Map<String,String>> getInstalledModules(ProcessBuilder processBuilder, String[] args) throws AlfrescoRuntimeException {

    	List<Map<String,String>> results = new ArrayList<Map<String,String>>();

    	try {
            processBuilder.command(args);
            Process process = processBuilder.start();

	    InputStream is = process.getInputStream();

	    String output = IOUtils.toString(is);
	    String[] lines = output.split("\n");

	    Map<String,String> workingMap = null;
	    for (String line : lines) {

	        if (line.startsWith("Module")) {
		    if (workingMap != null) {
	  	        Map<String,String> moduleMap = new HashMap<String,String>();
  		        moduleMap.putAll(workingMap);
		        results.add(moduleMap);
 		    }
		    workingMap = new HashMap<String,String>();
		    workingMap.put("Name", this.getModuleName(line));

	        } else {

	    	    String[] prop = this.getModuleProperty(line);
		    workingMap.put(prop[0], prop[1]);
	        }
	    }

	} catch (IOException ioe) {
	    logger.error("Error retrieving module details", ioe);
	    throw new AlfrescoRuntimeException("Error retrieving module details");
	}

	return results;
    }

    /* ------------------------------------------------------------ */
    /* Utility methods - unavailable to FreeMarker */
    /* ------------------------------------------------------------ */

    /**
     * Builds the list of arguments that are common to both Alfresco and Share calls.
     *
     * @param processBuilder the process builder to be used to execute the command
     * @return command and args WITHOUT the war file specified
     */
    protected String[] getCommonArgs(ProcessBuilder processBuilder) {
	String[] args = new String[5];
	args[0] = processBuilder.environment().get("JAVA_HOME") + "/bin/java";
	args[1] = "-jar";
	args[2] = "C:/Alfresco/bin/alfresco-mmt.jar";
	args[3] = "list";
	args[4] = "C:/Alfresco/tomcat/webapps/";

	return args;
    }

    /**
     * Extracts the module name from a line of alfresco_mmt.jar output.
     *
     * @param line a line of output
     * @return the module name
     */
    protected String getModuleName(String line) {
    	// Sample:
    	// Module 'org_alfresco_module_dod5015' installed in 'C:/ALFRES~1/tomcat/webapps/alfresco.war'

    	int startIdx = line.indexOf("'") + 1;
    	int endIdx = line.indexOf("'", startIdx + 1);

    	return line.substring(startIdx, endIdx).trim();
    }

    /**
     * Extracts the property name and value from a line of alfresco_mmt.jar output.
     *
     * @param line a line of output
     * @return an array where [0] = property name, [1] = propery value
     */
    protected String[] getModuleProperty(String line) {
    	// Sample:
    	//   -    Title:        Alfresco DOD 5015 Record Management Extension

    	String[] pair = new String[2];
    	pair[0] = line.substring("   -    ".length(), line.indexOf(":"));

    	int startIdx = line.indexOf(":") + 1;
    	pair[1] = line.substring(startIdx).trim();

    	return pair;
    }
}

ModuleInfo.ftl:

<h3>Installed Alfresco Modules:</h3>

<#assign alfMods = moduleInfo.getAlfrescoModules()>

<#if alfMods?size == 0>
    There are curently no Alfresco modules installed.
<#else>
    <table cellpadding="2">
	<tr>
   	    <th>Name</th>
	    <th>Title</th>
	    <th>Version</th>
	    <th>Install Date</th>
	    <th>Description</th>
	</tr>
	<#list alfMods as module>
	    <tr>
		<td>${module.Name}</td>
		<td>${module.Title}</td>
		<td>${module.Version}</td>
		<#-- convert install date to date so then we can format it back into the string we want -->
		<td>${module['Install Date']?datetime("EEE MMM dd hh:mm:ss zzz yyyy")?string.medium_short}</td>
		<td>${module.Desription}</td>	<#-- the MMT spells it wrong, so we must too -->
	    </tr>
	</#list>
    </table>
</#if>

<h3>Installed Share Modules:</h3>

<#assign shareMods = moduleInfo.getShareModules()>

<#if shareMods?size == 0>
    There are curently no Share modules installed.
<#else>
    <table cellpadding="2">
	<tr>
	    <th>Name</th>
	    <th>Title</th>
	    <th>Version</th>
	    <th>Install Date</th>
	    <th>Description</th>
	</tr>
	<#list shareMods as module>
	    <tr>
		<td>${module.Name}</td>
		<td>${module.Title}</td>
		<td>${module.Version}</td>
		<#-- convert install date to date so then we can format it back into the string we want -->
		<td>${module['Install Date']?datetime("EEE MMM dd hh:mm:ss zzz yyyy")?string.medium_short}</td>
		<td>${module.Desription}</td>	<#-- the MMT spells it wrong, so we must too -->
	    </tr>
	</#list>
    </table>
</#if>

Suggested improvements:

  • change the Java to use regular expressions to extract the details from the MMT output
  • make the presentation template pretty, mine is very plain

Alfresco Process Template on Classpath

Processing a template that is on the classpath instead of in the repository:

I’m deploying an Alfresco module (AMP) with a scheduled script that processes a FreeMarker template. The script resides on the classpath instead of in the repository and I thought it would be cleaner to deploy if the template was also on the classpath. I was sure that processing a FreeMarker template from the classpath must be functionality available in Alfresco out-of-the-box. However, after searching tirelessly for as long as my attention span would allow (admittedly not long) I couldn’t find such a call. So here is what I did…

All work was done on Alfresco 3.2r Enterprise.

The standard JavaScript API allows you to call processTemplate(template, args) on a node. “template” is either a string containing the FreeMarker or a node whose contents contains the FreeMarker. So I looked at org.alfresco.repo.jscript.ScriptNode and in particular at:

public String processTemplate(String template, Object args)

Then I looked at org.alfresco.repo.jscript.ClasspathScriptLocation since I knew the scheduled script bean uses it for the script which is on the classpath.

As described in the Alfresco Wiki (http://wiki.alfresco.com/wiki/3.2_JavaScript_API#Adding_Custom_Script_APIs) I extended the JavaScript API. I’ve already got several handy extensions in a NodeUtilScript Java class with an extension name of “nodeUtil” so I just added to it as follows:

/**
 * Process a FreeMarker Template against the given node.
 *
 * @param templateLocation the classpath of the template to execute
 * @param args Scriptable object (generally an associative array) containing the name/value pairs 
 *			   of arguments to be passed to the template
 * @param node the node to process the template against
 * @return output of the template execution
 * @throws AlfrescoRuntimeException
 */
public String processClasspathTemplate(String templateLocation, Object args, ScriptNode node) {

   ClasspathScriptLocation location = new ClasspathScriptLocation(templateLocation);

   try {
      // retrieve template content
      String template = IOUtils.toString(location.getInputStream());

      // process template
      return node.processTemplate(template, args);

   } catch (IOException ioe) {
      throw new AlfrescoRuntimeException("Error retrieving template", ioe);
   }
}

There’s not much to it:

  • create a ClasspathScriptLocation with a path to the template
  • get the template contents as an InputStream
  • use IOUtils.toString(InputStream) from Apache Commons IO to pull the template into a string
  • call processTemplate() on the given node using the retrieved template string, returning the result

It can then be called from my scheduled script (or from a web script).

Calling Script:

// get a node

var myNode = search.findNode("workspace://SpacesStore/c7e27390-12f0-44dd-b89b-ef63a8320d6b");

// prepare some data to pass to the template
var args = new Array();
args["arg1"] = "Hello";
args["arg2"] = "The World";

// process the template agains the node
var result = nodeUtil.processClasspathTemplate("alfresco/templates/email/MyTemplate.ftl", args, myNode);

MyTemplate.ftl:

I say, ${args["arg1"]!} to ${args["arg2"]!}.

Node-uuid is ${document.properties["sys:node-uuid"]}

So after executing the above script “result” contains “I say, Hello to The World. Node-uuid is c7e27390-12f0-44dd-b89b-ef63a8320d6b”.

Having my template deployable within my AMP really simplifies moving from development to UAT to production repositories. I don’t have to remember to actually upload it to the repository separately or to export it as an ACP and bootstrap it.

Of course, in many cases the template is in the repository for a very good reason – so that changes can be made to it by less technical users and those changes can be seen without restarting Alfresco. But it’s still nice to have the choice.

References:

Alfresco Wiki, 3.2 JavaScript API, Adding Custom Script APIs

http://wiki.alfresco.com/wiki/3.2_JavaScript_API#Adding_Custom_Script_APIs

Apache Commons IO (http://commons.apache.org/io/)

IOUtils (http://commons.apache.org/io/api-release/org/apache/commons/io/IOUtils.html)