This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
configuration:telephony:history [2014/01/16 15:19] – admin | configuration:telephony:history [2020/01/29 15:59] – asilva | ||
---|---|---|---|
Line 3: | Line 3: | ||
:!: | :!: | ||
- | In Comms Mundi there is a limitation on the number of calls store internally, to avoid this limit, you can export the telephony call logs to an external database or to an CSV file. | + | In Comms Mundi there is a limitation on the number of rows store internally, to avoid this limit, you can export the telephony call logs to an external database or to an CSV file. |
Line 10: | Line 10: | ||
You can select the columns to export. In order to select the variables to export do: | You can select the columns to export. In order to select the variables to export do: | ||
- | * Click on the icon behind | + | * Click on the icon in the left of text //Export// |
* to add a new column, click on the //add// button. Set the **column** name and **variable** field to export. | * to add a new column, click on the //add// button. Set the **column** name and **variable** field to export. | ||
* to delete a column, click on the //delete// button | * to delete a column, click on the //delete// button | ||
Line 34: | Line 34: | ||
:!: | :!: | ||
The export is done at the same time as the CDR. If there is a problem connecting to the ODBC (connection lost, table doesn' | The export is done at the same time as the CDR. If there is a problem connecting to the ODBC (connection lost, table doesn' | ||
+ | |||
+ | |||
+ | ===== Available fields ===== | ||
+ | * //uuid// - call identifier | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * //billsec// - call billsec, equals to answer time - end time | ||
+ | * // | ||
+ | * //ani// - original source caller identifier | ||
+ | * //aniii// - original source caller identifier 2 | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * //context// - last context name | ||
+ | * // | ||
+ | * //dnis// - original destination number | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * //price// - price | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | * // | ||
+ | |||
+ | |||