Re-running data

Follow the steps below to To re-run data in TIM Enterprise, follow the steps below:

1. Locate the backup files

   Take a copy of the data 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: KeywordmacroLabelC:\Program Files

   back in the system, stored by default in the 

   Referencemacro
   Label backup

   folder of the main installation program.

   Code Block
   {Program Files}\Tri-Line\TIM Enterprise\backup

2. Log in to TIM Enterprise as a

   Referencemacro
   Label root

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

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

4. To delete the calls for a specific PBX object and a specific 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 object you want to delete calls for.

5. The query should return the message a

   Keywordmacro
   Label No results set

   message, confirming the selected calls have been deleted.

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

6. To re-run spool the data back in the system, copy the previously-saved backup files you have previously copied on the Desktop and paste them into the following location: KeywordmacroLabelC:\Program Files

   Code Block
   {Program Files}\Tri-Line\TIM Enterprise\spool

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

   Referencemacro
   Label Call view

   screen to view monitor 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.