Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Silver

Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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 :-)

Leo

61 REPLIES
Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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)

Leo

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Happy to help, Leo... Enjoy everyone! Remember to rate posts that are helpful. : )

Hall of Fame Super Red

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi Leo/Robby,

Thanks so much for your extra work on this :) You both get my vote and 5 points!

Thanks again,

Rob

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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?

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi Bradley,

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)

HTH,

Leo

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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 l.mourits@caiway.nl if you like to work with me on testing for 4.5) that would be great :-))

Leo

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Updated version, one character (in the copyright line) generated an error, this is now fixed.

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Must be missing something. The page keeps telling me that I am not authorized to view the page.

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Nevermind, RTFM. It's working! Version 4.5(2)IPCCE Now to play a bit.

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Loving the display. We can finally see from across the room! Your work is excellent.

Questions:

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?

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi,

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.

Thanks,

Leo

-- remember to rate helpful posts

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi Leo

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?

Best Regards

Peter

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

;-)

Good to know that 4.5 is also supported. Thanks for the feedback.

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi Leo,

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?

Thanks.

PS: I voted your post for 5 points. It is exactly what I need.

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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.

Wengianyu:

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.

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

All,

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 :-)

HTH,

Leo

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi

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?

Best Regards,

MC

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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.

HTH,

Leo

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Bradley,

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.

Thanks

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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: l.mourits@caiway.nl) and I?ll see what I can do to help you.

HTH,

Leo

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi, any way i can get these attachments from you? They dont show up for me to download on the forum any more?

thanks

wally black

Silver
Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Hi

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,

Shahid

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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?

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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.

HTH,

Leo

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Leo,

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?

Error Type:

Microsoft OLE DB Provider for SQL Server (0x80004005)

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/wallboard/wallboard.asp, line 27

Browser Type:

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)

Page:

GET /wallboard/wallboard.asp

Thanks, Mikey

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

Flashboard 2.0 ?

Uhm, I never build that, so I wouldn't know how that one works.

HTH,

Leo

Silver

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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 (l.mourits@caiway.nl) 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,

Leo

Community Member

Re: Free of charge Wallboard 2.3 (contains fix for IPCCX 4.0)

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.

Mike

705
Views
128
Helpful
61
Replies
CreatePlease to create content