Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. 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
    LabelC:\Program Files\Tri-Line\TIM Enterprise\backup
  2. Log in to TIM Enterprise as root user and click on the
    Referencemacro
    LabelSQL
    tab.
  3. To check the datasource for the PBX object you want to delete calls for, enter the following query:

    Code Block
    languagejava
    SELECT name, fullkey from dir where type = 'pbx';

    Screenshotmacro
    Borderfalse
    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
    languagejava
    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
    Labeldatasource
    and
    Referencemacro
    Labeldatetime
      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
    LabelNo results set
    , confirming the selected calls have been deleted.

    Screenshotmacro
    Borderfalse
    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 on the Desktop and paste them into the following location:

    Keywordmacro
    LabelC:\Program Files\Tri-Line\TIM Enterprise\spool

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

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

...