Call CSV schedulers

This section allows programming automatic periodical CSV reports to retail client administrators.

Note

This section is almost identical to Invoice schedulers except to the fields that do not apply to CSVs (Invoice number sequence, Tax rate…)

When adding a new definition, these fields are shown:

Name

Name of the scheduled Call CSV

Email

Send generated Call CSV via email. Empty if no automatic mail is wanted.

Frequency/Unit

Defines the frequency (once a month, every 7 days, etc.) of the programmed task

Direction

Defines which calls should be included attending to its direction (inbound, outbound, both).

DDI

Allows selecting client’s one specific DDI.

Retail account

Allows selecting client’s one specific retail account.

Once created, some new fields and subsections are accesible:

Next execution

Shows next execution date

Last execution

Shows last execution and its result.

Tip

Modifying Next execution value allows forcing specific runs. For example, setting Next execution to current month’s first day will create again last month’s CSV report (for a monthly scheduler).

Generated CSVs of each scheduler can be accessed in List of Call CSV reports subsection.

CSV fields

These are the fields of the generated CSV files:

callid

Call-ID of the SIP dialog

startTime

Time and date of the call establishment

duration

Call duration in seconds

caller

Caller number in E.164 format (with ‘+’)

callee

Callee number in E.164 format (with ‘+’)

price

Calculated price for the given call (empty if Display billing details to client is disabled)

direction

Possible values: inbound, outbound.

ddiId

Client DDI to which call will be assigned (callee for inbound calls, caller for outbound calls).

endpointType

Fixed value: RetailAccount

endpointId

Internal ID of specific retail account

endpointName

Retail account name