RE: [Asterisk-Users] Dumping queue_log to MySQL
Im using the fifo approach.. working great so far! From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin SavoySent: Friday, May 05, 2006 8:57 AMTo: 'Asterisk Users Mailing List - Non-Commercial Discussion'Subject: [Asterisk-Users] Dumping queue_log to MySQL Anyone have a working solution for this? I played with the demo that came with QueueMetrics to see how they were doing it and it was working for a bit but now somehow every night it stopped. Perl and Tail are still running on the server but the information is not dumping to the MySQL database. I dont get any error messages anywhere telling me why it stops. As far as tail and perl are concerned everything is fine. We will be using this for a call center and need more reliability. Anyone got one working? Thanks _ Kevin Savoy Business Unit Telecom Analyst 2218 4th Ave W Williston, ND 58801 Ph: 701-774-4023 Fax: 701-774-2901 http://www.novo1.com Novo 1 is a service mark of Novo 1, Inc ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Dumping queue_log to MySQL
Hello Kevin, this is often a problem with MySQL disconnecting the client; we have an updated version of the uploader script and we have released it a few days ago - see http://queuemetrics.loway.it/download.jsp I know the website is not very good at showing news, so we aplogize for the inconvenience. We have a support service that will be happy to anser questions about problems or bugs for both the free and the commercial version of QueueMetrics. I am sorry for the inconvenience, l. On Fri, 05 May 2006 15:57:06 +0200, Kevin Savoy [EMAIL PROTECTED] wrote: Anyone have a working solution for this? I played with the demo that came with QueueMetrics to see how they were doing it and it was working for a bit but now somehow every night it stopped. Perl and Tail are still running on the server but the information is not dumping to the MySQL database. I don't get any error messages anywhere telling me why it stops. As far as tail and perl are concerned everything is fine. We will be using this for a call center and need more reliability. Anyone got one working? Thanks _ Kevin Savoy Business Unit Telecom Analyst 2218 4th Ave W Williston, ND 58801 Ph: 701-774-4023 Fax: 701-774-2901 http://www.novo1.com http://www.novo1.com Novo 1 is a service mark of Novo 1, Inc -- Loway Research - Home of QueueMetrics http://queuemetrics.loway.it ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Dumping queue_log to MySQL
We use a Perl script called acd_logger.pl. I can't remember when I got it from now but if you want a copy then mail me directly.RegardsJonJon FarmerTelford, Shropshire, UK- Original Message From: Kevin Savoy [EMAIL PROTECTED]To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.comSent: Friday, 5 May, 2006 2:57:06 PMSubject: [Asterisk-Users] Dumping queue_log to MySQL Anyone have a working solution for this? I played with the demo that came with QueueMetrics to see how they were doing it and it was working for a bit but now somehow every night it stopped. Perl and Tail are still running on the server but the information is not dumping to the MySQL database. I don’t get any error messages anywhere telling me why it stops. As far as tail and perl are concerned everything is fine. We will be using this for a call center and need more reliability. Anyone got one working?Thanks_Kevin Savoy Business Unit Telecom Analyst 2218 4th Ave W Williston, ND 58801 Ph: 701-774-4023 Fax: 701-774-2901 http://www.novo1.com Novo 1 is a service mark of Novo 1, Inc ___--Bandwidth and Colocation provided by Easynews.com --Asterisk-Users mailing listTo UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Dumping queue_log to MySQL
On 5/5/06, Jon Farmer [EMAIL PROTECTED] wrote: We use a Perl script called acd_logger.pl. I can't remember when I got it from now but if you want a copy then mail me directly.Regards Jon Jon FarmerTelford, Shropshire, UK - Original Message From: Kevin Savoy [EMAIL PROTECTED]To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Sent: Friday, 5 May, 2006 2:57:06 PMSubject: [Asterisk-Users] Dumping queue_log to MySQL Anyone have a working solution for this? I played with the demo that came with QueueMetrics to see how they were doing it and it was working for a bit but now somehow every night it stopped. Perl and Tail are still running on the server but the information is not dumping to the MySQL database. I don't get any error messages anywhere telling me why it stops. As far as tail and perl are concerned everything is fine. We will be using this for a call center and need more reliability. Anyone got one working? We've had a fair amount of success using the script attached with the following mysql schema. mysql desc queue_actions;+---+-+--+-+-+---+| Field | Type | Null | Key | Default | Extra |+---+-+--+-+-+---+ | queueid | int(11) | | MUL | 0 | || uniqueid | varchar(25) | | MUL | | || queuename | varchar(45) | | MUL | | || agentname | varchar(45) | | | | | | action | varchar(25) | | MUL | | || alt1 | varchar(10) | | | | || alt2 | varchar(10) | | | | || userfield | varchar(75) | | | | | | calltype | int(4) | YES | | NULL | || nodename | varchar(25) | YES | | NULL | |+---+-+--+-+-+---+10 rows in set (0.00 sec) -- Bird's The Word Technologies, Inc.http://www.btwtech.com/ insert-queue-info.pl Description: Binary data ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Dumping queue_log to MySQL
http://forums.digium.com/viewtopic.php?t=4073 I modified it some, but it integrates with my cms and provides realtime call stats. Contact me off list if youve like to see how it works. Wes Baehr Ability Business Computing, Ltd. Office: 330.882.0455 x25 Cell: 330.882.0455 x35 Fax: 330.882.0455 [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Savoy Sent: Friday, May 05, 2006 9:57 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: [Asterisk-Users] Dumping queue_log to MySQL Anyone have a working solution for this? I played with the demo that came with QueueMetrics to see how they were doing it and it was working for a bit but now somehow every night it stopped. Perl and Tail are still running on the server but the information is not dumping to the MySQL database. I dont get any error messages anywhere telling me why it stops. As far as tail and perl are concerned everything is fine. We will be using this for a call center and need more reliability. Anyone got one working? Thanks _ Kevin Savoy Business Unit Telecom Analyst 2218 4th Ave W Williston, ND 58801 Ph: 701-774-4023 Fax: 701-774-2901 http://www.novo1.com Novo 1 is a service mark of Novo 1, Inc -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006 ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Dumping queue_log to MySQL
Kevin Savoy wrote: Anyone have a working solution for this? I played with the demo that came with QueueMetrics to see how they were doing it and it was working for a bit but now somehow every night it stopped. Perl and Tail are still running on the server but the information is not dumping to the MySQL database. I don’t get any error messages anywhere telling me why it stops. As far as tail and perl are concerned everything is fine. We will be using this for a call center and need more reliability. Anyone got one working? Kevin, We are using QueueMetrics to provide reporting for our inbound call center activities. On a heavy day we're handling 13,000+ calls spread across roughly 6 to 10 queues. Due to some of the specifics or our setup, we are using a custom program to load queue_log data into MySQL. There may be a little tweaking involved to get things up and running (it's rare to find a product that is a *perfect* fit for your business), but once you're there I think you'd be happy with QueueMetrics. The developers are very responsive to feedback and our floor managers are extremely pleased with the reporting. Matthew Roth InterMedia Marketing Solutions Software Engineer and Systems Developer ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users