Who want to work in a report suite for vicidial?

[ageraldo]

Vicidial is a great tool, i am working in call center since 1999 and i have seen some dialer, and i am sure that vicidial in a short time will be install in a big number of call center around the world.

I have my own company www.aiatek.com.do in dominican republic, we have install asterisk in about 20 little call centers (6-20 agents), we started just testing and now we have a little company.

Well the point is that in my opinion something that Vicidial needs to improve is the report, and it is something that we can do, it is not so hard like coding functions but can sent vicidial to a next level.

I would like to read your opinion.

[okli]

What kind of reports do you have in mind?

[Op3r]

yep,

almost all of us here created some advanced reports.

all you needed actually was to look at the mysql database.

If you have some reports that want to contribute here that will be perfect.


Also to give you a lot of ideas on how to create reports on vicididial take a look at the report link on the vicidial web admin.


Lastly the Manager's manual is a great help in understanding how it is on VICIDIAL. you can get it from here www.eflo.net/store.php

[mflorell]

There are a lot of companies out there that have created additional reports for ViciDial. Unfortunately very few of those companies have donated those reports to the project.

[ageraldo]

Well this is my idea, i am the it manager of a call center beside of my own company.

In the call center where i work we have touchstar (touchstar is a dialer) and i will get the document of a tool that they call tsreport, where is a complete description of the suit of reports that they have.

Then we could start to work from that point, we could define a design (font,color,object,etc), make a repository and all that.

What do you think?

Sorry by my english

[mflorell]

We do not go out purposely replicating proprietary company's reports. This opens the project up for IP litigation.

Instead, we try to provide users what they need in a more unique way using reports that are not just clones of some other piece of software.

[ageraldo]

I do not try that we copy reports of another software, but we see a listing of the reports of the industry and see if it is possible to develop them for vicidial.

Take it look to this list:

Agent Call Detail
Agent Goals History
Agent Goals Report Per Campaign
Agent List
Agent Performance Summary
Agent Session Detail
Agent Session Summary
Agent Summary by Campaign
Agent Session Summary by Team
CRC by Agent
Team Session Summary
Agent Skills Report
Call Log
Campaign Call Frequency
Campaign List
Campaign Performance Outbound
Campaign Performance Summary
Campaign Summary
Campaign Summary All
Campaign Summary by the Hour
Contact Revenue Summary
CRC by Campaign
CRC by Campaign Summary
Dialer Utilization by the Hour
Dropped Call Detail
Dropped Call Summary
Campaign Call Type Summary
Campaign Status Summary
Campaign Performance Inbound
Scheduled CallBack Report
CRC Summary By The Hour
Status Summary By The Hour
Inbound Abandoned Detailed
Inbound Abandoned Summary
Inbound Daily Report by Hour
Inbound Daily Report by Campaign
Delayed Call Spectrum Detail
Delayed Call Spectrum Summary
Gate Traffic Detail
Gate Traffic Summary
Lost Call Spectrum Detail
Lost Call Spectrum Summary
CRC List
IVR List
Phone Number Lookup
Time Zone Penetration
DNIS Routing
Campaign Penetration (Create Date)
Campaign Penetration (Last Called)
Campaign Penetration (Total)
Penetration By Lead Source

[ageraldo]

report description
Agent Call Detail Lists each call individual agents took during the course of the specified date range.
Agent Goals History Gives a list of the Campaign Goals and the agent specific goals for each agent.
Agent Goals Report Per Campaign Shows the Campaign specific goals along with the agent specific goals for each agent.
Agent List Lists all of the agents on the system.
Agent Performance Summary Summary of the Agents call statistics.
Agent Session Detail A detail report of the calls each agent had.
Agent Session Summary Summary of the Agents Session
Agent Summary by Campaign Summary of the agents session grouped by the campaign and then by the agent.
Agent Session Summary by Team Summary report for the agents session.
CRC by Agent Lists the counts of CRCs for the agent
Team Session Summary Summary report based on the Primary Team listed for the Agents Sessions.
Agent Skills Report List agent skills.
Call Log Detail list of the calls made.
Campaign Call Frequency
Campaign List Lists all of the Campaigns on the dialer.
Campaign Performance Outbound
Campaign Performance Summary
Campaign Summary Summary report based off of the campaigns.
Campaign Summary All Lists the counts of the types of Calls based on the result of the Call.
Campaign Summary by the Hour Summary report based off of the campaign and broken down by hour.
Contact Revenue Summary Summary of revenue report based on the number of contacts made by the dialer.
CRC by Campaign Lists counts for CRCs by Campaign
CRC by Campaign Summary
Dialer Utilization by the Hour Production report for the dialer broken down by hour.
Dropped Call Detail Detail of all the dropped calls
Dropped Call Summary Summary of the Dropped calls.
Campaign Call Type Summary
Campaign Status Summary
Campaign Performance Inbound
Scheduled CallBack Report List records that are to be called back
CRC Summary By The Hour Lists no of calls per crc and campaign by the hour
Status Summary By The Hour Lists no of calls per status and campaign by the hour
Inbound Abandoned Detailed
Inbound Abandoned Summary
Inbound Daily Report by Hour
Inbound Daily Report by Campaign
Delayed Call Spectrum Detail
Delayed Call Spectrum Summary
Gate Traffic Detail
Gate Traffic Summary
Lost Call Spectrum Detail
Lost Call Spectrum Summary
CRC List Lists the CRCs that are on the dialer.
IVR List
Phone Number Lookup Lookup by a specific phone number. Reports the following criteria: Campaign name , call date , call time , crc, agent name, dial id and source id
Time Zone Penetration Displays the records eligible to be called based on their timezone.
DNIS Routing
Campaign Penetration (Create Date)
Campaign Penetration (Last Called)
Campaign Penetration (Total)
Penetration By Lead Source Show records penetrated per campaign.

[mflorell]

quite a few of these are missing descriptions.

A few of these exist either as current reports or as portions of current reports.

[Op3r]

but all in all

This are quite easy to generate (if I know php which of course I dont)

But yes as matt said some of this reports are already built in.

Hey matt why dont we just make the report page as a module not the part of the campaign web admin?

[ageraldo]

Then do you think that we dont need to work on this?

it is only a question, because if you think that is ok then we dont really need to work on it.

[Op3r]

Its ok to put more work on this.

As per experience, the only difference now between vicidial and the closed sourced dialer now is the reports.

In terms of stability, I will still go with vicidial. Pricing? vicidial wins. Higher fetch time? vicidial. AMD detection and tone detection? couple it with sangoma CPA you can compare it now with some pricy dialers out there.

We just need reports.

[ageraldo]

Yes it is what i say, then why not work on this and reports is the easier part of programing.

Other thing is the recording lookup, i create this little program

http://www.aiatek.com.do/recordinglookup.JPG

and it is something that could be include in vicidial and it is very usefull

[mflorell]

Yes we could certainly separate the reports links page from admin.php, it doesn't have to be in there.

I think we do need more reports, but we have to have descriptions of the available reports before we build them so people will know what they are looking at.

As for the recording lookup report, that looks nice, are you considering donating it to the project?

[ageraldo]

Yes i would like to donate it, just tell me what is the protocol to do it, and in relation to the listing of present reports of vicidial, who could give that information to us?

[brett05]

mr ageraldo can you share your recording lookup
thanks

[ageraldo]

Yes i can, but i would like everyone have it.

if you want it, just let me know

give me your email and i can sent it to you

[ageraldo]

You can go to www.aiatek.com.do/reports.rar

Download the file
uncompressed into /var/www/html/
then goto http://your_vicidial_ip/reports/recordinglookup.php

your mysql password must be vicidialnow or you can go into the recordinglookup.php file and change it.

[brett05]

thanks big thanks
but i need to ask you some thing
how can i change url for my recording
here i use /RECORDING/MP3/
also a strange thing i have connect good to my database "asterisk" and to all this table "vicidial_users","vicidial_statuses","vicidial_campaigns","vicidial_campaign_statuses".
also i have change the default password "vicidialnow" to the"mynewpassword".
but i see no seach when i clik submit after choose my compaig and date and dispostion etc..
do you have a idea
thaks

[mflorell]

To donate to the project just post your code to the issue tracker in a new ticket. If it is something that you want us to include in a release, then we will need a release from you to make it official. You can email me off-list about that at vicidial -at- gmail.com.

[ageraldo]

Hello

Brett you can use a str_replace in php and replace the

str_replace($row2['location'],....

[ageraldo]

Matt, i can not put ticket with my account, can you help me?

[brett05]

same thing whe in choose all my option as "User:" and "From: to:" and "Campaigns: and "phone:" and "Disposition:" and finaly i clik in submit i see "Total Records:0" also if i have any error in my database "asterisk" i will see a error message from mysql_query or mysql_connect but with mt situation i see no error juste i see "Total Records:0" .
now i will explain more your source "for exemple i don't need i think to replace "str_replace($row2['location'],...." because "filname and location " i located in asterisk.recording_log table .
with this exemple in your source:

if (isset($_POST['Submit']))
{
$sql= "SELECT campaign_id,v.lead_id,r.lead_id,status,location,call_date,r.user,phone_number,filename,length_in_min";
$sql.= " FROM asterisk.vicidial_log v, asterisk.recording_log r";
$sql.= " where v.uniqueid=vicidial_id";
$sql.= " and r.user like '%".$_POST['usuario']."%'";
$sql.= " and phone_number like '%".$_POST['telefono']."%'";
$sql.= " and call_date between '".$_POST['f_inicio']." 01:00:00' and '".$_POST['f_fin']." 23:59:59'";
$sql.= " and status like '%".$_POST['dc']."%'";
$sql.= " and campaign_id='".$_POST['campaindc']."'";
$sql.= " order by call_date desc";

$result2 = mysql_query($sql) or die ('Error en el query');
$num_rows = mysql_num_rows($result2);
}

so the seach is maked good in this table.
i think maybe the difference is with your language choose ,here in your source i see some esponal variable and my asterisk datebase is filled with english language.
and you know more good your source maybe you can help me more .
i have lived your interface it seem easy and good.

[ageraldo]

Can you give access to your system ?

with showmypc or something like that?

[brett05]

i have send you a PM you can check it

[ageraldo]

Excuse me Brett what is PM?

[brett05]

look this image
http://img40.imageshack.us/i/sanstitre1qzs.jpg/

[ageraldo]

I dont see the pic

[brett05]

ok no probleme
send me a mail at this adress balstar514@yahoo.fr

[ageraldo]

send me an email to ageraldo at proviteldr.com

[mflorell]

What exactly is the error message you get when you try to open a ticket in Mantis?

[ageraldo]

i get this message when i go to VICIDIAL Issue Tracker

Your account may be disabled or blocked or the username/password you entered is incorrect.

[mflorell]

What is your mantis username?

[ageraldo]

ageraldo2

[mflorell]

Well, looks like you have 3 accounts and all of them are active, none of them blocked. Have you tried resetting the password?