Following up on version 2.2 of the free of charge wallboard here is some exiting news for IPCCX 4.0 users.
As some reported version 2.2 did not work with IPCCX 4.0 version. This is now fixed (with the help of Robby, thanks Robby)
Attached you will find version 2.3 which contains a fix for IPCCX 4.0 users. This new version has been tested succesfully with IPCCX 4.0(5)
Enjoy the new version :-)
Short reply from me, in case you want to show appreciation by rating the thread (board does not allow to rate the post itself, only replies)
Thanks so much for your extra work on this :) You both get my vote and 5 points!
We were going to give your app a shot but the install guide doesn't quite match our screens here with 4.5 SR2. Do you happen to have an updated install guide? Or heard anything about compatibility with 4.5 sr2?
The script was initially developed for 3.x version, tested succesfully with 4.0 version, but never tested with 4.5
I do not have a 4.5 test environment (actually, I no longer have any test environment as I am currently unemployed)
I looked into the database schemas today and found there are no differences between the used table, so 4.5 versions should be no issue, as long as the authentication method does not differ from 4.0
If any of you using 4.5 could test and let me know (feel free to contact my private mail at email@example.com if you like to work with me on testing for 4.5) that would be great :-))
Must be missing something. The page keeps telling me that I am not authorized to view the page.
Loving the display. We can finally see from across the room! Your work is excellent.
1. The page currently cycles between the agent states page and Queue stats page according to the refresh rate in the config file. Is there any way to keep it from doing that? So that it's possible to bring both pages up static (but still refreshing according to the refresh rate).
2. I'm interested in a trigger/monitor that will play a sound file/alert sound (say every 20 seconds or so) if any calls show up in queue. Has anyone done any work in that direction with this script?
Your first wish should be possible with the current version (allthough I never actually tested it), but it will require two computers running this script. The 1st one would have to be configured with the parameter "Const DisplayAgentsStatsTrue = 1" and "Const DisplayCSQStatsTrue = 0" forcing it to only display Agent statistics. The 2nd one would have to be configured with "Const DisplayAgentsStatsTrue = 0" and "Const DisplayCSQStatsTrue = 1" forcing it to only display the CSQ statistics. The overall statistics ae not yet implemented.
The second item is not yet in there, but since I like the option, I will consider it to be in the next version.
-- remember to rate helpful posts
the wallboard is really great!I just voted 5 points for you! Is there already a newer version than 2.3a?
I'm also interested in a trigger/monitor that will play a sound file/alert sound (say every 20 seconds or so) if any calls show up in queue. Has anyone done any work in that direction with this script?
I tried your solution. I could make the CSQ Stats working. But when come to Agent States, it shows the following error message:
Microsoft OLE DB Provider for SQL Server error '80040e09'
SELECT permission denied on object 'Resource', database 'db_cra', owner 'dbo'.
Even when I make Const DisplayAgentsStatsTrue = 0, it still try to circulate this Agent Stats and stop there because of error.
Any idea where went wrong?
PS: I voted your post for 5 points. It is exactly what I need.
I'm seeing much the same thing in terms of stopping the cycleing between pages. I can make it only display csqstats by setting agentsstats=0 but it seems to be ignoring the value in csqstats.
We ran into your error when installing as well. You may have missed putting a check in the Database Role Properties box next to "Resource" on the list of objects. We missed it the first time. I think we thought it was part of the name of the previous table on the directions or something.
I noticed the error in displaying/cycling, which only seem to work when both agent stats and CSQ stats are enabled. I am working hard to get this fixed asap and will post an update soon.
Thanks for posting the feedback :-)
I would like to add Calls presented and calls handled to the pages. Do you know in what table in DB i can found these parameters?
This would have to be in one of the connectionstate tables, where one of the field will probably refer to the agent-ID.
I did not check, but that would be where I would look first.
I highly recommend to not link/join those tables as it will significantly decrease your system performance due to a much more complex SQL query.
Besides that, this is info that is in historical reports, and this is where you typically need it, very unusefull as real statistic.
I found the problem. It was the account I use for anonymous authentication. In CRS server, there is an account called CiscoWbUsr. I used that account for authentication. In event viewer, each time when I try to access wallboard.asp link, I get an entry that this account has not been granted the requested logon type at this computer.
I tried administrator account and it worked well. Also cycling between pages works fine.
Only thing I may need next is to customizing the display. This may need the un-encrypted .asp file because the parameter does not provide enough flexibility.
Bradley and Wengian,
The current release (2.3a) is succesfully tested with 4.0 and 4.5. If you have authentication problems with the CiscoWbUsr you probably did not follow the installation guide to the T.
Please check if you have release 2.3 (first line of ASP script), check all installation steps and read all notes. If you fail to fix the error, let me know (my mail address: firstname.lastname@example.org) and I?ll see what I can do to help you.
Hi, any way i can get these attachments from you? They dont show up for me to download on the forum any more?
Could you pls post the steps to give proper right to the user to view wallboard. When I try to access the webpage it gives unauthorized access. Cut and paste would be great.
Thanks in advance,
So, is there any chance of using this with a non-premium version of IPCC Express? I'd really like to use a wallboard, but our version of IPCC Express 4.0 doesn't include database, URL, or email options. Any ideas?
This should work with all versions, since there is no CRA script involved, you don't have to worry about what license you have.
The database and webserver are always there.
Thanks for your work on this. I've got another question. I've gotten the Wallboard 2.3a version working great. But, I backed up the files in that web directory, deleted them and placed the files for "flashboard 2.0" in there. I've configured them with the exact same account, password and server IP. This one fails with the message below. Is there a difference in how these 2 .asp files access the SQL server?
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/wallboard/wallboard.asp, line 27
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.1)
Dear fellow forum members,
I am getting emails on installation problems on 4.x IPCCX versions quite regularly, while I know some of you have managed to get it to work (those following this development know I am not able to test 4.x version).
In case you managed to get it to work, could you please email me details on:
- what you had to do to get it to work?
- what needs to be added/changed in the install doc?
- what is missing in documentation?
Please send this to me private email (email@example.com) and I will ensure the next version will have beter documentation for 4.x versions.
Your help will be greatly appriciated by other forum members :-)
Thanks in advance,
Can IPCCX 4.0(5) with Enhancement Edition support it? It is because when I click "Subsystems" in pull-down menu, I can't find "Database" item.