Sounds like you're already on top of things from a data collection standpoint. Reporting on that data is going to be a hassle no matter what you do. Clients will never be pleased with the reports you give them unless they have a chance tweak and customized those reports to their own liking. Have you spoken to the client about what they expect? Hopefully you can translate what they want into various SQL queries...<br>
<br>-MC<br><br><div class="gmail_quote">On Mon, Oct 22, 2012 at 9:41 AM, Vbvbrj <span dir="ltr"><<a href="mailto:vbvbrj@gmail.com" target="_blank">vbvbrj@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="im">On 22.10.2012 19:37, Michael Collins wrote:<br>
> Are you using mod_callcenter or mod_fifo for inbound calls? (Just<br>
> curious.) I'd recommend starting with mod_cdr_xml since that will always<br>
> give you the most data.<br>
> -MC<br>
><br>
> On Mon, Oct 22, 2012 at 9:02 AM, Jason Holden <<a href="mailto:jason.holden@start.ca">jason.holden@start.ca</a><br>
</div><div class="im">> <mailto:<a href="mailto:jason.holden@start.ca">jason.holden@start.ca</a>>> wrote:<br>
><br>
> Can anyone provide advice on being able to provide a client with a<br>
> call centre statistics report?____<br>
<br>
</div>I am planning to implement statistic for local mod_callcenter. I will<br>
use a DB MySQL, because I'm used with it. I will implement collecting<br>
data to the DB using agent connect and disconnect calls, and clients<br>
call and events on disconnect. The data will then be displayed using web<br>
server and php script. For now I'm stuck with compiling MySQL in Debian x64.<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
Mimiko desu.<br>
</font></span><div class="HOEnZb"><div class="h5"><br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Michael S Collins<br>Twitter: @mercutioviz<br><a href="http://www.FreeSWITCH.org" target="_blank">http://www.FreeSWITCH.org</a><br><a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a><br>
<a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a><br><br><br>