SQL integration with additional call stats

[BK123456]

Hi,
At present we run an automated Call Report daily as a csv, then load that into a MYSQL DB for processing. Eg we look at Ring Time to determine our average and max ring times.
I'd like to improve this using the Call Journaling, but from what I have read only the variables below can be used.
Is this correct? Can we not split out Ring Time and Talk Time?
Thankyou
Brenton

1. Please note that you can use variables in the Call Journaling SQL Statement. Variables are specified between [], for example the external number is specified as [Number]. The available variables are:

• CallType - The type of call, it can be “Inbound”, “Outbound”, “Missed”, or “Unanswered”.
• Number - The external contact number (the number dialed for outbound calls or the caller number for inbound calls).
• Agent - The extension number of the agent handling the call.
• Duration - The duration of the call in “hh:mm:ss” format.
• DurationTimeSpan - The duration of the call as a TimeSpan object, which can be formatted as the user wants.
• DateTime - The start date & time of the call, in local time zone, formatted using the local culture from the 3CX server.
• CallStartTimeLocal - The start date & time of the call, in local time zone, as a DateTime object, which can be formatted as the user wants.
• CallStartTimeUTC - The start date & time of the call, in UTC time zone, as a DateTime object, which can be formatted as the user wants.
• CallEndTimeLocal - The end date & time of the call, in local time zone, as a DateTime object, which can be formatted as the user wants.
• CallEndTimeUTC - The end date & time of the call, in UTC time zone, as a DateTime object, which can be formatted as the user wants.

1. Your Call Journaling SQL Statement should be an INSERT statement, for example:

INSERT INTO calls (contactnumber, agentextension, description, calldatetime, callduration) VALUES ('[Number]', '[Agent]', '3CX PhoneSystem Call', '[DateTime]', '[Duration]')

 

[edossantos]

No, only those variables are available, and you can't split those times.

Also, please keep in mind that only calls from external numbers are reported (calls between extensions are NOT reported), and they are only reported when a contact is matched.

Other option you have is getting the information from the CDRs, using some script or program.