Re-running data

...

1. 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

2. Log in to TIM Enterprise under the root account and click on the

   Referencemacro
   Label SQL

   tab.

3. 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';

4. 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';

   Screenshotmacro

   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.

5. The query should return the message

   Keywordmacro
   Label No results set

   , confirming the calls have been deleted.

   Screenshotmacro

6. 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

7. 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.