Skip to content

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.

admin-ftp.png

Figure 81.1 File Transfer Protocol.
  1. Server address for FTP
  2. FTP Username.
  3. FTP Password.

sftp-filezilla-settings.png

Figure 81.2 Monitored calls - bulk download.

Next please follow steps below to configure popular FileZilla http://filezilla-project.org/ FTP client:

  1. Select Site Manager... from the File menu.
  2. Enter sftp.ssl7.net into Host field.
  3. Enter 21 into Port field.
  4. Select FTP - File Transfer Protocol.
  5. Select Require explicit FTP over TLS.
  6. Select Normal logon type.
  7. Enter your username - see Figure %IMG_FTP_ACCESS% (5) - into User field.
  8. Enter your password - see Figure %IMG_FTP_ACCESS% (6) - into Password field.
  9. Click Connect button.

Info

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):

  1. YYYY-MM-DD-queue_call.csv contain detailed records for each call.
  2. YYYY-MM-DD-queue_user_call.csv this 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: V Voice mail, U User/agent, Q another Queue, R Routed 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 C Call Connected with the destination or H Hanged UP

Monitored (recorded) Calls

Format of recording files as below:

YYYY_mm_dd_HH_mm_ss-SIP_USERNAME-CALLER_ID-CALLED_NO-UNIQUEID.mp3

Note: recordings are uploaded to FTP site in real time and are available for download few seconds after the call is completed.