Any internal LiveChat abilities for confluence available?

We are looking for a LiveChat solution which does integrate fully within confluence (no external 3rd party Server solution)

There was once a thread http://forums.atlassian.com/thread.jspa?messageID=257376669 telling that Atlassian is working on such a solution, which they already use for internal comm.

For security and reliability we would prefer an internal solution. Data on external 3rd party servers is forbidden due to possible espionage or loss of data.

Does anyone know progress or has a tip what to use?

3 answers

1 accepted

With openfire, it is pretty easy to use SQL macro to include chat room sessions on a Confluence page. We created a user macro to make it easier to put on a page

## param0 is the chat room name - required!!
## param1 defaults to table for output formatted in a table by time, specify text for plain text in a panel 
## param2 is the time interval in weeks - optional (defaults to 4 weeks back from today)

#set ($DQ = '"')
#set ($roomname = $param0)
#set ($weeks = 4)

#if ($param2)   
  #set ($weeks = $param2)
#end
#if ($param1 == "text")
  #set ($panel = "{panel}")
  #set ($sql-options = "output=html|table=false")
  #set ($sql-columns = "log.body || '<br>' as ${DQ}Text${DQ}")
  #set ($autorun = "false")
#else
  ## no panel, but cache results so they can be indexed
  #set ($panel = "{cache:refresh=3m|index=true}")
  #set ($sql-options = "output=wiki|sorticon=true|columnTypes=Dyyyy-MM-dd hh:mm:ss")
  #set ($sql-columns =  "timestamp with time zone 'epoch' AT TIME ZONE 'CST' + CAST(substr(log.logtime,1,12) as bigint) * interval '1 seconds' as ${DQ}Time${DQ}, '[~' || log.nickname || '] &nbsp; &nbsp; &nbsp; ' as ${DQ}User${DQ},   '{color:darkblue}' || log.body || '{color}' as ${DQ}Text${DQ}")
  #set ($autorun = "true")
#end

{run:autorun=${autorun}|replace=interval:$weeks:Time interval to display (in weeks)|titleRun=Display}

$panel
{sql-query:dataSource=openfireDS|${sql-options}}
select $sql-columns
  from ofmucconversationlog as "log", ofmucroom as "room" 
  where room.name = '$roomname' and room.roomid = log.roomid
  and timestamp with time zone 'epoch' AT TIME ZONE 'CST' + CAST(substr(log.logtime,1,12) as bigint) * interval '1 seconds' >= current_date - interval '$interval weeks'

  order by log.logtime
{sql-query}
$panel
{run}

Hy Bib, Thats cool. I will go into it and check this out with OpenFire and your user-macro

If it's just the chat server being external to your company that is the issue, but you don't mind running your own chat server you could deploy your own XMPP server (http://xmpp.org/xmpp-software/servers/) and use that with the Confluence IM Presence Plugin (https://studio.plugins.atlassian.com/wiki/display/PRES/Confluence+IM+Presence+Plugin)

Thanks, this sounds like a workable solution. The main issue is to store a chat to a page within confluence by one click or automatically. Did anyone manged to get this work on a mac server? We use Mac-Mini-Server as an Enterprise solution.

I've not used it in anger, but I've just installed OpenFire (http://www.igniterealtime.org/projects/openfire/index.jsp) from the above list of servers on my Macbook and it's pretty straightforward to use. Supports LDAP, SSL, Group Chat, external database or embedded HSQL.

With openfire, it is pretty easy to use SQL macro to include chat room sessions on a Confluence page. We created a user macro to make it easier to put on a page

## param0 is the chat room name - required!!
## param1 defaults to table for output formatted in a table by time, specify text for plain text in a panel 
## param2 is the time interval in weeks - optional (defaults to 4 weeks back from today)

#set ($DQ = '"')
#set ($roomname = $param0)
#set ($weeks = 4)

#if ($param2)   
  #set ($weeks = $param2)
#end
#if ($param1 == "text")
  #set ($panel = "{panel}")
  #set ($sql-options = "output=html|table=false")
  #set ($sql-columns = "log.body || '<br>' as ${DQ}Text${DQ}")
  #set ($autorun = "false")
#else
  ## no panel, but cache results so they can be indexed
  #set ($panel = "{cache:refresh=3m|index=true}")
  #set ($sql-options = "output=wiki|sorticon=true|columnTypes=Dyyyy-MM-dd hh:mm:ss")
  #set ($sql-columns =  "timestamp with time zone 'epoch' AT TIME ZONE 'CST' + CAST(substr(log.logtime,1,12) as bigint) * interval '1 seconds' as ${DQ}Time${DQ}, '[~' || log.nickname || '] &nbsp; &nbsp; &nbsp; ' as ${DQ}User${DQ},   '{color:darkblue}' || log.body || '{color}' as ${DQ}Text${DQ}")
  #set ($autorun = "true")
#end

{run:autorun=${autorun}|replace=interval:$weeks:Time interval to display (in weeks)|titleRun=Display}

$panel
{sql-query:dataSource=openfireDS|${sql-options}}
select $sql-columns
  from ofmucconversationlog as "log", ofmucroom as "room" 
  where room.name = '$roomname' and room.roomid = log.roomid
  and timestamp with time zone 'epoch' AT TIME ZONE 'CST' + CAST(substr(log.logtime,1,12) as bigint) * interval '1 seconds' >= current_date - interval '$interval weeks'

  order by log.logtime
{sql-query}
$panel
{run}

Hi, thanks, I will go on and try this out – its true: no communication without control on an external server – just for enterprice security reasons.

I am only aware of Spartez MeetingRoom, but I don't know if uses a 3rd party server or not...

https://plugins.atlassian.com/plugin/details/30610

Thanks, I did check it and it does use external services like AppFusion. I need the Chats to be stored within conluence like comments, to keep track of those discussions that influenced conclusions/decissions.

Mizan Community Champion Jan 26, 2012

Hi all ,

Is there any such plugin available for Jira ?

thanx :)

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,694 views 26 10
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you