Difference between revisions of "M4 CDR Management"
From Kolmisoft Wiki
Jump to navigationJump to search
m (Admin moved page M2 CDR Management to M4 CDR Management) |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
=Description= | =Description= | ||
When there are many old calls that are no longer useful, they can be archived and moved to | When there are many old calls that are no longer useful, they can be archived and moved to another place. | ||
Such | Such housekeeping increases system stability, reliability, and speed. | ||
<br><br> | <br><br> | ||
=Usage= | =Usage= | ||
| Line 11: | Line 11: | ||
Archiving options can be set in '''MAINTENANCE -> Settings''' in '''Archived Calls''' section: | Archiving options can be set in '''MAINTENANCE -> Settings''' in '''Archived Calls''' section: | ||
* '''Archive to''' - choose where to store Archived Calls. By default Archived Calls are stored in another MySQL table ''mor.calls_old''. You can also choose to store Archived Calls in compressed CSV files by selecting ''File (TGZ)'' option.<br> | * '''Archive to''' - choose where to store Archived Calls. By default Archived Calls are stored in another MySQL table ''mor.calls_old''. You can also choose to store Archived Calls in compressed CSV files by selecting ''File (TGZ)'' option.<br> | ||
** It is also possible to choose to store Archived Calls to FTP (TGZ). In this case, Archived Calls will be stored on an FTP server. Please enter [http://wiki.kolmisoft.com/index.php/ | ** It is also possible to choose to store Archived Calls to FTP (TGZ). In this case, Archived Calls will be stored on an FTP server. Please enter [http://wiki.kolmisoft.com/index.php/M4_settings#FTP FTP]server details if you would like to use this option.<br> | ||
* '''Archive Calls older than''' – this is the number of days. When a Call is older than the number you set, it will be archived and moved to Archived Calls.<br> | * '''Archive Calls older than''' – this is the number of days. When a Call is older than the number you set, it will be archived and moved to Archived Calls.<br> | ||
* '''Archive only ANSWERED calls''' – check to archive only answered Calls. Failed, Busy and No Answer Calls will be deleted.<br> | * '''Archive only ANSWERED calls''' – check to archive only answered Calls. Failed, Busy and No Answer Calls will be deleted.<br> | ||
* '''Archive Calls every day at''' – when archiving process should be started? Call archiving requires a lot of system resources therefore it is advisable to start archiving when call traffic is low.<br> | * '''Archive Calls every day at''' – when archiving process should be started? Call archiving requires a lot of system resources therefore it is advisable to start archiving when call traffic is low.<br> | ||
* '''Stop Archiving Calls at''' – when archiving process should be stopped? It is advisable to stop archiving before call traffic is increased. If time is not specified, Call archiving will be stopped when all Calls are archived.<br> | * '''Stop Archiving Calls at''' – when archiving process should be stopped? It is advisable to stop archiving before call traffic is increased. If time is not specified, Call archiving will be stopped when all Calls are archived.<br> | ||
* '''Do not delete Archived Calls from calls table''' - do not delete calls from calls table after copying them to calls_old table. | * '''Do not delete Archived Calls from calls table''' - do not delete calls from the calls table after copying them to the calls_old table. | ||
* '''Delete Calls instead of Archiving''' - if you don't need Calls older than X days, you can delete them instead of archiving.<br> | * '''Delete Calls instead of Archiving''' - if you don't need Calls older than X days, you can delete them instead of archiving them.<br> | ||
* '''Delete Archived Calls older than''' - this is the number of days. When '''archived''' Call is older than the number you set, it will be deleted.<br> | * '''Delete Archived Calls older than''' - this is the number of days. When '''archived''' Call is older than the number you set, it will be deleted.<br> | ||
* '''SQL Max Execution Time''' - max time in seconds for SQL query. The default time is 300 seconds (5 minutes). Used in Statistics pages (Calls List export and similar). | |||
'''NOTE''': you can check the completion of the call archiving process and other information in Background Tasks. | '''NOTE''': you can check the completion of the call archiving process and other information in Background Tasks. | ||
| Line 29: | Line 28: | ||
If calls are stored in another MySQL table ''mor.calls_old'' it can be found at '''Reports –> Call list –> Archived Calls'''.<br> | If calls are stored in another MySQL table ''mor.calls_old'' it can be found at '''Reports –> Call list –> Archived Calls'''.<br> | ||
Here you can see similar table to Last Calls, so you can check | Here you can see a similar table to Last Calls, so you can check call information at any time you want. You can find more information about each field in [[Last Calls]]<br> | ||
'''NOTE''' Simple Users cannot see Archived Calls page. | '''NOTE''' Simple Users cannot see the Archived Calls page. | ||
<br><br> | <br><br> | ||
==Archived Calls in Files== | ==Archived Calls in Files== | ||
If ''Archive to File (TGZ)'' option is enabled, Calls will be archived to CSV files (max 50000 lines per file), then compressed to TGZ and stored in your Backup storage directory (http://wiki.kolmisoft.com/index.php/Backup_system#Configuration).<br> | If ''Archive to File (TGZ)'' option is enabled, Calls will be archived to CSV files (max 50000 lines per file), then compressed to TGZ and stored in your Backup storage directory (http://wiki.kolmisoft.com/index.php/Backup_system#Configuration).<br> | ||
'''Calls | '''Calls archiving into file allows avoiding growing database and lets to use archived calls data more flexible.''' | ||
Files with calls can be found at '''REPORTS –> Call list –> Archived Calls -> Files''' | Files with calls can be found at '''REPORTS –> Call list –> Archived Calls -> Files''' | ||
<br><br> | <br><br> | ||
[[File: | [[File:m4_old_calls_in_file.png]] | ||
<br><br> | <br><br> | ||
'''NOTE''' Files can be reached and managed by '''admin''' only. | '''NOTE''' Files can be reached and managed by '''admin''' only. | ||
| Line 46: | Line 45: | ||
===Bulk management=== | ===Bulk management=== | ||
Files can be deleted one by one with click on '''DELETE''' in files list or few at a time by selecting period in '''Bulk management''' | Files can be deleted one by one with click on '''DELETE''' in the files list or a few at a time by selecting the period in '''Bulk management''' | ||
<br><br> | |||
= See also = | |||
* [[M4 Automatic CDR Export | Automatic CDR Export]] | |||
Latest revision as of 14:32, 15 October 2024
Description
When there are many old calls that are no longer useful, they can be archived and moved to another place.
Such housekeeping increases system stability, reliability, and speed.
Usage
Configuration
Archiving options can be set in MAINTENANCE -> Settings in Archived Calls section:
- Archive to - choose where to store Archived Calls. By default Archived Calls are stored in another MySQL table mor.calls_old. You can also choose to store Archived Calls in compressed CSV files by selecting File (TGZ) option.
- It is also possible to choose to store Archived Calls to FTP (TGZ). In this case, Archived Calls will be stored on an FTP server. Please enter FTPserver details if you would like to use this option.
- It is also possible to choose to store Archived Calls to FTP (TGZ). In this case, Archived Calls will be stored on an FTP server. Please enter FTPserver details if you would like to use this option.
- Archive Calls older than – this is the number of days. When a Call is older than the number you set, it will be archived and moved to Archived Calls.
- Archive only ANSWERED calls – check to archive only answered Calls. Failed, Busy and No Answer Calls will be deleted.
- Archive Calls every day at – when archiving process should be started? Call archiving requires a lot of system resources therefore it is advisable to start archiving when call traffic is low.
- Stop Archiving Calls at – when archiving process should be stopped? It is advisable to stop archiving before call traffic is increased. If time is not specified, Call archiving will be stopped when all Calls are archived.
- Do not delete Archived Calls from calls table - do not delete calls from the calls table after copying them to the calls_old table.
- Delete Calls instead of Archiving - if you don't need Calls older than X days, you can delete them instead of archiving them.
- Delete Archived Calls older than - this is the number of days. When archived Call is older than the number you set, it will be deleted.
- SQL Max Execution Time - max time in seconds for SQL query. The default time is 300 seconds (5 minutes). Used in Statistics pages (Calls List export and similar).
NOTE: you can check the completion of the call archiving process and other information in Background Tasks.
Archived Calls
If calls are stored in another MySQL table mor.calls_old it can be found at Reports –> Call list –> Archived Calls.
Here you can see a similar table to Last Calls, so you can check call information at any time you want. You can find more information about each field in Last Calls
NOTE Simple Users cannot see the Archived Calls page.
Archived Calls in Files
If Archive to File (TGZ) option is enabled, Calls will be archived to CSV files (max 50000 lines per file), then compressed to TGZ and stored in your Backup storage directory (http://wiki.kolmisoft.com/index.php/Backup_system#Configuration).
Calls archiving into file allows avoiding growing database and lets to use archived calls data more flexible.
Files with calls can be found at REPORTS –> Call list –> Archived Calls -> Files
NOTE Files can be reached and managed by admin only.
Bulk management
Files can be deleted one by one with click on DELETE in the files list or a few at a time by selecting the period in Bulk management
