Hi Bilal,<div><br></div><div>Probably there is no open source tool or a good ones available. But few of them I worked with provide up to 2 users free of cost license type of reporting. Reporting for Call Centers can get very complicated. Once you explore some of the commercial apps you will notice how extensive they can get. This is specially true if you are replacing an existing commercial system as you client won't want a mickey mouse replacement but rather a full-fledged call center application. To set down and code for it, it will probably take months to match anything commercially available. I suggest you explore your options before coding it or even attempting queue logs into SQL as that is just he beginning of the work and presentation, ***real-time***, graphs, administration portal, and tons more things are needed to make it a complete suite. Not to forget that this will require continuous updates at the pace of Digium changing Asterisk versions (most of the time as dial-plans changes or queue-log events changes, or if AMI events change).</div>
<div><br></div><div>Of course it's possible like other posts suggested but is it economical to embark on it for a single small project? I am not sure....</div><div><br></div><div>Just a thought.</div><div><br></div><div>
-Bruce<br><br><div class="gmail_quote">On Mon, Apr 18, 2011 at 9:23 AM, Sherwood McGowan <span dir="ltr"><<a href="mailto:sherwood.mcgowan@gmail.com">sherwood.mcgowan@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="gmail_quote"><div class="im">On Mon, Apr 18, 2011 at 8:18 AM, A J Stiles <span dir="ltr"><<a href="mailto:asterisk_list@earthshod.co.uk" target="_blank">asterisk_list@earthshod.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
If all the details you need to compile your reports can be found in existing<br>
databases (Asterisk's CDR database stores the details of calls; you may need<br>
to get user login/out events from a separate database), </blockquote></div><div><br>Logging the queue_log to MySQL and then setting up a trigger that inserts/updates data to other tables (such as something like agent_status and call_status), along with the CDR, will allow the OP to get pretty much everything they want. <br>
<br>(<i>OP, if you need something substantially more than the stats I mentioned in my earlier post, definitely feel free to email me with details. That way, not only can I help <u>you</u>, but I can make the open source statistics solution I'm working on even better)</i><br>
</div><div class="im"><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
A hint: Do the whole thing -- or as much of it as it takes to prove to<br>
yourself that you're on the right track -- "by hand" first, entering all the<br>
queries yourself in the mysql prompt (or phpmyadmin), *before* you try to<br>
write a program to do it. You will save yourself much heartache that way.<br>
<font color="#888888"><br></font></blockquote></div><div><br>AJ, truer words have not been oft spoken! I'd also add that creating views helps if you have complex queries (just to shorten the query that has to be issued from the end program that gets written).<br>
</div></div><br>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>