Archive

Archive for September, 2010

Order out of purchase orders by using e-forms

September 24th, 2010

I was very interested in the recent experience of our Claromentis partners in Australia – with a significant client that presented them with what is on the face of it  a relatively simple problem – “please help us to automate our purchase orders”.

The interest here is that the organisation concerned had already spent a significant amount of funds on what might have been our own first reaction – a sophisticated and well designed portal where customers can log on, receive customised information and place orders that can be securely monitored and tracked.

Such process management systems are the focus of InfoCapture, the Claromentis e-forms application, and we have delivered a great number of such systems that deliver huge value to customers.

If you are interested you can log onto our e-forms demo system here, ( select the IC interface from the choice  ) and you can immediately review some examples.

But in this case that kind of approach just had not worked.

The reason? The lack of ability to impose change on the valuable customer base. For years they had become accustomed to submitting free form emails to orders@ourcustomername.com then sitting back expecting the service desk to work everything out and process the order efficiently.

They took a short look at a sophisticated portal, where they had to remember credentials and complete lots of data in a structured way – and voted with their feet. Back to orders@ and you sort it out, thank you very much.

The response of our partner was exemplary.

1)   Focus on the customer – if sending emails to orders@ is what they want to do, let them do it. We are your IT partner and we are supposed to make orders more efficient, not cut down on their number.

2)   Preserve your goal of increased  customer service through automation. There is a business problem to face and we need to resolve it.

The result was exactly in line with these requirements. The implementation was as follows :

a)   Use mail fetching from InfoCapture to automatically open the request in the process from the free form email, using mail fetching – a standard feature of InfoCapture.

b)   Use notifications to alert the administrators at our customer that a new order had been received

c)   The administrators then completed the required fields in the request form of the e-form process, not the customer, simply by reading the email. They then assigned the request to the appropriate staff, based on the details of the order – and the process, complete with status changes and automatic notifications – takes over.

The result – a very happy customer, and orders that are processed much more efficiently, with full reporting, without the customers changing their own behaviour at all.

These kinds of lessons are important, in my view.

1)   Those of us that spend our lives applying information management processes to increase the efficiency of a business might, if we are not careful, over-engineer a process. In e-forms, like in a lot of things, there is no value in doing anything “just because we can”, and sometimes a lot of risk.

2)   Don’t think that obviously sophisticated systems will impress your customers, or indeed suppliers, just by their obvious functionality and power. Customers buy goods and services from lots of companies, and if we all ask them to jump through hoops they can always go somewhere where it’s easier.

In summary as a supplier of web based software for businesses we must always make sure we are aware of the importance of change management.

This order processing case study was a particularly clear example where the illusion of leaving the customer in the old world, while fulfilling the orders in a modern process driven e-form made the solution extremely effective.

But there are many, many instances in information platforms where simple is the best, and power should be kept hidden under the hood.

If you have an e-form problem with your purchase orders you might like to  contact Claromentis Australiaor any Claromentis regional office – we would be happy to share our experiences.

Intranet-Extranet, Prod-Process

The Claromentis Team

September 23rd, 2010

I often ask myself how Claromentis continues to deliver quality solutions and meet deadlines that appeared impossible from the start. It’s only when I’m traveling and “outside the box” do I realize what it really takes to achieve the seemingly unachievable….

Here are the golden rules I see work for us at present:

1. At Claromentis, we refer to our staff collectively as “The Team”. We work together as a team; sharing delight, happiness, frustrations and success in all that we do within the workplace (and regularly outside of work also)

2. Every member of the Claromentis Team brings something different to the table, and everything brought to the table is considered as equal value – regardless of the weight or longevity behind the person presenting it. We are all equal.

3. We each share our opinions freely and contribute to tasks, discussions and problem solving that occur day-to-day – regardless of our direct involvement in the subject. No-one’s opinion is ignored, no opinion is ever incorrect/wrong.

4. We praise each other. If someone does something we like, we tell them. Praise creates a positive attitude and a sense of achievement. We all like positive feedback and rewards – so don’t ever hesitate telling someone they’ve done a good job

5. Freedom – Freedom of speech, creativity, flexibility and respect. Say what you feel, throw those wild ideas out there, throw-in an objective opinion, get involved with some scribbles/art/design on one of the 7 whiteboards, introduce something new to the way we work, go get a haircut outside of your lunch-break, respect the peace if someone needs it, be considerate of others (share sweets/chocolate and ice-cream etc)….

6. Conversation is crucial. We talk to each other throughout the day. We discuss projects, life, technology, jokes etc. This helps creative an atmosphere that everyone is comfortable with… a place that feels more relaxed, despite pressures of looming deadlines.

7. Ask questions – “If you don’t ask, you won’t get” – “If you don’t ask, you might deprive someone of the opportunity to help you”. We all ask questions; even if it’s something that we should know ourselves… just don’t ever be afraid of asking questions. We all do this at Claromentis, and it’s something that helps bring us together and create a sense of value.

8. If you don’t agree with it, challenge it. Claromentis allows anyone to challenge the things we do, the way we work and how we go about our business. A challenge is only “attacking” if it’s received like so. Without a challenge; an alternative opinion; you may never see or believe of a better way of achieving a goal.

9. Don’t stop learning, don’t stop teaching, and don’t stop sharing…. Claromentis pushing everyone to achieve things that might not believe he or she can/could/ever could. We encourage our staff to push their boundaries and extend their skills. This is beneficial for the individual as well as the company, and keeps minds active.

10. Support each other – Despite us all having our own domains to protect and serve, all Claromentis staff have an open ethos on helping others. Regardless of the topic, the time, the pressure of our own projects, we will always try our best to support a colleague in need.

These are just some of the things that keep our team culture alive and healthy (I could have gone on). All the points above give us a sense of belonging and value – something that I believe is crucial to creating a successful team; a successful organization.

So while I prepare for my second day of training in Calgary, Canada, I can sleep comforted by the knowledge that I have a team of highly skilled individuals backing me.

If I log a few issues with them tonight, I’m 100% confident that they’ll be resolved by the time I wake up tomorrow morning. This confirms to me that we have an unbeatable team…one that continues to grow, and one that will continue to strengthen.

Resources-Technical

Intranet Universal Tagging Enhancements

September 17th, 2010

The information management system of Claromentis 6.0 now benefits from enhanced universal tagging.

As the image below shows Tag clouds in News and Documents produce an interactive interface to related information.

Tag Coud

Tags are auto created from the front end by users, if the appropriate Tag is not already in the system. Administrators can also control which users can create Tags, using the standard intranet permissions of users, groups, roles and extranet areas.

The multi-language system of Claromentis fully supports this enhanced tagging. Administrators can translate any Tags to all required languages. If there is no translation to the users language, the default language will be used for each Tag.

Multi lingual Tagging control

As it is universal application the Tag system has a dedicated are in the administration panel:

Administration for Universal Tagging

Administrators can clean up the Tag system, not just by deleting but also by merging similar Tags together. In this way the Tag system maintains a level of organization and does not decay over time.

Intranet-Extranet, Prod-Intranet , , , ,

Creating engaging Policy Management

September 14th, 2010

Good ‘Policy & Procedure’ management has always been critical for organisations affected by government legislation. But for most people reading this blog, I’m sure you’ll agree that it is bland at best. Most are created in an editor such as Microsoft Word with little thought to layout and general design. A conversion to PDF and saved into a shared drive normally completes the process, where they sit with very little use until their review the following year (or as dictated by the the relevant standards).

But here at Claromentis, we’ve created a solution that transforms the way Policies & Procedures will be viewed by an organisation. We’ve just started a project for a large Australian government department, which has included:

  1. converting all Microsoft Word based policies & procedures, and converting them into HTML
  2. implementing flip style reading (think ipad style readability)
  3. easy statistical figures regarding who has and hasn’t read a certain policy
  4. simple chapter navigation
  5. integrated discussion pages and wikis
  6. easy searching
  7. integrated electronic forms
  8. document version control and linking

Turning a page in a Claromentis Policy

All these features (and many more) will ensure that  policies and procedures become a true business asset, rather than something required just to tick a government approval standard.

Prod-Quality , ,

Remote networking can’t ever replace a face-to-face meeting

September 10th, 2010

Yesterday I went to Bond International to have a catch-up with one of my old managers. The purpose of the visit was for me to meet with with the Head of European Support and to pick his brains about how to grow a service desk inline with the growth of the company.

Being the world industry leaders in recruitment software, Bond International are undoubtedly a great company for me to model our support services on. Not only does the Bond Support Desk deliver an impeccable service, my old manager taught me most of the best practices that I still use today. Where better to go for advice, ideas and direction.

Not only did I find the experience very rewarding in terms of ideas, clarity and direction for the Claromentis Service, it also made me realize the importance of meeting people face-to-face. There is absolutely no way in my mind that the meeting could have been as rewarding and successful if our communication had been anything other than face-to-face.

As Claromentis continues to grow internationally, it’s becomes less common that we meet our clients face-to-face – at least until an on-site training session is given. Whilst we still manage to deliver successful projects using email and voice conferencing as our main communication tool, my recent experience does make me wonder….

How much more successful are projects that we get to meet the client face-to-face, in comparison with those that we don’t?

It’s a hard one to measure, if not impossible, since much of it is based on satisfaction and confidence levels, but I think we could all rate those areas in our mind.

My mind is made up… whilst a video conference could possibly get close, I just don’t see it achieving the same levels of satisfaction, understanding and rewarding as a face-to-face meeting.

Intranet-Extranet, Services

Claromentis Documents Export and Archiving

September 7th, 2010

Claromentis has created a simple procedure which allows a documents administrator to export all documents stored in Claromentis with its metadata into some location on the server / network drive for backup and archiving.

Click here to learn more about this functionality.

Intranet-Extranet, Prod-Document, Products, Services

Back to Front Intranets

September 5th, 2010

During the last few years Claromentis has been quietly moving things out of the back end and into the front end, for the empowered but untrained user to successfully run with. The modern web world is naturally providing a head wind in these efforts.

For this short blog I selected three short examples :

Content Management

Some years ago if you wanted to create a page on an intranet you needed to have read the manual, done the training and generally jump through some serious admin panels.

In the modern Intranet world that needs to empower knowledgeable business users to generate relevant and timely content, this is simply not good enough. And so now, when you look at a Claromentis intranet page, if you have permissions you see a great little toolbar – normally in the page footer.

No need to go to admin at all, and certainly no need for training. Just intent, knowledge and a company that wants to empower you.

Creating News

It’s the same with news – if you have permissions to create news in at least one permissioned channel – you see and ‘add news’ icon and you are off!

Creating an Innovation Idea Space

Naturally the basic concept in Claromentis has evolved significantly with the rise of intranet 2.0 corporate social networking, and a great example is the automatic creation of corporate idea spaces within Claromentis 6 that happens because users are discussing a topic.

In short similar examples are everywhere in Claromentis 6 – empower users and keep administrators doing what they should be doing – administrating not creating.

Intranet-Extranet, Prod-Intranet

Using ANSI Style SQL

September 5th, 2010
As a software vendor supporting MysQL, Oracle and MS SQL, it is often a challenge to get our developers to write consistent SQL calls for our database abstraction layer. How do we make sure that our queries will work for all 3 databases, easy to read, easy to understand and ultimately easy to support.
A lot of developers choose to work with the old Theta style when writing queries, as it is simpler to understand to begin with, for example
SELECT e.name, d.dept_name, r.region_name
FROM employee e, dept d, region r
WHERE d.id=e.dept_id
AND d.region_id=r.id
AND r.region_name=’EMEA’;
In ANSI style, this is equivalent to
SELECT e.name, d.dept_name, r.region_name
FROM employee e
INNER JOIN dept d on d.id=e.dept_id
INNER JOIN region r on r.id=d.region_id
WHERE r.region_name=’EMEA’;
I took me a while myself to become an ANSI style convert, but once I am used to using it, I can see that ANSI style offers many advantages.
Absolute CLARITY when performing outer joins.
I have worked with databases for close to 19 years, and I always get confused when using (+) in an outer join. An outer join uses a (+) on the side of the operator where we want to have nulls returned of if no value matches (now who can remember that?) ANSI style outer joins is so much more intuitive.
– When t2 might have no value matched
SELECT *
FROM table1 t1
LEFT JOIN table2 t2 ON t1.col1=t2.col1;
– When t1 might have no value matched
SELECT *
FROM table1 t1
RIGHT JOIN table2 t2 ON t1.col1=t2.col1;
– When no value matched could be on either table
SELECT *
FROM table1 t1
FULL OUTER JOIN table2 t2 ON t1.col1=t2.col1;
ANSI makes you think and write better queries
it makes you think about how you want the database engine to process your query. Rather than just stringing all your tables in the FROM clause (like FROM table1, table2, table3, table4) and hope for the best, it makes you think which one is your base table, what filtering you want applied to this table, and then whether a particular join functions as a filtering, or more as an enrichment. In the example below, I am interested to find the skillsets owned by an employee with the name SMITH who works in SUPPORT. So the way to write this query, is to as quickly as possible filter out the data that we do need from the EMP/DEPT table, prior to joining with the SKILLS table.
SELECT e.first_name, e.surname, d.dept_name, s.skill_name
FROM emp e
JOIN dept d ON d.id=e.dept_id and d.dept_name=’SUPPORT’ and e.surname=’SMITH’
JOIN SKILLS s on e.id=s.emp_id ;

Resources-Technical