Agent Performance Detail report posible error
Hello Everyone,
Using GoAdmin 3.0-1377576000 here.
I've found a posible error in the export csv function in the "agent performance detail" report. It shows in the report ( web ) view, the right amount of pause hours, but when you download the csv file, the data looks different. At first, i thought that was a excel date conversion error, but parsing the csv with a text editor shows the same data. The database also has the same data as the website view ( i've executed the query against the database and did the calculation in excel ).
I've read the code for the export function and uses the same variables for output...weird. i'm attaching some prints.
Saludos / Regards,
Alvaro
Replies (2)
RE: Agent Performance Detail report posible error
-
Added by Levy Ryan Nolasco about 10 years ago
Hi,
Thank you for submitting your feedback. We will look into this and will update you soon. May we also know if you have pause codes.
Regards,
Ryan
RE: Agent Performance Detail report posible error
-
Added by Alvaro Avello about 10 years ago
Hi Ryan. Yes, we have 3 pause codes for each campaign.
Another question: The campaign filter is working in this report? in the version i'm using if you choose different campaigns always show the same data ( a detail view from all campaigns ). if you read the code, i've find that the variable $ul ( which i assume is the campaign id ) exists, but is not used by the query:
"SELECT user,SUM AS pause_sec,sub_status FROM vicidial_agent_log WHERE date_format(event_time, '%Y-%m-%d') BETWEEN '$fromDate' AND '$toDate' AND pause_sec > 0 AND pause_sec < 65000 $ul GROUP BY user,sub_status ORDER BY user,sub_status DESC LIMIT 10000000"
Saludos / Regards,
Alvaro