Making nice graphs with such volume measures as “documents added, documents downloaded, community members etc.”, is all well and done, but the question that must resonate is “What real use are these to show how my business operates?!“.

Instead value drivers pushing forward action such as quality of information and process efficiency are the key to a successful and vibrant Intranet engaging employees.

“But how do I measure these intangible elements?”

Ensure a governance and architecture process around the information posted to your Intranet. Allowing a swaith of colleagues to upload anything and everything will soon clog your Intranet with information, firstly that doesn’t respond well to web technologies (think PowerPoint slides), and secondly creates an undefinable dumping ground and mess.

Then your job is to design value driven indicators assessing the performance of these intangible elements guiding your strategic decision making and learning; organisational value derived from indicators assisting day-to-day decision making processes and organisational learning! Not data volume!

You may find that colleagues, especailly senior colleagues are cautious over the implimentation of so-called community building or collaborative software. However, with the correct departmental governance and policing, and best practice of this area, community software can be utilised to its full benefit as a useful and integrated business tool.

Community building software can promote organic connections between colleagues. This will, as a by-product, act as a structured storage mechanism for unstructured corporate knowledge which otherwise would only be held between individuals in an un-retrievable unstructured manner.

These types of electronic storage mechanisms are used to great effect within industry leading technology companies such as IBM and Microsoft. Organically structured groups of colleagues are able to liaise from a single recordable point removing the obvious issues of geographical displacement. There is also an instant removal of cottage industries updating and managing phone lists, structure charts, etc. The community area can remove pressure from traditional means of business communication such as email.

Software such as Microsoft SharePoint MySite’s potential, for instance, can be realised if embedded within already established business processes. For the majority, people associate social networking with Internet based networks such as Facebook and MySpace; certainly at the opposite end of the spectrum and barely recognisable as productivity tools! The potential though to improve performance and cut costs is certainly possible should such an Intranet community be used productively and ring-fenced in a business setting.

The key to successfully utilising social media at work lies in comprehending it is very different in nature to its vaguely similar consumer cousins. With a different approach social networking can exploit the simple rationale pulling individuals into consumer resources: that of a simple purpose! Business social networking requires a defined business purpose with specific usage guidelines providing real leverage such as building teamwork, organisation around projects, and organically building a corporate knowledge base.

A community Wiki building a corporate knowledge base, for instance, categorising and built from what would otherwise be unobtainable unstructured data kept in varying hetrogeneous systems, paperwork, peoples heads, can be fashioned to store searchable data and information access to the entire organisation – of what would generally only be available to the few.

Historically, teamwork built through staff meetings, company team building workshops, team nights out, departmental parties, etc. are face-to-face interactions. The flip-side can be an electronically stored impressionistic sense of business activity formed around colleagues actively publishing activities around them. Largely self-organising and leaving a permanent organic record of communication around, say, a project otherwise not existing, can generate implicit awareness to colleague work groups.

Ultimately this can replace, but probably not in its entirety, traditional communication mediums such as the email list which lacks structure and is difficult to manage. An Intranet social network on the other hand provides many-to-many communication within a structured and collaborative environment.

I was passed a fantastic link to Joel Olesons’s blog post on the Microsoft Developer Network at:

http://blogs.msdn.com/joelo/archive/2007/03/16/information-architecture-and-the-information-architect.aspx

Though Joel’s post is essentially discussing the deployment of Microsoft Sharepoint in an Enterprise environment its essentially questioning the very core of what is an Intranet environment for any content management! Not only deloying technology but past/current Intranet structures too on whatever CMS!

Noted painfully is the central question missed time and time again of  “Who actually owns an Intranet?”. Large organisations inherently contain internal power struggles between various departments as a matter of course, but to miss the potential glue between these with a misconfigured and misunderstood “Intranet” is not only costly in technology itself, but also collaborative and  potential productivity that can be gained from having one in the first place. Siloed information architecture and strategy is the exact opposite of these key tenants.

Why do companies have an Intranet? Mostly because someone somewhere managed to convince those with the purse strings that it would increase these key tenants of collaboration and productivity or simply just in having a centralised communicative point. “Rhetorically” … why then are these points in their entirety lost and never fulfilled?

/etc/init.d/messagebus restart
/etc/init.d/haldaemon restart

Not listed verbs, adjectives nor articles but the below arrays are very handy should one be running language based queries over rendered pages.

Why? I dunno … say you’re trying to make a tag cloud or something but it’s full of filler words!

Articles are “a”, “an” and “the” only for English. Verbs and adjectives, well that’ll be down to what you’re up to I guess?!

Here’s a little code snippet to export an HTML table to MS Excel through utilising ActiveXObject(“Excel.Application”) from Internet Explorer.

The JavaScript (in this case utilising Microsoft’s JScript) runs over the table displayed pulling out the relevant data and exporting into the instantiated copy of Excel. This is a working example based loosely on Microsoft’s http://support.microsoft.com/kb/234774 Knowledgebase Article “How to automate Excel from an HTML Web page by using JScript”.

Worth noting is that the garbage collection between the JScript and MS Excel doesn’t work too well and more often than not one can be left with the instantiated copy of MS Excel still in memory (see it in the Task Manager). One must manually remove these instances.

Perhaps dynamically inputting a module to clean up from within MS Excel on the workbook deactivating might clear this up – not tried this though!?

Organisations anticipate a return on the investment involved in implementing Intranets expressed in financial terms or intangible benefits; an expectation their Intranet will either save money, enhance efficiency or both.

Organisations however, are not cohesive bodies with unified needs or interests; instead they are formed by individuals, each with their own intrinsic self-interest and motivations for working within the framework of an organisation. Organisational expectations when broadly defined conflict with the behaviour of users. Users’ expectations are practical, organisations expectations strategic ultimately providing an inherent tension between these different formulations of expectation.

The expectations then that organisations have of Intranets introduce inherent conflicts in their function. Intranets are expected to do several things simultaneously under the umbrella of a single resource: to merge the communicative function and the informative function; to do things cheaper and do things better; to disseminate new information and store old information.

Organisations often expect Intranets to take over existing functions, such as the dissemination of information without affecting the nature of those functions. For example, paper resources migrated to Intranets with little or no modification.

Ensuing Information Wasteland

Strategic expectations of organisations then create conflict in the implementation of Intranets from the tension between the qualities of information; a confusion between the communicative function and an informative function.

This single platform for all information needs becomes a confusing aggregate of differing types of information with different functions and different characteristics, all presented to the user as if they are of the same value – confusing end user expectations of information retrieval and in turn deflating the original assumption that an Intranet will “either save money, enhance efficiency or both”!

An examination of these “end-user” expectations are required to enable alignment with organisational expectations.

Have you noticed how the “out the box” solution to export your dataset from MS Access to MS Excel doesn’t give much room to give custom headers to your worksheet?

Through utlising ActiveX you can instantiate a copy of MS Excel in memory to add in your own custom headers etc. prior to exporting your MS Access dataset into the worksheet.

The below code example shows you how to add 5 custom headers to your sheet. Just add in your own SQL query where it is indicated.

Is it just me or has google added a margin around their search results? An ID of ‘gsr’ on the body tag appears to apply ‘margin: 3px 8px;’ bumping the results in at each side!

Clocked this on Tuesday night and thought it was a mistake with my setup or someone at google had screwed something up and it’d flip back – but no! Here we are and I’ve either gone mad or the margin is here to stay! I find it quite disconcerting to behonest.

Nah! Here’s to progressive development. Change is a good thing. . .  even if it’s some whitespace!

Stuck in a restrictive environment where you can’t alter your homepage settings? Check out the below WSH shell script to alter your homepage in Internet Explorer via the registry:

Set WSHShell = WScript.CreateObject(“WScript.Shell”)
‘ home page URL
StartPage = “http://www.yaduk.co.uk”
WSHShell.RegWrite “HKLM\Software\Microsoft\Internet Explorer\Main\Start Page”, StartPage
WSHShell.RegWrite “HKCU\Software\Microsoft\Internet Explorer\Main\Start Page”, StartPage

Stick in a text file with the extension .vbs

Below is a great code snippet to process XML dynamically through an XMLHttpRequest (XHR) request. From this further XSLT processing can be applied dynamically utilising Internet Explorers “fragment” transformations.

Information Architecture and Information Retrieval

Intranet information retrieval requires more often than not implicit end-user understanding to the nature and location of information sought since architecturally information organically mirrors organisational layout rather than information ‘typing’. Semantic linkage and intelligible meta data unfortunately take a back seat. As a result it is commonplace for “Intranet” users to consider Intranets an unresponsive technology in respect to finding and utilising information in their day to day jobs. One of the tenants to having an organisational Intranet in the first place!

For the majority, Intranet information retrieval issues are born from how individuals have learned ‘web technology interaction’ from the Internet. Bringing learned behaviours with them, end-users directly influence the effectiveness of organisational Intranets. For developers, Intranets should then be considered essentially as “socio-technical” devices requiring understanding of end-user interaction in the dissemination and retrieval of information.

It must be said that Internet users have a humungous resource from which they can narrow down something of interest or a link to a site of value in their quest. Within an Intranet environment this same search strategy fails due to the need for a defined information nugget rather as a rough guestimate.

Intranet Strategy – An holistic approach

Varying academic studies detail the extent of which Intranet implementation and use within individual organisations has significant implications for organisational performance. A key component in that performance is “technology adoption in the workplace [and its acceptance being directly] influenced [...] individual differences, social influences, beliefs, attitudes, and situational influences.” (Lee, S., & Kim, B.).

Evidence that organisations are “cultures, tribes, political battlegrounds, networks, [...]” (Checkland & Scholes, 1990); non-deterministic open systems, directly refutes the traditional deterministic approach to information systems development.

Organisations generally are viewed as “unitary systems with coherent purposes and goals rather than collections of people with many (sometimes conflicting) concerns”, (Clarke & Lehaney, 1997), in turn influencing the traditional approach that systems are – “autonomous purpose-directed systems […] with predetermined goals or sets of goals”, (Introna, 1996). These “hard systems” define objectives, modelled and measured against declared criteria, in an attempt to fulfil information needs and organisational goals.

“Soft systems” thinking, in comparison, gives credence to user perceptions and interaction, allowing us to understand underlying causal factors in Intranet complexity and their use. Examining and understanding these factors and their impact assists movement towards effective distribution and retrieval of information.

The intrinsic qualities of organisations generate a complex relationship between information creation, dissemination and use by end users – expectations of success of business strategies, information systems and people themselves disseminating and retrieving information impact on the implementation and use of an Intranet.

Important Intranet Considerations

Information systems are socio-technical systems requiring an understanding not only of technical/information infrastructure, but in the case of an Intranet, the end-user and how they inherently interact with the interface that is an Intranet.

Taking a view of “human computer interaction” in not only technology but also the overlying information, the process of Intranet information systems development and their inherent issues can much more readily be appreciated.

The predominant influence on Intranet use is learnt a priori from “outside-of-organisation” use of the Internet. When users come to Intranets, they do not usually experience the whole resource, but sub-sections of it, the parts they frequent regularly. It is therefore, imperitive that Intranets be designed with these factors in mind, limiting the scope of the resource as it is presented to each individual user, yet bringing those parts to the fore that are required habitually.

Significantly, a causal factor of Intranet failure is a distinct lack of process governance in content handling with the accuracy and relevance of information often going unchecked. Consequently content structuring ends up disparate across sub-sections leading to contrasting navigation systems independent from content types which in turn compounds retrieval issues.

The inability then to find information directly impacts “carrying out tasks and activities” and ultimately reduces productivity around the use of information disseminated through an Intranet. Addressing user expectations in their use of an organisational Intranet will aid in their alignment with any overall organisational strategy.

What are these? Well … email to find out! Taking stock of HCI: Human Computer Interaction against human interfaces is key to any ‘application’! – Hmm? What’s an Intranet or Internet interface? …… Hmm..!!?

Checkland, P. & Scholes, J. (1990). “Soft systems methodology in action“. Chichester: John Wiley & Sons.

Clarke, S. & Lehaney, B. (1997). “Critical approaches to information systems development: Some practical implications“. In Stowell, F., Ison, R., Holloway, R., Jackson, S. & McRobb, S., (Eds.), “Systems for sustainability: People, organisations and environments“, 333–337. New York: Plenum.

Introna, L. D. (1996). “Notes on ateological information systems development“. Information Technology & People, 9, 20–39.

Lee, S., & Kim, B. (2009, January). “Factors affecting the usage of intranet: A confirmatory study. Computers in Human Behavior”, 25(1), 191-201. Retrieved January 13, 2009, doi:10.1016/j.chb.2008.08.007

Excellent post in the MSDN microsoft.public.excel.programming community regarding the splitting of a firstname and lastname into two seperate columns.  The honours go to someone called “Bam”.

Last Name
=IF(ISERROR(LEFT(B2,FIND(“,”,B2,1)-1)),RIGHT(B2,LEN(B2)-(FIND(” “,B2,1))),LEFT(B2,FIND(“,”,B2,1)-1))

First Name
=IF(ISERROR(RIGHT(B1,LEN(B1)-(FIND(“,”,B1,1)+1))),LEFT(B1,FIND(” “,B1,1)+1-1),RIGHT(B1,LEN(B1)-(FIND(“,”,B1,1)+1)))

A few folk have asked how to just connect automatically to Essbase from Excel VBA. Please find below a simple VBA sub stripped back to show this. Use the following to initialise with your own details in place.

Call initialise("xxx","xxx","xxx","xxx","xxx")

Having used GUP from Netlobo http://www.netlobo.com/comments/url_query_string_javascript for some time to pull back parameters from the URL in JavaScript for fiddling with, I decided to create a handy JQuery extension for reuse.

Extending this further with the gpn section to get all parameters, which is also from their website, you’ll find within the below code the handy gpnv now too. The gpnv section pulls down all URL parameters and their values storing them in a handy 2D JavaScript array for manipulation.