Re-running data

...

1. Locate the backup files you want to re-run data for and copy them to a separate folder. By default, the backup files are stored in the following location:

   Keywordmacro
   Label C:\Program Files\Tri-Line\TIM EnterprisePlus\backup

2. Log in to TIM Plus as the root web user user, select the

   Referencemacro
   Label Settings

   tab and click on the

   Referencemacrobuttonmacro
   Label SQLQuery browser

   tab button.

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

   Screenshotmacro
   Border false URL /download/attachments/13435810/rerunning_data.png

4. 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 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 selected calls have been deleted.

   Screenshotmacro
   Border false URL /download/attachments/13435810/rerunning_data_2.png

6. To re-run the data back in the system, copy the backup files you have previously copied to separate folder and paste them into the following location:

   Keywordmacro
   Label C:\Program Files\Tri-Line\TIM Enterprise\spool

7. While the system is processing the data, you can check the 

   Referencemacro
   Label Call view

   screen to view the calls that are being logged.

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

...