Posterous theme by Cory Watilo

Filed under: user generated content

The table experience in social intranets

Last night I presentated at the NSW KM Forum, where I talked about the range of social intranet software options available on the market. While a lot of the subsquent conversation was about being social inside organisations, one of the more practical discussions was about the issue of working online with 'tables'... you know, like those you create in Word or Excel:

Excel
Creating tables and lists etc is a fairly common activity in the workplace. In fact, I suspect many people use tools like Excel more for organising information than they do actually number crunching. So if people are going to work effectively online together in a social intranet, then this type of functionality is an important requirement. Unfortuntely, creating and editing tables in rich text editors online has never been a fantastic experience but recently it has started to get a whole lot better.

Nothing yet beats a spreadsheet in terms of pure flexibility and tools, like sorting and calculations - so for really heavy lifting with tables you'll need to use a Web-based spreadsheet like Google Docs and Socialtext's Socialcalc, or embed a spreadsheet.

However, lets have a look at a few leading tools and how well they support tables:

Atlassian Confluence

The whole rich text editor has been given a massive upgrade in the latest version of Confluence and tables are a lot easier to use now that users don't need to worry about dealing with wiki markup (which has been removed in the new editor). Confluence's table editing is pretty good although Jive (see below) packs a few additional formatting features. However, as complete package Confluence also offers a range of file embedding, spreadsheet, charting, and task list macros that other platforms don't offer.

Confluence

Jive

Jive's table editor is still essentially based on HTML tables, however the user interface removes some of the complexity of fine detail formatting - you can set the padding, background colour, text alignment (horizontal and vertical), font and colour without feeling you are going anywhere near the HTML code.

Jive
Yammer

Not a lot of love from Yammer for tables, unfortunately. You'll need to make do with sharing spreadsheet files instead for anything more than dot points lists.

Yammer
"Generic"

Most other Web platforms use a common rich text editor plugin, like TinyMCE or CKEditor. Support for tables has improved in these plugins but IMHO vendors like Atlassian and Jive are still leading the way. Note: the editing experience on a particular platform will depend on the version of the rich text editor plugin supported and how it is configured.

Tinymce
As you can see, on a particular feature (and apparently simple one) like tables there is a lot of variability between different social intranet platforms. Is there a winner? Well, I wouldn't pick a platform on this feature alone but these are the sorts of requirements I want to understand when helping a client pick a platform. Its may sound like a minor detail, but if you want people to work online in your social intranets then its actually more important than some of the big ticket technical specs.

From the tibbr blog: Rethinking Social Architecture in the Enterprise

Cleaner, More Relevant Taxonomy and Architecture Means Cleaner Activity Streams

Having a cleaner social taxonomy will improve the quality and relevance of activity streams. Right now, too many streams inside companies are either a firehose of “everything” — or they filter by an individual group.

But businesses — especially large ones — are way more dynamic than that, and need more fine-grained controls that make it easy to create an activity stream based not only on people or system data, but concepts, ideas and projects related to each. So if you’re able to pull together relevant subjects — or sub-subjects — from your cleaner taxonomy, you’re going to have better, more relevant streams that map to specific business processes.

Conclusion: Finding the Middle Ground

Again, I’m not suggesting we revert back to the days of heavyweight information management that turns end-users and their administrators into managers of digital filing cabinets. At the same time, the sheer volume of information shared by both humans and machines today means that leaving this to the wisdom of the crowd might not work as well as many of us had initially hoped in the early waves of social computing.

Or as I like to think about - don't give users a completely blank sheet of paper.

Desktop tools critical to the "rapid-fire" investigation into the E. Coli breakout in Europe

The only type in common with both companies and all the mixtures was fenugreek.

That discovery sent EU investigators in pursuit of fenugreek seeds back down the European food chain, in a rapid-fire search that deployed personnel from eight countries’ food agencies as well as the ECDC, World Health Organization and the Food and Agriculture Organization of the United Nations. They drafted a detailed 4-page questionnaire that fed data into Excel spreadsheets and a relational database. They crunched (and crunched and crunched) the numbers, and this is what emerged:

All of the seeds came from a single shipment that left a port in Egypt almost 2 years earlier, on Nov. 24, 2009.

Interesting to note that following the E. coli outbreak in Europe, it all started with desktop tools (Excel) being used to collect data for the government investigation. Quoting directly from the European Food Safety Authority report (PDF) itself they used combination of tools:

Data on single parts of the food supply chain were gathered using spreadsheets (MS Excel) for each company. A relational database (HSQLDB version 2.2.4) was used to manage the data/information from the tracing. Additional processing was done using the statistical package SAS version 9.2.

Of course, you do wonder if the investigation could have happened even more quickly or even that the issue could have been pre-empted if Government 2.0 principles (open data, crowdsourcing) and technologies (Web 2.0) had been applied?

Despite this level of traceability, authorities are still concerned that this outbreak is actually not finished, because they couldn't trace every seed or batch that might be infected. Maybe there is still a necessary role for crowdsourcing in this instance that a traditional approach just can't scale to resolve?

Law and justice in our 21st century Web-era society #gov2au

Sunday Mail reporter Anthony Gough called me last week seeking my views on a Queensland Police Service Facebook site featuring public comments on crimes and arrests.

Of course, before making a media comment on the matter I took a closer look at the site.

I quickly formed the view that it seemed an excellent community policing tool and a great way for police to get information about unsolved crimes but that many comments crossed the line once suspects had been arreste

Mark Pearson, an academic who specialises in media law, caused a bit of a stir with his reported comments. However, one of the benefits of the Web is that we can go straight to the source and bypass the newspaper editorial filter. Personally I think this is still a grey area - there are still too many variables, such different jurisdictions (e.g. US where Facebook is hosted and Australia where the user live). We won't really know until something ends up in front of judge. An more ideal outcome is that the law (in Australia) will catch up with a common sense view towards social media that meets the needs of our 21st century Web-era society.

The Intranet is Dead! Long live the Human Centred Intranet!

Flip_clock_505

I've been trying to dig into the Digital Workplace intranet meme a little more.

For some context, at the beginning of the year Jane McConnell noted:

I’ve tested the term “digital workplace”  at two intranet conferences recently, one in Stockholm and one in Paris, and with several of my clients. The term has had an impact on management decisions in two recent client cases.

However, McConnell also reflects on the fact that the phrase itself isn't new and points to the use of the “digital workplace” back in 2000 and 2001. I actually found an even earlier reference, from HP back in 1997, who described its aim as:

to facilitate information sharing and to bring information closer to people

...by putting printers in offices. :-)

I'm also reminded of Negroponte's book, Being Digital - published in 1995. He wrote the following in a preview piece in Wired magazine about the future digital society he imagined:

I do believe that being digital is positive. It can flatten organizations, globalize society, decentralize control, and help harmonize people in ways beyond not knowing whether you are a dog. In fact, there is a parallel, which I failed to describe in the book, between open and closed systems and open and closed societies. In the same way that proprietary systems were the downfall of once great companies like Data General, Wang, and Prime, overly hierarchical and status-conscious societies will erode. The nation-state may go away. And the world benefits when people are able to compete with imagination rather than rank.

Taking on board some comments from Twitter about this I can fully appreciate the need to coin simple phrases that intranet managers can use to influence and get the attention of their internal sponsors. But lets be clear: the digital workplace isn't coming, it was already here from the moment the first desktop PC clone appeared in offices. Think about the impact of the humble spreadsheet.

In another blast from the past, consider Davenport's insightful 1994 HBR article, Saving IT’s Soul: Human-Centered Information Management. I wrote this reflection on Enterprise 2.0 and Davenport in 1997 and summarised the following from Davenport's original article:

  • Focus on broad information types;
  • Emphasize information use and sharing;
  • Assume transience of solutions;
  • Assume multiple meanings of terms;
  • Continue until desired behaviour is achieved enterprisewide;
  • Build point-specific structures;
  • Assume compliance is gained over time through influence; and
  • Let individuals design their own information environments.

Not only does this advice still hold true today, but we finally have the tools to do it. Yet this was written over a decade and a half ago!

We could go back even further of course... Vannevar Bush, Douglas Engelbart, etc.

Clay Shirky on the other hand first started talking about 'social software' in 2002.

So where does this leave the Digital Workplace? I just can't help feeling that the intranet community - and I mean those who are currently focused on the narrow domain of publishing or communicating digital information to staff - are at a tipping point. I hope as many as possible make the right choice and engage with current perspectives, rather than holding on to the past remade.

In any case, the Human Centred Intranet doesn't quite roll off the tongue, does it?

Image Credit: Flip Clock 5.05 CC NC-ND

Can you deploy collaboration software out of the box?

Mark Gilbert from Gartner spoke at the Gartner BI summit in Sydney recently. He said that firms shouldn't deploy collaboration software "out of the box" - I disagree, but I disagree because I'm being pedantic, although I think it is important to be so given this is a Gartner person speaking.

Overall, I think Michael is right to be pedantic. What I'm not clear from Gilbert's statement is that when he talks about the need to adapt collaboration (and social software), is he talking about actual developed customisations or customisations achieved through configuration and user-generated information architecture.

However, Gilbert also mentions SharePoint - and that does complicate things, because of the way I typically see SharePoint deployed, which is with little thought. If we read "out of the box" SharePoint to mean, you've just finished installing the software, switched it on, and announced job done then I can understand why Gilbert might be concerned.

Does this argument hold for enterprise social computing tools? It depends. Architecturally speaking, other "pure" tools of this type (by which I mean, are designed to be or have specific heritage in social software) typically have a greater resilience for dealing with organic and emergent usage. However, I would also encourage people to design for adoption anyway, remaining open to exploring customisation through both development and configuration based on user's and business needs.

Bringing me back to the beginning... you can *sometimes* deploy out of the box. But even while that might be the end of your technical activities, its only the start of the project.

BTW You can come and debate this with Michael and I at the Intranets2011 conference, where we are both presenting.

What about curating intranet content, not managing it?

Media_httpwwwheadshiftcomblogclimatepulseflowthumb450x338jpg_fatsbhbaeqcxhac

Robin's post has grabbed a lot of people's attention over the last 24 hours, and its not surprising. When Paolo from eVectors demo'd their technology to me I was really impressed too - in fact, the front end of the Climate Pulse example gives only a few clues about the engine that enables the curating process that Robin describes to happen.

However, my immediate thought when I saw Climate Pulse was, wouldn't this also make a good concept for an intranet?

Could it in fact be possible to shift from the idea of managing content on intranets and instead think about curating it instead? Its an interesting idea that could make intranets more relevant - just like dashboards for metrics have become popular, can we also imagine dashboards for content and activity that are curated by people, not dumb algorithms?

So, you don't want people commenting on your Website? Watch out for Google's Sidewiki

I don't want to pick on the SMH in particular, but it was the first site I found with some real comments attached:

Pastedgraphic

BTW You don't have to install Sidewiki to follow the comments, there is an RSS stream (e.g. the SMH home page) although it appears to be restricted the comments per URL not the whole domain. The API for this service also means we could expect to see a bunch of new tools appearing that take advantage of it, e.g. Twitter integration.

One defence against SideWiki are encrypted (HTTPS) pages. And luckily for intranet managers, SideWiki doesn't support comments on internal sites. Yet, anyway...