...
- Locate the backup files you want to re-run data for and copy them to a separate folder onto the Desktop. By default, the backup files are stored in the following location:
Keywordmacro Label C:\Program Files\Tri-Line\TIM Enterprise\backup - Log in to TIM Enterprise as root user and click on the
tab.Referencemacro Label SQL To check the datasource for the PBX object you want to delete calls for, enter the following query:
Code Block language java SELECT name, fullkey from dir where type = 'pbx';
Screenshotmacro Border false URL /download/attachments/13435810/rerunning_data.png To delete the calls for a specific PBX object and time period, enter the following query:
Code Block language java Delete from calls where datasource = '43\2\' and datetime between '2013-01-01 00:00:00' AND '2013-02-01 00:00:00';
Info The
andReferencemacro Label datasource
values must be modified accordingly, in order to match your requirements for the time period and the PBX you want to delete calls for.Referencemacro Label datetime The query should return the message
, confirming the selected calls have been deleted.Keywordmacro Label No results set Screenshotmacro Border false URL /download/attachments/13435810/rerunning_data_2.png To re-run the data back in the system, copy the backup files you have previously copied to separate folder on the Desktop and paste them into the following location:
Keywordmacro Label C:\Program Files\Tri-Line\TIM Enterprise\spool While the system is processing the data, you can check the
screen to view the calls that are being logged.Referencemacro Label Call view Info The time to re-spool the data will vary depending on the amount and size of the files your system is processing.
...