Page 1 of 1

Problem with new agent_performance_detail?

PostPosted: Wed Feb 13, 2008 1:47 pm
by chrisbIT
Hi all,

We have just run our first day of real testing with 2.04 base and notice a discrepency in the reports. The AST_VDADstats.php script reports the correct number of sales (39), but the agent_performance_detail one reports less (31). I realise they both look at different tables (vicidial_log and vicidial_agent_log) but the two tables contain the same number of sales (39 and 39), so is this a problem with the way the agent performace detail counts the sales?

This is on standard adapt_hard dialling (not manual), has anyone else experienced this?

Many Thanks.

Chris

PostPosted: Wed Feb 13, 2008 3:01 pm
by mflorell
Can you post a dump of the records for sales from both tables?

There are several fixes to the vicidial logging that have been made in SVN that will be included in the next release and I was not aware of one like this so I would like some more information.

PostPosted: Thu Feb 14, 2008 4:26 am
by chrisbIT
Hi Matt,

I sent the logs via PM as to not publically disclose peoples names.

Thanks for looking in to this.

Chris

Problem found

PostPosted: Thu Feb 14, 2008 5:34 am
by chrisbIT
Hi matt,

I put the query manually in to phpmyadmin and noticed that the results displayed show exactly one sale less than expected for each caller.

commenting out this line in the code seems to fix it:
Code: Select all
$row[0] = ($row[0] - 1);      # subtract 1 for login/logout event compensation


Is it required?

Thanks

Chris

PostPosted: Thu Feb 14, 2008 5:41 am
by chrisbIT
hmmm, but then it seems that number of calls is incorrectly calculated. uncommenting that line i notice that number of calls varies both ways (between a p d and vdadstats)...hmmm