Free Wallboard for UCCX 465

Wallboard  noun
: a screen or web page designed to be shown on a tv/display mounted in a call center.  It provides real time stats that are easily view-able.

The Background

My company has never had a real wallboard – we’ve shown the built in UCCX real time statistics page on a projector in the past, but it’s always been a low rent affair.  So, as part of a new new system install, I was asked to integrate with the site’s wallboard.  It turns out that their wallboard was just a plasma TV displaying some queue and agent stats.  I think we can do this.
So, I began researching free wallboards that would work with my Unified Cisco Contact Center Express (UCCX) call center.  There are a number available, including a nice one from Tenox, as well as the Free of charge Wallboard 2.4.  I liked the Free of charge Wallboard, but it was broken for UCCX 8, and had a pretty dated look, so I decided to update this wallboard, making it compatible with UCCX 8 and up, as well as giving it a significant face-lift.

A new free UCCX wallboard is born

On to the good stuff, a description of this free to use Cisco call center wallboard. Let’s start with some of the screenshots of what the system looks like:

You can show multiple CSQs (customer service queues) on one screen

UCCX call center stats on a wallboard

the main CSQ pages shows each CSQ with quite a bit of detail.

Or you can focus on only one CSQ

By selecting the "OnlyOneQueue" option, you can focus on one CSQ

By selecting the “OnlyOneQueue” option, you can focus on one CSQ

You can also show summary CSQ data

UCCX ICD stats on a wallboard

An optional page that displays the totals for the entire call center

 

About the UCGuru.com Wallboard

This wallboard is free to use.  As mentioned before, I am not the original author, however I’ve done a number of updates and modifications to the script, and think it looks and works quite nicely.  Some key features:

  • It’s free!
  • All configuration data is stored in a single commented file – it’s easy to see what need to be changed.
  • Updated style – most styling (the look and size of elements) is stored in a css stylesheet.
  • Works with UCCX 8 – 10 – this is reason enough to use this script (in my book)

What is shown on the display:

  • Logged in Agents
  • Available Agents
  • Talking Agents
  • Calls in Queue
  • Calls Handled
  • Total Calls
  • Calls Abandoned
  • Current Wait Time
  • Longest Wait Time

What do the different colors mean (gray / yellow / red)

  • grey – if you have available agents then the row containing your queue will show as grey
  • yellow – If you currently have no available agents (no one logged in, everyone talking, etc) the row will turn yellow
  • red – calls are holding in the queue for an agent to become available.

 

Installation

The overall idea is that you will have a windows server that will connect via an odbc connection to your UCCX server.  To view the wallboard, a client pc or wallboard machine will simply view the windows server default website.

Here’s how I did it:

  1. Create a windows server (I used a virtual machine).  I found it easier to use the 32 bit version of windows, since UCCX will only use the 32 bit Informix drivers.
  2. Install IIS on the Windows server, and include ASP.  Once installed, go to the IP of your Windows server and make sure that you see the default IIS website.
  3. Download and and extract the UCGuru.com Wallboard (link at the bottom of this article).  Put these files in the default directory of your IIS install (usually C:\inetpub\wwwroot).
  4. On your UCCX server, you’ll need to know the uccxwallboard user password.  I had no idea, so needed to reset this.  Just go to Tools -> Password Mangement and change the password for the Wallboard User.   Do not use Special Characters like &!”$£, as it won’t work.  You’ll need to do this (and make the passwords match) on both servers if you have an HA cluster.   Note about wallboard users – Cisco specifically recommends  not using the uccxhruser, as it can cause high CPU utilization, so to stay on their good side, we’ll use the wallboard users and forego any agent data.password
  5. Also on your UCCX server, go to Tools > Real Time Snapshot Config and enable the “Data Writing Enable”, “ICD CSQs Summary”, “ICD System Summary”, and set the Data writing to whatever you like.real-time-snapshot
  6. Now you’ll need to download and install the IBM Informix database drivers.  You can find them here: ciscounitytools.com.  I used the 4.10 version.  Please note the extra hoops you’ll need to jump through to install this on Windows 64bit.  I installed all features except the OpenAdmin Toolinformix-install
  7. Now it’s time to configure the ODBC connection on your windows box.
    1. Launch the ODBC Datasource Administrator (Start -> Administrative Tools -> Data Sources (ODBC)
    2. Click the System DSN tab
    3. hit ADD
    4. Choose IBM Informix ODBC Driver
    5. Finish
    6. For Datasource name enter UCCX (you could pick anything you’d like)
    7. on the connection tab, enter the following
      1. Server Name – the name of your server with _uccx appended
        1. Convert all uppercase characters to lowercase characters
        2. Replace all hyphens with underscores
        3. If the host name starts with a number, add the prefix i
        4. Append _uccx to the server name
        5. For example, if your host name is 123-UCCX-1, your instance name will be i123_uccx_1_uccx
      2. Host Name – enter the DNS host name of your UCCX server (make sure the Windows server can ping this box – if not then you may need to add an entry in your hosts file for the name resolution).
      3. Service – 1504
      4. Protocol – onsoctop
      5. Database Name – db_cra
      6. User Id – uccxwallboard
      7. Password – the password from step 5dsn-connection
    8. Click the apply button
    9. On the Environment tab set the Client and Database locales to en_US.UTF8environment
    10. You should now be able to go back to the connection tab and hit “apply & test connection”, and have the test succeed.
  8. Finally, we’ll need to edit the parameters.cfg file that is currently in the wwwroot folder.

Configuring the parameters.cfg file

There are a ton of options in the parameters.cfg file, but luckily, there aren’t too many that have to be changed.  The file is well commented, so you should be able to figure it out.  Here are the highlights:

  • ServerURL = the url to your windows server that hosts your file.  include the full url with trailing /
  • DBsource = the IP address of your primary UCCX server
  • DBServer = the Server Name of your UCCX server from step 7.1 above
  • DBuserID and DBpass = the credentials for your wallboard user.
  • DSN = the name of your DSN connection from step 6 above
  • OnlyOneQueue = if you have only 1 CSQ then set this to 1.  this will cause the page to display taller, but will only show one CSQ

That should get you started.  You’ll notice that there is a good bit of coding in the script for agent data and stats.  It is not possible to use this to pull agent stats using the uccxwallboard user.  if you want to go against Cisco recommendations and use the uccxhruser, you can change the DisplayAgentsStatsTrue to 1, and pull information about agents.  I don’t do this on my production server.

Required files (you only need the latest version):

465 thoughts on “Free Wallboard for UCCX

  1. scratch May 3,2017 2:48 pm

    Hello, we have been using the wallboard without any problems for a while. We recently upgraded to UCCX 11.0 and it had still been working (or at least noone noticed that it wasn’t!) but now it seems to have lost connection to the database, and when I attempt to reconnect the ODBC connection I get the following error: [Informix][Informix ODBC Driver][Informix]Incorrect password or user uccxwallboard@tcv2013.ourdomain.com[TCV2013.ourdomain.com] is not known on the database server.

    TCV2013 is the name of the server it is running on, and it looks to me that this formatting is what is causing the problem. I have tried changing the wallboard user password multiple times with no luck, has anyone run into this problem?

    • scratch May 3,2017 3:11 pm

      Ok, I was able to get the first issue resolved, but now it does not show anyone as being logged into the queue. The only changes I have made are to the ODBC connection (I just recreated this) and the DBpass in the parameters.cfg file.

  2. Habbers Apr 26,2017 5:40 am

    First and foremost, thanks for developing the wallboard, so much better than trying to use CUIC.

    I have looked through the posts and can’t find an answer to my issue.

    The [Calls Dequeued] output does not reset to zero each morning.
    I have a queue that has the [Calls Dequeued] slowly counting up, day by day and is never reset.
    Is there a way to force this to reset when the rest of the values are reset by UCCX?

    Any help appreciated

  3. markv Mar 20,2017 3:38 pm

    Can you have multiple wallboards showing just that groups stats off the 1 server? If so, what is the secrete?

  4. uccxadmin Mar 16,2017 8:01 am

    Hello UCGuru,

    I have followed your instructions to set up wallboard on CCX 8.5.1SU4, but when i try to access the web url, from another machine, i get 500 Internal Server Error

    and when i try to access the IP on the windows server itself. i see a black screen ..

    can you please advise, how to resolve this issue ?

  5. kashif.faiyazi Mar 9,2017 5:36 am

    Hi Gurus,

    I am getting a black screen with the message “An error occurred on the server when processing the URL. Please contact the system administrator.
    If you are the system administrator please click here to find out more about this error.
    ” Please help me understand where did I go wrong. I am a new bee and just wanna configure something for my team.

  6. Dominique Graves Mar 2,2017 1:29 pm

    Hi UCGuru. First of all, thank you for the awesome Wallboard! You rock. I am doing some customization and I have a few of questions. I am by no means a web designer, so I’m stumbling through this. I’m surprised I got it running in the first place. (on a Win2012R2 server)

    1. Is there a way to change the CSQ_Container color for the ones that have an Alert status? For instance, when the “ArtNoAgentsAndCallsInQueue” turns red, is there a way to change the CSQ_Container red as well instead of the default CSQ_Container color?

    2. It seems when I set the Const DisplaySpecificCSQ to 1 to display specific CSQs, the maximum that shows up is 16. I have 29 CSQs I wish to display.

    3. Or even better than displaying 29 CSQs on one page… is there a way to display 6 CSQ’s per page and have the pages shuffle?

    • Dominique Graves Mar 3,2017 11:35 am

      I figured out the answer to my #2 question. I found the parameters in the default.asp and added additional lines for the amount of CSQs I have. 🙂 I’ll try to figure out the answers to my other questions but would love input.

      • Dominique Graves Mar 9,2017 6:11 pm

        I read through all of the comments and found KingRichards solution which is to this and it worked for me!

        “I just put them in a second folder/page. For example… IPAddress/Stats, and IPAddress/Stats2
        Then I use the Revolver Tabs (in Chrome), to switch between the two tabs.”

  7. DerKneissl Feb 16,2017 3:25 am

    Hi all,

    thanks for this great Wallboard, it really works well! The only problem I’m facing, on a big TV connected to a rasperry PI(using Chromium), it flash white as soon as the board is being refreshed. Has anyone seen this behaviour? It works fine on older PI’s with different Chromium version.
    Many thanks!

  8. jim Feb 3,2017 11:13 am

    Would it be possible to add this in the next version:
    If (Current Wait Time > Longest Wait Time) Then (Longest Wait Time = Current Wait Time)

  9. voip_n00b Jan 16,2017 11:42 am

    Recieving “0”‘s in all CSQ fields after upgrading UCCX to version 10. I am using version 1.4 of the wallboard. Any ideas?

    • Terry Mason Jan 16,2017 12:46 pm

      Did the IPs or hostnames change?
      Did the password to the wallboard user change?

      • voip_n00b Jan 16,2017 12:48 pm

        No to both. When checking on the changed password I attempted to change it in the GUI. The GUI tells me the password I attempt to change it to is the same as the old.

      • voip_n00b Jan 16,2017 12:58 pm

        Set ipcc version as 10 in the parameters folder and have the following options set as well:
        //Choosing which queues to show and setting up pretty names for them
        Const OnlyOneQueue = 0 //1 if you only have 1 queue – 0 if you want to display multiple. This will switch between a 9 colum row and a 3 x 3 table
        Const DisplaySpecificCSQ = 1 //0 to show all CSQs 1 to show specific queues (you will then have to put the name of each below). CSQs will be displayed in the order entered.
        Const usePrettyNamesIfDefined = 1 //if you enter something a pretty name for the queue – should we use it
        Const UCCXCSQ1 = “SupportCenter” //Name of your queue – i.e. My_Callcenter_CSQ
        Const UCCXCSQ1friendlyName = “Support Center” //friendly name for this queue (that will be displayed in the row title)
        Const UCCXCSQ2 = “”
        Const UCCXCSQ2friendlyName = “”
        Const UCCXCSQ3 = “”
        Const UCCXCSQ3friendlyName = “”
        Const UCCXCSQ4 = “”
        Const UCCXCSQ4friendlyName = “”
        Const UCCXCSQ5 = “”
        Const UCCXCSQ5friendlyName = “”
        Const UCCXCSQ6 = “”
        Const UCCXCSQ6friendlyName = “”
        Const UCCXCSQ7 = “”
        Const UCCXCSQ7friendlyName = “”
        Const UCCXCSQ8 = “”
        Const UCCXCSQ8friendlyName = “”
        Const UCCXCSQ9 = “”
        Const UCCXCSQ9friendlyName = “”
        Const UCCXCSQ10 = “”
        Const UCCXCSQ10friendlyName = “”
        Const UCCXCSQ11 = “”
        Const UCCXCSQ11friendlyName = “”
        Const UCCXCSQ12 = “”
        Const UCCXCSQ12friendlyName = “”
        Const UCCXCSQ13 = “”
        Const UCCXCSQ13friendlyName = “”
        Const UCCXCSQ14 = “”
        Const UCCXCSQ14friendlyName = “”
        Const UCCXCSQ15 = “”
        Const UCCXCSQ15friendlyName = “”

        //what to show on the page
        Const DisplayCSQStatsTrue = 1
        Const DisplayCSQloggedInAgents = 1
        Const DisplayCSQavailableAgents = 1
        Const DisplayCSQtalkingAgents = 1
        Const DisplayCSQcallsWaiting = 1
        Const DisplayCSQcallsHandled = 1
        Const DisplayCSQcallsDequeued = 1 //determines the calls dequeued by (callsDequeued = totalCalls – callsHandled – callsAbandoned)
        Const DisplayCSQtotalCalls = 1
        Const DisplayCSQcallsAbandoned = 1
        Const DisplayCSQlongestWaitCurrent = 1
        Const DisplayCSQlongestWaitDuration = 1
        Const DisplayOverallStatsTrue = 1
        Const DisplayICDTotalCSQs = 1
        Const DisplayICDStatsTrue = 0 //show the stats for all CSQs totaled
        Const DisplayICDloggedInAgents = 1
        Const DisplayICDavailableAgents = 1
        Const DisplayICDcallsWaiting = 1
        Const DisplayICDcallsHandled = 1
        Const DisplayICDtotalCalls = 1
        Const DisplayICDcallsAbandoned = 1
        Const DisplayICDlongestWaitCurrent = 1
        Const DisplayICDlongestWaitDuration = 1
        Const intAgentStatsMaxDays = 1
        Const intAgentStatsMaxHours = 8
        Const intAgentStatsMaxNotReady = 5
        Const intCSQStatsMinAgentsAvailable = 1
        Const intCSQStatsMaxQueuedCalls = 0
        Const TextColor_PageHeader = “Navy”
        Const TextColor_TableHeader_CSQStats = “Navy”
        Const TextColor_TableHeader_AgentStats = “Navy”
        Const TextColor_TableHeader_ICDStats = “Navy”
        Const TableColumnHeader_CSQStats_Column1 = “CSQ Name”
        Const TableColumnHeader_CSQStats_Column2 = “Logged In Agents”
        Const TableColumnHeader_CSQStats_Column3 = “Available Agents”
        Const TableColumnHeader_CSQStats_Column4 = “Talking Agents”
        Const TableColumnHeader_CSQStats_Column5 = “Calls In Queue”
        Const TableColumnHeader_CSQStats_Column6 = “Calls Handled”
        Const TableColumnHeader_CSQStats_Column7 = “Total Calls”
        Const TableColumnHeader_CSQStats_Column8 = “Calls Abandoned”
        Const TableColumnHeader_CSQStats_Column9 = “Current Wait Time”
        Const TableColumnHeader_CSQStats_Column10 = “Longest Wait Time”
        Const TableColumnHeader_CSQStats_Column11 = “Calls Dequeued”
        Const TableColumnHeader_ICDStats_Column1 = “Total CSQs”
        Const TableColumnHeader_ICDStats_Column2 = “Logged In Agents”
        Const TableColumnHeader_ICDStats_Column3 = “Available Agents”
        Const TableColumnHeader_ICDStats_Column4 = “Calls In Queue”
        Const TableColumnHeader_ICDStats_Column5 = “Calls Handled”
        Const TableColumnHeader_ICDStats_Column6 = “Total Calls”
        Const TableColumnHeader_ICDStats_Column7 = “Calls Abandoned”
        Const TableColumnHeader_ICDStats_Column8 = “Current Wait Time”
        Const TableColumnHeader_ICDStats_Column9 = “Longest Wait Time”
        Const TableColor_ICDStats = “White”
        Const TextColor_ICDStats = “Green”
        Const TableColor_CSQStats_StatusOkay = “White”
        Const TableColor_CSQStats_AlertNoAgents = “White”
        Const TableColor_CSQStats_AlertCallsInQueue = “White”
        Const TableColor_CSQStats_ArtNoAgentsAndCallsInQueue = “White”
        Const TextColor_CSQStats_StatusOkay = “#262626”
        Const TextColor_CSQStats_AlertNoAgents = “Orange”
        Const TextColor_CSQStats_AlertCallsInQueue = “Orange”
        Const TextColor_CSQStats_ArtNoAgentsAndCallsInQueue = “Red”
        Const TextSize_ICDStats = 5
        Const wallboardFooterCredit = 0

      • voip_n00b Jan 16,2017 4:22 pm

        FIXED. Had to disable and re-enable real time snapshot on UCCX on all servers in my cluster.

        Thanks.

  10. jthomasten13 Jan 10,2017 9:58 am

    Is there a way to add Reason Codes and time in the Reason Code? If so how?

  11. Tim Ames Dec 9,2016 4:31 pm

    Thanks for the information. I am trying to figure out why I am getting the black screen showing. If I highlight I find the words:

    An error occurred on the server when processing the URL. Please contact the system administrator.
    If you are the system administrator please click here to find out more about

    After playing with this for a while I installed the Tenox wallboard using the ODBC connector I made for this and it worked right away.

    I read thru the comments today and saw that I would need to allow 32bit applications in IIS7 on my 2008R2 server and I did that but still have the same issue.

    I have tried to change as little as possible so that I don’t accidently mess it up. I know I am close and that it is reading the file. Any help would be greatly appreciated.

  12. Eric Labelle Nov 29,2016 2:00 pm

    Our company just migrated to 11.5 version. Since the migration, i changed the uxxwallboard user password and i change the version in the parameter file to version 10. My IIS server connects to the UCCX server, but my wallboard keeps displaying “0” everywhere. Did anyone face the same situation?

  13. Chriss Nov 20,2016 8:16 pm

    I get the wallboard up and running for a few seconds until the page automatically refreshes; the URL changes and causes the page to return a HTTP 404.0-not found.

    Any ideas on what might be causing this and how to fix this?

    Thanks

    • Chriss Nov 20,2016 9:19 pm

      Nvm i got it working now (somehow) by adding a new website in IIS.

      My question now is whether it is possible to decrease the time delay between when a phone call is placed to when the call is actually displayed in queue. We calculated that it’s takes about 35 seconds to update.

      Is it possible to shorten this time? Thanks

      • Terry Mason Nov 21,2016 11:18 am

        Take a look at the install instructions above, specifically step 5.
        Then you’ll need to think about how often you refresh the wallboard page. The more often you refresh, the newer the data.

  14. JL Harris Nov 18,2016 12:10 pm

    The Wallboard is really GREAT! Thank you very much. Easy setup, config. I would like to run this on a web server for multiple departments to access their individual Call Stats as a wallboard. How would I configure so that each department only viewed their info? Separate folders in the wwwroot folder? Also, is there a way to display agent names and login status on a second page so that Page 1 displays CSQ info and Page 2 displays Agent State?

  15. Chase M Nov 7,2016 11:17 am

    Is there a way to change the offset for standard time on the Agent Statistics page? Currently the “Time in Status” is 1 hour behind…

    • mminelli Mar 13,2017 12:45 pm

      Having the same issue today after the time change. You ever fix this?

      • mminelli Mar 13,2017 1:32 pm

        We found the answer to this. Under the “Default” page, we had to edit this part of the code:

        ‘ calculate the difference between current date/time and date/time of the last event change,
        intStatusSeconds = DateDiff(“s”,(EventHappenedDateTime – .20833),CurrentDateTime)

        We changed the .20833 to .16666 and it was close enough for us. I am in Detroit MI and we jumped ahead one hour. I assume this has to do something with EPOCH time coming from the Unix database.

  16. jgranger125 Nov 2,2016 9:59 am

    I’ve got the wallboard installed on 2012 R2. I only see a black screen with the logo at top left and “UCGuru Wallboard v1.42” at top right. IIS logs look like this:

    2016-11-02 13:56:03 10.0.0.225 GET /default.asp Stats=CSQ 443 – 10.139.64.14 Mozilla/5.0+(Windows+NT+10.0;+WOW64;+rv:49.0)+Gecko/20100101+Firefox/49.0 – 200 0 0 62

    2016-11-02 13:56:18 10.0.0.225 GET /default.asp Stats=ICD 443 – 10.139.64.14 Mozilla/5.0+(Windows+NT+10.0;+WOW64;+rv:49.0)+Gecko/20100101+Firefox/49.0 – 200 0 0 62

    Any thoughts on what the issue may be? Thanks.

  17. shayandes Nov 1,2016 11:41 pm

    Hi,

    It’s a great solution. We have multiple queues used by different departments. I want to displace the wall board for a specific queue. So, I guess I need to make “Const OnlyOneQueue” to 1. Where do I specify the number of the queue I want to display?

    Regards,
    Shayan

  18. george Nov 1,2016 1:47 am

    Has anyone modified this to show the agent stats on a cisco phone? Any pointers would be appreciated.

  19. Eric Labelle Oct 13,2016 10:01 am

    Great wallboard, thanks to all for all your advises, experiences and instructions. Had it working in no time following all of your advises. I’ve even been able to work the .asp file to make some minor changes to the layout. Does anyone know if it’s possible to had the average waiting time variable in the wallboard (at least in the ICD section)?

  20. Greg Atkins Sep 13,2016 1:05 pm

    I can’t get this to work after following the guide. I keep getting a 404 file or directory not found (when going to http:///default.asp. I can access the default IIS page when just going to http://localhost. Is the UCGuru folder supposed to be at the root directory of the wwwroot folder?

  21. james.kell.58 Sep 7,2016 8:57 pm

    Just a tip for anyone who experiences the same issue as me …

    The wallboard would stop at random intervals with the “500 – Internal server error”. It only required a refresh to continue but it would re-occur some time later. The IIS logs showed |442|80020009| at the time of failure.

    There is code in the CSQ module that references the SQL result set without first checking for EOF:

    If displayPageHeader = 1 Then
    Response.Write “”
    Response.Write “stats began at ” & objRS(“startdatetime”) & ” EST”
    Response.Write “”

    I’m not sure why but it appears that the SQL request would sometimes return null and the code would fail at this point. I added “And Not objRS.EOF” in the IF statement and the failure has stopped occurring.

    The new IF statement is:

    If displayPageHeader = 1 And Not objRS.EOF Then

    Or you can just turn off the displayPageHeader in parameters.cfg which will stop this part of the code from executing.

    Good luck.

  22. derek andrew Sep 6,2016 3:39 pm

    It is working here on UCCX 11.0(1).

    • Leonardo Saavedra Sep 14,2016 5:54 pm

      HI!… do you set the v10 on the parameters.cfg?

    • derek andrew Oct 11,2016 5:24 pm

      Ran into a weird problem. We were running UCCX 11.0(1) but we were on the 100 agent OVA. We got some licences so over the weekend, I took a backup, deployed the 400 agent OVA, and restored. Nothing else changed, still 11.0(1).

      Now, the wallboard stopped working with a “500 – Internal server error”.

      I brought up the old 100 agent OVA, and there was total success. The wallboard worked. I brought up the the 400 agent OVA and it fails with the 500 error!

      I have narrowed it down thus:

      When building the DSN, at the press apply and test step, running the 100 agent it says “Test connection was successful“.

      At the same point, running the 400 agent it says “Test connection was not successful. [Informix][Informix ODBC Driver][Informix]Incorrect password or user uccxwallboard@machine.domain.ca is not known on the database server.” (where machine is the name of the pc running the UCGuru wallboard.)

      I am baffled and befuddled. The 400 agent version was restored from the backups of the 100 agent.

      Oh, and I did check the uccxwallboard password. I set it to the same value it had had and received a message that it was already that value.

      • derek andrew Oct 13,2016 1:19 pm

        Problem solved. There was a Cisco bug, CSCul06940. For some unknown reason, the uccxwallboard password gets changed, and you cannot change it on the Tools>Password Management web page.

        This wallboard does work on 11.0(1).

  23. Joey Gore Aug 31,2016 10:42 am

    Thanks for this awesome Wallboard! We have been using it for close to a year now. One thing that has been asked, is if we can display an active list of agents that are configured for a particular skill/queue. We do skill based allocation and we have a CSQ that matches the Skill that the agent needs to answer calls in that CSQ. Can we update the ASP and/or Parameters.cfg file to pull Current Agents with a particular skill? Our supervisors are constantly moving agents around in different skills/queues and we was looking to see if there is faster way to have it displayed other than going through UCCX administration. Thanks

    Joey

  24. Charlie Taylor Aug 9,2016 1:15 pm

    This should be an easy one for you guru’s after reading all 4 pages of thoughts looking….

    Have all installed all S/W and dBconnection passes, IIS works but get the black screen that has the ‘server processing URL error / click here more info’ issue that was mentioned a few times here. A couple of solutions has a 32bit fall back fix which I can’t do. The page comes up with ‘My Company Wallboard’ tab so we know its close.

    Any suggestions:
    UCCX – 10.6
    IIS Server – Win7/64

    Do I need anything else in the ServerURL line?

    <%
    //DB and URL settings
    Const IPCCversion = "10"
    Const ServerURL = "http://10.150.51.90/&quot;
    Const DBsource = "10.150.51.230"
    Const DBServer = "houesccx01_uccx"
    Const DBdatabase = "db_cra"
    Const DBuserID = "uccxwallboard"
    Const DBpass = "12345"
    Const DSN = "UCCX"

    Thanks for any help

  25. wiscodisco Jul 28,2016 7:32 am

    So I have a stupid question.

    Where do I find the team ID’s? I can find the name just on the web interface but I have no idea where to look for the number associated with that.

    Other then that everything is working great.

    Thanks

    • James White Sep 26,2016 2:38 pm

      So what you have to do is change the uccxwallboard username to uccxhruser in the ODBC connection and the parameters.cfg.

      Ensure that you know the uccxhruser password, if not reset it in UCCX. This password only affects external wallboards. DO NOT USE SPECIAL CHARACTERS! Then, for the UCCXTeamID will be a number. I have four teams total, the default, and three others. My last team-id is 6. That you may need to play with as it seems the team-id increments by 2 in between the teams.

      I hope this is helpful!

    • BJ Beej (The Wizardzface of Oz) Mar 28,2017 10:16 pm

      The below command will give you what you need.
      run uccx sql db_cra select teamid,teamname from team

      Example output
      TEAMID TEAMNAME
      —————
      1 Default
      10 TEAM-BLAH
      11 TEAM-ALPHA
      12 TEAM-WHISKEY
      13 TEAM-DELTA
      14 TEAM-ECHO
      15 TEAM-TEST

  26. DrPopcorn Jul 5,2016 5:33 pm

    Just got this up and running, thank you very much for developing this.

    We’re trying to change the time when our stats ‘reset’ on the wallboard. Currently it is resetting at 00:01; we would like to be able to set stats to reset at 05:30. Is there an easy way to do this?

    • Terry Mason Jul 5,2016 7:11 pm

      The wallboard pulls from a wallboard database on your UCCX server. The reset of the stats happen on the UCCX server – I don’t think there is any way to control when it resets though.

Leave a Reply