clarification needed, vicidial_log vs vicidial_agent_log

[wpichler]

Hi all,

i need to make some custom statistics out of the vicidial system. For this i am currently looking at the different tables there.

I'd like to have a agent details statistic - so i do look at vicidial_agent_log and vicidial_log. The both seem to have nearly the same data - but not exactly.

If is search the vicidial_agent_log for a specific agent and campaign / date - then i get less results as when i filter the vicidial_log table with the same criteria.

The vicidial_agent_log table does have entries without uniqueid - but with a status - how should this work ?

The vidial_log table does have entries with status INCALL - but with end_epoch set, how should this work ?

Which table should i use for my statistics - and why are there so huge differences ?

br,
Wolfgang

[mflorell]

vicidial.php version and build?

the agent log is for agent activity, the vicidial_log is for outbound calls, the vicidial_closer_log is for inbound calls.

[wpichler]

VERSION: 2.4-309a
BUILD: 110430-1642

[mflorell]

I would suggest upgrading to at least 2.7 RC1. The version you are using is over 2 years old and there have been many logging bugs fixed since then.

[wpichler]

you know - upgrading is always a hassle...

how far does the database schema has changed ?

Is it possible to install the new version on a second server - accessing the database with schema of 2.4 ?

Can i manually upgrade database schema to 2.7 - and still use 2.4 gui and scripts for production ?

[mflorell]

There have been hundreds of database changes and bug fixes since 2.4. No you can't use the same code from 2.4 on 2.7.