Advanced - FTP Access¶
It is possible to bulk download CDR (Call Details Reports) and Monitored (recorded) Calls MP3 files using secure FTP program. First you need to obtain your FTP login details.
- Server address for FTP
- FTP Username.
- FTP Password.
Next please follow steps below to configure popular FileZilla http://filezilla-project.org/ FTP client:
Site Manager...from the
FTP - File Transfer Protocol.
Require explicit FTP over TLS.
- Enter your username - see Figure %IMG_FTP_ACCESS%
- Enter your password - see Figure %IMG_FTP_ACCESS%
Data older than 5 years is automatically deleted from the FTP server.
CDR (Call Details Reports)¶
Call details reports can be found in
CDRs directory. Format of
YYYY-MM-DD.csv CDR files is as below:
id- unique call ID
calldate- date and time of the call (in GMT+0)
src_id- source ID (relevant only for outbound calls to PSTN - will show SIP Username of the caller)
src- source number
clid- Caller ID
dst- destination number
dst_name- destination name (for example: "John Smith", "IVR Sales", "Queue Sales")
duration- total duration of call in seconds
billsec- number of seconds call was billed for
disposition- call outcome (for example: "CONNECTED", "BUSY")
destination- name of the destination (relevant only for calls to PSTN - for example "USA", "Germany Mobile" etc.)
rate- per minute rate
charge- total cost of the call
t_cause- Termination Cause (for example 'Normal Clearing', 'Busy', 'Congestion' etc.)
Note: CDR files are uploaded to FTP site every 24 hours (at 01:00:00 GMT+0), so you may have to wait until the most recent ones becomes available for bulk download.
Queue Call Reports¶
Specific Call Reports for the Queues can be found under
QueueCalls directory. Two reports are generated and uploaded to FTP site every 24 hours (at 01:00:00 GMT+0):
YYYY-MM-DD-queue_call.csvcontain detailed records for each call.
YYYY-MM-DD-queue_user_call.csvthis report show for each call all the points where it has been connected. For example, for each call we will have records showing all the agents where it has rang, as well as voice mailboxes or redirections to queues or IVRs.
This reports can be found into a
zip file with name format as follow:
YYYY-MM-DD-queue-calls.zip. Here you can find descriptions for this files attributes:
id- unique ID for the given record
user_id- user where call ring
location_id- location identifier for the given user
call_id- identifier for the incoming call
queue_id- identifier for the queue
ddi- called number
cli- calling number
callers- amount of calls in the Queue
agents- total number agents on queue
start_time- date and time of the call
hold_time- total amount of time that call spent on queue
ring_time- time during call was ringing under given agent
conn_time- conversation time for the call
final_dst_type- resource where call is routed:
RRouted to an IVR
final_dst_id- identifier for the call destination
disposition- ring order of the call. As there are several agents on the queue call will ring under each agent till it is finally connected with a single user
t_cause- termination cause of the call, it can be
CCall Connected with the destination or
Monitored (recorded) Calls¶
Format of recording files as below:
Note: recordings are uploaded to FTP site in real time and are available for download few seconds after the call is completed.