Alfresco Dynamic Content Rules

I needed a way to create rules dynamically in script. You can do this in Java but the API is not the most pleasant thing to use. What if you’ve just created a space in a script and you want to add rules to it? I couldn’t find any way of doing this but it wasn’t that difficult to piece together a solution.

All work was done on Alfresco 3.2r Enterprise.

Disclaimer: There’s always a chance that I’ve missed some other way of doing this in Alfresco that doesn’t involve coding. But sometimes it’s more interesting and you learn more when you dig in and do it yourself.

Getting Started

So I did some Googling and found this post in the Alfresco Wiki that let me know it was possible:

However, I don’t have the option of enabling “remote” on the server.

But the idea of describing a rule in JSON in a script then passing it to a Java class to do the work fits well with what I need to in my project.

I poked around the Alfresco code a bit and found org.alfresco.web.bean.rules.CreateRuleWizard, the class used for the Alfresco Explorer’s rule wizard.

It seemed to have the functionality I needed, I just had to figure out a way to pull the rule from JSON rather that from the UI.

The JSON

I used the JSON format in this page as a starting point:

I modified it based on what the various action and condition handlers expect for parameter names.

See the “Using It” section below for some sample JSON.

TIP: JSONLint is a very handy tool.

The Java

I decided to build a class that would read the rule configuration from JSON objects. I called this JsonRuleCreator and it extends CreateRuleWizard mostly to use its condition and action handlers.

Unlike a lot of other Alfresco code that I’ve seen, CreateRuleWizard seems to have been coded with the possibility of extension in mind. It’s nice to see “protected” used instead the “private” I’ve come to expect in their classes (but I won’t get started on that rant).

The constructor takes a couple of helper classes. They important thing here is the call to CreateRuleWizard.init(). This initializes the maps of condition handlers and action handlers, key on “conditionName” and “actionName” respectively in the JSON.

public JsonRuleCreator(ServiceRegistry serviceRegistry, Repository repository) {
  this.serviceRegistry = serviceRegistry;
  this.repository = repository;

  super.init(null);
}

The createRule() method sets some of the simple rule properties such as title, description, etc in the parent class, calls setupRule() to set the more complex rule properties, then attaches the rule to the space.

public void createRule(NodeRef targetSpace, JSONObject ruleJson) throws JSONException {
  if (logger.isDebugEnabled()) {
    logger.debug("creating rule");
  }
  this.ruleJson = ruleJson;

  this.setTitle(this.ruleJson.getString("title"));
  this.setDescription(this.ruleJson.getString("description"));
  this.setType(this.ruleJson.getString("ruleType"));
  this.setRunInBackground(this.ruleJson.getBoolean("executeAsynchronously"));
  this.setApplyToSubSpaces(this.ruleJson.getBoolean("applyToChildren"));
  this.setRuleDisabled(this.ruleJson.getBoolean("disabled"));

  // create the new rule
  Rule rule = new Rule();
  rule.setRuleType(this.getType());

  // setup the rule
  this.setupRule(rule);

  // save the rule
  this.getRuleService().saveRule(targetSpace, rule);
}

The setupRule() and createCondition() methods do most of the real work. These are basically CreateRuleWizard.setupRule() and createCondition() modified to read from JSON objects.

The other method of note in convertJsonToMap() which converts a JSON object into a Map that CompositeCondition and CompositeActionCondition expect. For scripts and destination locations for things like move and copy, the Alfresco code expects a node reference. However I need to be able to have my script work on several different servers (DEV, UAT, PROD) that will all have different node references. So to allow the JSON to be more portable, I had this method convert repository paths to node references for “script” and “destinationLocation” parameters.

Gotcha 1: The handlers that use the “script” parameter assume the node reference is a string. The handlers that use the “destinationLocation” parameter assume the node reference is a NodeRef. So this method converts node references to the correct object type based on the parameter name.

Gotcha 2: Boolean parameter values pose a similar problem. So this method converts any “true” or “false” values to a Boolean object. And so on for Integer, Long and Double.

protected Map convertJsonToMap(JSONObject jsonObj) throws JSONException {

  // convert JSON to Map
  Map propMap = new HashMap();
  Iterator keyIt = jsonObj.keys();
  while (keyIt.hasNext()) {
    String key = (String) keyIt.next();
    String value = jsonObj.getString(key);
    Serializable propValue = null;

    // convert repository paths to node references
    if (PROP_SCRIPT.equals(key) || PROP_DESTINATION.equals(key)) {

      NodeService nodeService = this.serviceRegistry.getNodeService();
      NodeRef nodeRef = null;
      String storeProtocol = null;
      String storeIdentifier = null;
      String nodeUUID = null;

      // is value a node reference?
      if (NodeRef.isNodeRef(value)) {
        nodeRef = new NodeRef(value);

        storeProtocol = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_PROTOCOL);
        storeIdentifier = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_IDENTIFIER);
        nodeUUID = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_NODE_UUID);

      } else {

        // assume we have a repository path relative to Company Home
        // search for the path within Alfresco content repository
        String nodePath = "workspace/SpacesStore/" + value;
        nodeRef = this.repository.findNodeRef("path", nodePath.split("/"));

        if (nodeRef == null) {
          throw new JSONException("Path " + nodePath + " not found.");

        } else {
          storeProtocol = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_PROTOCOL);
          storeIdentifier = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_IDENTIFIER);
          nodeUUID = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_NODE_UUID);

          logger.debug("Original parameter value: " + value);
          value = storeProtocol.concat("://").concat(storeIdentifier).concat("/").concat(nodeUUID);
          logger.debug("Modified parameter value: " + value);
        }
      }
      if (PROP_SCRIPT.equals(key)) {
        propValue = value;

      } else if (PROP_DESTINATION.equals(key)) {
        propValue = nodeRef;
      }
    }
    if (propValue == null) {
      if (value.equalsIgnoreCase("true") || value.equalsIgnoreCase("false")) {
        propValue = jsonObj.getBoolean(key);
      }
    }
    if (propValue == null) {
      try {
        propValue = jsonObj.getInt(key);

      } catch(JSONException jsone) {
        // not an integer, continue
      }
    }
    if (propValue == null) {
      try {
        propValue = jsonObj.getDouble(key);

      } catch (JSONException jsone) {
        // not a double, continue
      }
    }
    if (propValue == null) {
      try {
        propValue = jsonObj.getLong(key);

      } catch (JSONException jsone) {
        // not a long, continue
      }
    }
    if (propValue == null) {
      // default to String
      propValue = value;
    }
    propMap.put(key, propValue);
  }
  return propMap;
}

Now I just need to expose this to JavaScript. I created a RuleUtilScript class that extends org.alfresco.repo.jscript.BaseScopableProcessorExtension to handle this.

The createRule() method takes a space to add the rule to and a JSON string describing the rule. All it does is parse the JSON string into an object and call the JsonRuleCreator to do the work.

public void createRule(ScriptNode targetSpace, String ruleJson) throws JSONException {
  JSONObject json = new JSONObject(ruleJson);

  JsonRuleCreator jrc = new JsonRuleCreator(this.serviceRegistry, this.repository);
  jrc.createRule(targetSpace.getNodeRef(), json);
}

And we need to define this bean:

<bean id="ruleUtilScript" parent="baseJavaScriptExtension">
  <property name="extensionName">
    <value>ruleUtil</value>
  </property>
  <property name="serviceRegistry">
    <ref bean="ServiceRegistry">
  </ref></property>
  <property name="repository" ref="repositoryHelper">
</property></bean>

Using It

This script creates a new space under Company Home and attaches a rule to it called “Make Uniform”.
This rule:

  • is triggered on inbound TIFF and PDF files (based on mime type).
  • is applied to child spaces and runs in the background.
  • executes a script found in the repository **that must exist before you create the rule**.
var myspace = companyhome.createFolder("My Space");

var ruleJson = '';
ruleJson += '{';
ruleJson += '  "title": "Make Uniform",';
ruleJson += '  "description": "Makes submitted TIFF and PDF files uniform",';
ruleJson += '  "ruleType": "inbound",';
ruleJson += '  "applyToChildren": "true",';
ruleJson += '  "executeAsynchronously": "true",';
ruleJson += '  "disabled": "false",';
ruleJson += '  "action" : {';
ruleJson += '    "actionName": "composite-action",';
ruleJson += '    "actions": [';
ruleJson += '      {';
ruleJson += '        "actionName": "script",';
ruleJson += '        "parameterValues": {';
ruleJson += '          "script": "CompanyHome/Data Dictionary/Scripts/MakeUniform.js"';
// WE COULD HAVE USED A NODE REFERENCE HERE INSTEAD...
//          			 "script": "workspace://SpacesStore/75f01003-46eb-479e-a492-beae589aa5d4"
ruleJson += '        }';
ruleJson += '      }';
ruleJson += '    ],';
ruleJson += '    "conditions": [';
ruleJson += '      {';
ruleJson += '        "conditionName": "composite-condition",';
ruleJson += '        "orconditions": "true",';
ruleJson += '        "notcondition": "false",';
ruleJson += '        "conditions": [';
ruleJson += '          {';
ruleJson += '            "conditionName": "compare-mime-type",';
ruleJson += '            "mimetype":  "image/tiff",';
ruleJson += '            "notcondition": "false"';
ruleJson += '          },';
ruleJson += '          {';
ruleJson += '            "conditionName": "compare-mime-type",';
ruleJson += '            "mimetype": "application/pdf",';
ruleJson += '            "notcondition": "false"';
ruleJson += '          }';
ruleJson += '        ]';
ruleJson += '      }';
ruleJson += '    ]';
ruleJson += '  }';
ruleJson += '}';
logger.log("RULE JSON:\n" + ruleJson);
ruleUtil.createRule(myspace, ruleJson);

Action/Condition/Parameter Names

Here are lists of actions and condition names and thier handler classes. See the prepareForSave() methods on the handlers to figure out the expected parameter names and types. I found these by setting a breakpoint in CreateRuleWizard.initialiseActionHandlers().

TIP: It’s also handy to run Alfresco in debug mode and put a breakpoint in CreateRuleWizard.finishImpl() and step through rules you create in the UI. This helped me discover less obvious parameters like the “All Items” and “Items which contain a specific value in its name” conditions.

Valid values for “actionName” composite-action

  • transform-image (org.alfresco.web.bean.actions.handlers.TransformImageHandler)
  • mail (org.alfresco.web.bean.actions.handlers.MailHandler)
  • copy-to-web-project (org.alfresco.web.bean.actions.handlers.CopyToWebProjectHandler)
  • check-in (org.alfresco.web.bean.actions.handlers.CheckInHandler)
  • simple-workflow (org.alfresco.web.bean.actions.handlers.SimpleWorkflowHandler)
  • script (org.alfresco.web.bean.actions.handlers.ScriptHandler)
  • transform (org.alfresco.web.bean.actions.handlers.TransformHandler)
  • remove-features (org.alfresco.web.bean.actions.handlers.RemoveFeaturesHandler)
  • specialise-type (org.alfresco.web.bean.actions.handlers.SpecialiseTypeHandler)
  • link-category (org.alfresco.web.bean.actions.handlers.LinkCategoryHandler)
  • import (org.alfresco.web.bean.actions.handlers.ImportHandler)
  • add-features (org.alfresco.web.bean.actions.handlers.AddFeaturesHandler)
  • move (org.alfresco.web.bean.actions.handlers.MoveHandler)
  • copy (org.alfresco.web.bean.actions.handlers.CopyHandler)
  • check-out (org.alfresco.web.bean.actions.handlers.CheckOutHandler)

Valid values for “conditionName”

  • composite-condition (org.alfresco.web.bean.rules.handlers.CompositeConditionHandler)
  • compare-mime-type (org.alfresco.web.bean.rules.handlers.CompareMimeTypeHandler)
  • compare-property-value (org.alfresco.web.bean.rules.handlers.PropertyValueHandler)
  • has-aspect (org.alfresco.web.bean.rules.handlers.HasAspectHandler)
  • in-category (org.alfresco.web.bean.rules.handlers.InCategoryHandler)
  • is-subtype (org.alfresco.web.bean.rules.handlers.IsSubTypeHandler)
  • compare-date-property (org.alfresco.web.bean.rules.handlers.property.DatePropertyValueConditionHandler)
  • compare-integer-property (org.alfresco.web.bean.rules.handlers.property.IntegerPropertyValueConditionHandler)
  • compare-text-property (org.alfresco.web.bean.rules.handlers.property.TextPropertyValueConditionHandler)

Other than a little trial-and-error on the parameter names, that’s it. I find myself using very similar rules repeatedly so there was just a bit of pain the first time to figure out a rule’s JSON. After that…well I’m an excellent cutter and paster.

Full Java Source for JsonRuleCreator

package ca.abstractive.ecm.alfresco.rules;

import java.io.Serializable;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;

import org.alfresco.model.ContentModel;
import org.alfresco.repo.model.Repository;
import org.alfresco.service.ServiceRegistry;
import org.alfresco.service.cmr.action.Action;
import org.alfresco.service.cmr.action.ActionCondition;
import org.alfresco.service.cmr.action.CompositeAction;
import org.alfresco.service.cmr.action.CompositeActionCondition;
import org.alfresco.service.cmr.repository.NodeRef;
import org.alfresco.service.cmr.repository.NodeService;
import org.alfresco.service.cmr.rule.Rule;
import org.alfresco.web.bean.actions.IHandler;
import org.alfresco.web.bean.rules.CreateRuleWizard;
import org.alfresco.web.bean.rules.handlers.BaseConditionHandler;
import org.alfresco.web.bean.rules.handlers.CompositeConditionHandler;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

public class JsonRuleCreator extends CreateRuleWizard {

  /** the value of this parameter must be a node ref as a String */
  protected static final String PROP_SCRIPT = "script";

  /** the value of this parameter must be a node ref as a NodeRef */
  protected static final String PROP_DESTINATION = "destinationLocation";

  protected JSONObject ruleJson = null;

  protected ServiceRegistry serviceRegistry = null;

  protected Repository repository = null;

  public JsonRuleCreator(ServiceRegistry serviceRegistry, Repository repository) {
    this.serviceRegistry = serviceRegistry;
    this.repository = repository;

    super.init(null);
  }

  /**
   * Creates a rule on the given space using rule properties
   * provided via JSON in the constructor.
   *
   * @param targetSpace the space the rule will apply to
   * @param ruleJson a JSON object describing the rule to create
   * @throws JSONException if error parsing JSON string
   */
  public void createRule(NodeRef targetSpace, JSONObject ruleJson) throws JSONException {
    if (logger.isDebugEnabled()) {
      logger.debug("creating rule");
    }
    this.ruleJson = ruleJson;

    this.setTitle(this.ruleJson.getString("title"));
    this.setDescription(this.ruleJson.getString("description"));
    this.setType(this.ruleJson.getString("ruleType"));
    this.setRunInBackground(this.ruleJson.getBoolean("executeAsynchronously"));
    this.setApplyToSubSpaces(this.ruleJson.getBoolean("applyToChildren"));
    this.setRuleDisabled(this.ruleJson.getBoolean("disabled"));

    // create the new rule
    Rule rule = new Rule();
    rule.setRuleType(this.getType());

    // setup the rule
    this.setupRule(rule);

    // save the rule
    this.getRuleService().saveRule(targetSpace, rule);
  }

  /**
   * Sets up the given rule using rule properties provided via JSON in the constructor.
   *
   * @param rule the rule to setup
   * @throws JSONException if error parsing JSON
   */
  protected void setupRule(Rule rule) throws JSONException {

    // setup the rule 
    rule.setTitle(this.title);
    rule.setDescription(this.description);
    rule.applyToChildren(this.applyToSubSpaces);
    rule.setExecuteAsynchronously(this.runInBackground);
    rule.setRuleDisabled(this.ruleDisabled);

    JSONObject ruleAction = this.ruleJson.getJSONObject("action");

    // assume composite action
    CompositeAction compositeAction = this.getActionService().createCompositeAction();
    rule.setAction(compositeAction);

    JSONArray conditions = ruleAction.getJSONArray("conditions");
    for (int cIdx = 0; cIdx < conditions.length(); cIdx++) {
      JSONObject jsonCond = conditions.getJSONObject(cIdx);

      ActionCondition condition = createCondition(jsonCond);

      if (condition instanceof CompositeActionCondition) {
        CompositeActionCondition compositeCondition = (CompositeActionCondition) condition;

        compositeCondition.setORCondition(jsonCond.getBoolean(CompositeConditionHandler.PROP_CONDITION_OR));
        compositeCondition.setInvertCondition(jsonCond.getBoolean(CompositeConditionHandler.PROP_CONDITION_NOT));

        JSONArray subconditions = jsonCond.getJSONArray("conditions");

        for (int sIdx = 0; sIdx < subconditions.length(); sIdx++) {
          JSONObject jsonSubCond = subconditions.getJSONObject(sIdx);

          compositeCondition.addActionCondition(createCondition(jsonSubCond));
        }
      }
      compositeAction.addActionCondition(condition);
    }

    // add all the actions to the rule
    JSONArray actions = ruleAction.getJSONArray("actions");
    for (int aIdx = 0; aIdx < actions.length(); aIdx++) {
      JSONObject jsonAction = actions.getJSONObject(aIdx);

      String actionName = jsonAction.getString(PROP_ACTION_NAME);
      this.action = actionName;

      JSONObject jsonParams = jsonAction.getJSONObject("parameterValues");
      Map actionProps = this.convertJsonToMap(jsonParams);

      // get the action handler to prepare for the save
      Map repoActionParams = new HashMap();
      IHandler handler = this.actionHandlers.get(this.action);
      if (handler != null) {
        handler.prepareForSave(actionProps, repoActionParams);
      }

      // add the action to the rule
      Action action = this.getActionService().createAction(actionName);
      action.setParameterValues(repoActionParams);
      compositeAction.addAction(action);
    }
  }

  /**
   * Creates an action condition based on a JSON object
   *
   * @param jsonCond JSON object containing condition properties
   * @return an action condition
   * @throws JSONException if error parsing JSON object
   */
  private ActionCondition createCondition(JSONObject jsonCond) throws JSONException {
    String conditionName = jsonCond.getString(PROP_CONDITION_NAME);

    Map repoCondParams = new HashMap();

    Map conditionProps = this.convertJsonToMap(jsonCond);

    // get the condition handler to prepare for the save
    IHandler handler = this.conditionHandlers.get(conditionName);
    if (handler != null) {
      handler.prepareForSave(conditionProps, repoCondParams);
    }

    // add the condition to the rule
    ActionCondition condition = this.getActionService().createActionCondition(conditionName);
    condition.setParameterValues(repoCondParams);

    // specify whether the condition result should be inverted
    Boolean not = (Boolean) conditionProps.get(BaseConditionHandler.PROP_CONDITION_NOT);
    if (not == null) {
      not = Boolean.TRUE;
    }
    condition.setInvertCondition(((Boolean) not).booleanValue());
    return condition;
  }

  /**
   * Converts a JSON object to a Map
   *
   * @param jsonObj JSON object to convert
   * @return a Map where key is a String and value is a Serializable object
   * @throws JSONException if error parsing JSON object
   */
  @SuppressWarnings("rawtypes")
  protected Map convertJsonToMap(JSONObject jsonObj) throws JSONException {

    // convert JSON to Map
    Map propMap = new HashMap();
    Iterator keyIt = jsonObj.keys();
    while (keyIt.hasNext()) {
      String key = (String) keyIt.next();
      String value = jsonObj.getString(key);
      Serializable propValue = null;

      // convert repository paths to node references
      if (PROP_SCRIPT.equals(key) || PROP_DESTINATION.equals(key)) {

        NodeService nodeService = this.serviceRegistry.getNodeService();
        NodeRef nodeRef = null;
        String storeProtocol = null;
        String storeIdentifier = null;
        String nodeUUID = null;

        // is value a node reference?
        if (NodeRef.isNodeRef(value)) {
          nodeRef = new NodeRef(value);

          storeProtocol = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_PROTOCOL);
          storeIdentifier = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_IDENTIFIER);
          nodeUUID = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_NODE_UUID);

        } else {

          // assume we have a repository path relative to Company Home
          // search for the path within Alfresco content repository
          String nodePath = "workspace/SpacesStore/" + value;
          nodeRef = this.repository.findNodeRef("path", nodePath.split("/"));

          if (nodeRef == null) {
            throw new JSONException("Path " + nodePath + " not found.");

          } else {
            storeProtocol = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_PROTOCOL);
            storeIdentifier = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_STORE_IDENTIFIER);
            nodeUUID = (String) nodeService.getProperty(nodeRef, ContentModel.PROP_NODE_UUID);

            logger.debug("Original parameter value: " + value);
            value = storeProtocol.concat("://").concat(storeIdentifier).concat("/").concat(nodeUUID);
            logger.debug("Modified parameter value: " + value);
          }
        }
        if (PROP_SCRIPT.equals(key)) {
          propValue = value;

        } else if (PROP_DESTINATION.equals(key)) {
          propValue = nodeRef;
        }
      }
      if (propValue == null) {
        if (value.equalsIgnoreCase("true") || value.equalsIgnoreCase("false")) {
          propValue = jsonObj.getBoolean(key);
        }
      }
      if (propValue == null) {
        try {
          propValue = jsonObj.getInt(key);

        } catch(JSONException jsone) {
          // not an integer, continue
        }
      }
      if (propValue == null) {
        try {
          propValue = jsonObj.getDouble(key);

        } catch (JSONException jsone) {
          // not a double, continue
        }
      }
      if (propValue == null) {
        try {
          propValue = jsonObj.getLong(key);

        } catch (JSONException jsone) {
          // not a long, continue
        }
      }
      if (propValue == null) {
        // default to String
        propValue = value;
      }
      propMap.put(key, propValue);
    }
    return propMap;
  }
}

Full Java Source for RuleUtilScript

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

import java.util.List;

import org.alfresco.model.ContentModel;
import org.alfresco.repo.jscript.BaseScopableProcessorExtension;
import org.alfresco.repo.jscript.ScriptNode;
import org.alfresco.repo.model.Repository;
import org.alfresco.service.ServiceRegistry;
import org.alfresco.service.cmr.repository.ChildAssociationRef;
import org.alfresco.service.cmr.repository.NodeRef;
import org.alfresco.service.cmr.repository.NodeService;
import org.alfresco.service.cmr.rule.RuleType;
import org.alfresco.service.namespace.QName;
import org.apache.log4j.Logger;
import org.json.JSONException;
import org.json.JSONObject;

import ca.abstractive.ecm.alfresco.rules.JsonRuleCreator;

public class RuleUtilScript extends BaseScopableProcessorExtension {

  protected ServiceRegistry serviceRegistry = null;

  protected Repository repository = null;

  public RuleUtilScript() {
  }

  /**
   * Creates a rule (described by the given JSON) on the given space.
   * See {@link ca.abstractive.ecm.alfresco.rules.AtkJsonRuleCreator} for sample JSON.
   * Assumes the current user has permission to create rules on the space.
   *
   * @param targetSpace the space to create the rule on
   * @param ruleJson a JSON string describing the rule
   * @throws JSONException if error parsing JSON
   */
  public void createRule(ScriptNode targetSpace, String ruleJson) throws JSONException {
    JSONObject json = new JSONObject(ruleJson);

    JsonRuleCreator jrc = new JsonRuleCreator(this.serviceRegistry, this.repository);
    jrc.createRule(targetSpace.getNodeRef(), json);
  }

  public ServiceRegistry getServiceRegistry() {
    return serviceRegistry;
  }

  public void setServiceRegistry(ServiceRegistry serviceRegistry) {
    this.serviceRegistry = serviceRegistry;
  }

  public Repository getRepository() {
    return repository;
  }

  public void setRepository(Repository repository) {
    this.repository = repository;
  }
}

References:

 

This entry was posted in Alfresco, ECM and tagged by tim.frith. Bookmark the permalink.
tim.frith

About 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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>