vicidial.org

Hi all
I am an industrial engineer major doing my final project on call center optimization.
the company i'm surveying uses a vicidial powered phone system which i'd like to use to get the information I need to analyse.
the info i need is as follows:
call records which show: time call came in--> time in IVR--> which queue it went to--> how long in queue(wait time)--> how long in service (if possible how long in system total) now i need this info for ALL calls(every single call separately) for a period of 3-6 months
i'v been reading the reports which show wait times (avg and max) and call volumes and lengths so the info i need mush be in there somewhere
I'd be very happy if someone could help me with this.
I asked the sys admin to send me raw info so i have a 10mb .csv file wich i'm struggling with .

have a look at the log tables in mysql.

that would be any table whose name ends in "log".

why will mysql be any different than exporting to csv files
anyway i cant really make heads or tails from what i get each call appears as 2 3 or 4 legs

because the exported csv files are aggregate data compiled from the logs.

but the logs have the real data.

if you don't understand the logs, you'll just have to learn all the reports and see what you can pull out.

may want to make some calls first.

i actually have a year worth of calls my csv file is 390000 rows long
thanks ill have to see how i get the log files as is