Difference between revisions of "M4 CDR Export Templates"

From Kolmisoft Wiki
Jump to navigationJump to search
Line 57: Line 57:
Note: depending on database structure some columns may not be displayed (this includes ''terminated by, pdd, originator id, answer time, end time'')
Note: depending on database structure some columns may not be displayed (this includes ''terminated by, pdd, originator id, answer time, end time'')


<br><br>
==Email Templates==
==Email Templates==



Revision as of 07:45, 4 January 2023

CDR Export Templates allow to create templates with specific columns for CSV files. These templates can be used to export CDRs from Last Calls.

How to download CDR by template

Go to Billing -> CDR -> Export -> Templates and create new template with columns that you want to export.

M2 cdr export templates.png

Now if you go to Calls List, you should be able to see Export to Template button:

M2 last calls cdr export templates.png


By pressing Export, all CDRs by specified filters will be exported to CSV file and only columns from CDR Template will be included.

CDR CSV archive will be sent via email to System administrator.

NOTE: archive size is limited to 10MB! If CDR archive is larger, then archive will not be sent back.

Available columns

  • Answer Time - date and time when call was answered (empty if call was not answered);
  • Billsec - billable duration (from answer to hangup) excluding minimal time and increment;
  • Call ID - call id in M2 system;
  • Called From - Originator's number (CallerID), for example "John Smith" <123456789>;
  • Called To - localized destination number;
  • Date - date and time when call was started (first INVITE packet);
  • Destination - Direction and Destination name of dialed destination;
  • Destination Name - only Destination name (without Direction name);
  • Destination Number - original destination number (including technical prefixes);
  • Direction Name - only Direction name (without Destination name);
  • Disposition - call disposition (ANSWERED, BUSY, NO ANSWER or FAILED);
  • Duration - call duration from first INVITE to BYE;
  • End Time - date and time when call ended;
  • Hangup Cause - reason why call ended (Disposition + Hangup Cause Code, for example ANSWERED(16));
  • Hangup Cause Code - reason why call ended (only numeric value, for example 16);
  • Originator - name of Originator User (Client);
  • Originator Billsec - billable duration (from answer to hangup) including Originator's increment and minimal time;
  • Originator ID - ID of Originator in M2 system;
  • Originator IP - Originator's IP address;
  • Originator Price - call price by Originator's Tariff;
  • Originator Rate - call rate by Originator's Tariff;
  • Originator User ID - ID of Originator's User in M2 system (Client ID);
  • PDD - PDD in seconds;
  • Prefix - prefix used to find rate;
  • Real Billsec - same as Billsec but in decimal (more precise);
  • Real Duration - same as Duration but in decimal (more precise);
  • Server ID - ID of server which was used to make call;
  • Source Number - Originator's number part of CalleID;
  • Terminated by - shows who hangup call (unknown, system, originator, terminator);
  • Terminator - name of Terminator User (Supplier);
  • Terminator Billsec - billable duration (from answer to hangup) including Terminator's increment and minimal time;
  • Terminator ID - ID of Terminator in M2 system;
  • Terminator IP - Terminator's IP address;
  • Terminator Price - call price by Terminator's Tariff;
  • Terminator Rate - call rate by Terminator's Tariff;
  • Terminator User ID - ID of Terminator's User in M2 system (Supplier ID);
  • Unique ID - uniqueid of call in M2 system;

Note: depending on database structure some columns may not be displayed (this includes terminated by, pdd, originator id, answer time, end time)



Email Templates

If archive is sent successfully, System administrator should receive success email which can be customised in Emails settings. CDR archive will be attached.

See also