nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Any internal LiveChat abilities for confluence available?

Klaus Feldmann

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?

Accepted answers

Bob Swift

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}

All comments

NielsJ

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

Andrew Frayling

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)

Klaus Feldmann

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.

Klaus Feldmann

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.

Andrew Frayling

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.

Bob Swift

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}

Bob Swift

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}

Klaus Feldmann

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

Mizan

Hi all ,

Is there any such plugin available for Jira ?

thanx

Janusz Gorycki_zbokco

Hi @Mizan,

Janusz from Spartez here.

Sorry for a bit of commercial break, but we have recently released the Chat for Service Desk (server) app - aptly named 'Chat for Service Desk'. It provides a real-time chatting solution ("live chat") that helps your site visitors / app users connect with teams working through Jira Service Desk.

It is NOT an integration with a 3rd party chatting service - it is self-contained - you just install the app in Service Desk, place a bit of javascript on your web site (or just enable the chat on your customer portal) and you have full chat support.

It has a bunch of nifty features:

Creates issues out of chat conversations on-the-fly
Turns customer’s messages into issue comments - updating issue views in real time
Turns your issue comments into messages within the chat
Handles request queues updates
Lets you see which customers are currently online
Allows support personnel to toggle their availability
Chat widget is replaced with email when all agents are offline
Sends the customer chat digests through email
Fully optimized for mobile web pages
Chat look & feel is customisable

Interested? You may want to try it out - it’s just available on the Atlassian Marketplace.

An introduction video can also be viewed here.

Cheers,
Janusz Gorycki, spartez.com

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

chat