billing software

[gdidom]

Hello,

I'm developing a billing software and I wish to add a plugin for vicidial. I'm a little bit newbie on the system !! I want to take every inbound and outbound calls in vicidial and calculate the cost for each call, and give a total cost by campaign, by agent, by day... and a detailed list of calls.

I looked at the vicidial tables and here's my analyse :

"vicidial_log" table = outbound calls
"vicidial_closer_log" table = inbound calls

table structure :
campaign_id = name of the campaign
call_date = call date and call hour
length_in_sec = call length in seconds
phone_number = phone number called or calling
user = agent on the phone

I have many questions, I hope you can help me :
- In the "vicidial_log" table, the user "VDAD" means that no agent is available to take the call ?
- In the "vicidial_log" table, the value "MANUAL" in the column "COMMENTS" means that the agent dialed manualy ?
- In the "vicidial_closer_log" table, the user "VDCL" means that the call is in queue and must be ignore for the billing ?
- For the column "STATUS", I noticed several values, is it important or not for the billing ?

Tell me if I'm wrong or not ?
Thank you for your help, vicidial is a great project...

Gilles.

[ramindia]

Hi

- In the "vicidial_log" table, the user "VDAD" means that no agent is available to take the call ?

This is for Autodial

- In the "vicidial_log" table, the value "MANUAL" in the column "COMMENTS" means that the agent dialed manualy ?

yes this can Manual Dial

- In the "vicidial_closer_log" table, the user "VDCL" means that the call is in queue and must be ignore for the billing ?

For Incoming or many be closer
- For the column "STATUS", I noticed several values, is it important or not for the billing ?

disposition of the Call

can some one correct me if iam wrong

ram

[mflorell]

Do you want to include ring-time in your cost calculations?

Some VOIP providers charge for ring time and some do not.

[gdidom]

No I don't want to include ring-time...

Thanks for your answers, but can you give me more details please ??

[mflorell]

- In the "vicidial_log" table, the user "VDAD" means that no agent is available to take the call ?

Or it means that the call was not answered. If no agent, then the status should be DROP

- In the "vicidial_log" table, the value "MANUAL" in the column "COMMENTS" means that the agent dialed manualy ?

Yes

- In the "vicidial_closer_log" table, the user "VDCL" means that the call is in queue and must be ignore for the billing ?

For billing of agent time, that is correct.

- For the column "STATUS", I noticed several values, is it important or not for the billing ?

It should not be important for what you are trying to calculate.
[/b]

[gdidom]

thanks for your precisions, I will give you news for the development of the software.

[roll72]

Does there is any news on the billing add-in ?

could we help ?

thanks for your answer

[bajari]

hello did you ever complete the billing software?