Agent data missing from Agent Performance Detail Report

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Agent data missing from Agent Performance Detail Report

Postby inthegenes » Wed Oct 16, 2013 1:07 pm

VERSION: 2.8-408a BUILD: 130711-2208
Asterisk version: 1.4.39.2-vici
VICIdial support installation

Having an issue where an agent's data is missing from the aforementioned report. The data for the agent's calls are shown in the user stats for the selected date(s). But there isn't any data in the Agent Performance Detail report.

What would cause this agent's data to be missing from the report?

http://img708.imageshack.us/img708/2702/zse4.jpg
* I couldn't get the image imbedded for some reason
inthegenes
 
Posts: 94
Joined: Wed Jun 17, 2009 1:28 pm
Location: Kingston, Jamaica

Re: Agent data missing from Agent Performance Detail Report

Postby DomeDan » Thu Oct 17, 2013 3:23 am

There was a similar problem here on the forum a while ago, the reason for that was mixing of upper and lower case letters in user_id
check log tables and vicidial_users in the database and find out if that is the issue with dsterling
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden

Re: Agent data missing from Agent Performance Detail Report

Postby inthegenes » Thu Oct 17, 2013 11:52 am

Thanks for the response DomeDan,

I checked a number of the log tables and the vicidial_users table and the user ID is fine 'dsterling.'
inthegenes
 
Posts: 94
Joined: Wed Jun 17, 2009 1:28 pm
Location: Kingston, Jamaica

Re: Agent data missing from Agent Performance Detail Report

Postby DomeDan » Fri Oct 18, 2013 7:55 am

Then add &DB=1 to the url, that will print the sql querys,
you need to debug with those querys, run them manually and find out why dsterling data aint showing,
or you can post the queries here and also the data from the tables
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 73 guests