Re-running data

...

Locate the files you want to re-run data for and copy them on a separate folder. By default, the backup files are saved in the following location:
Keywordmacro
Label C:\Program Files\Tri-Line\TIM Enterprise\backup
Log in to TIM Enterprise under the root account and click on the
Referencemacro
Label SQL
tab.
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';

To delete the calls for a specific PBX object and for a specific time period, enter the following query:

Code Block

language	java

Delete from calls 
where datasource = '2\3\'
and 
datetime between '2013-01-01 00:00:00' AND '2013-02-01 00:00:00';

Info

The

Referencemacro

Label	datasource

and

Referencemacro

Label	datetime

values must be modified accordingly, in order to match your requirements for the time period and the PBX you want to delete calls for.

The query should return the message
Keywordmacro
Label No results set
, confirming the calls have been deleted.
Screenshotmacro
To re-run the data back in the system, copy the backup files you have previously saved into a separate folder and paste them into the following location:
Keywordmacro
Label C:\Program Files\Tri-Line\TIM Enterprise\spool
While the system is re-running the data, you should be able to see in the
Referencemacro
Label Call view
screen the calls that are being processed.

Info
The time to re-spool the data will vary depending on the amount and size of the files your system is processing.

Versions Compared