Versions Compared

Key

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

...

  1. Take a copy of the data you want to re-run back in the system, stored by default in the backup folder of the main installation program.

    Code Block
    {Program Files}\Tri-Line\TIM Plus\backup
  2. Log in to TIM Plus as a
    Referencemacro
    Labelroot
    user, select the
    Referencemacro
    LabelSettings
    tab and click on the
    Buttonmacro
    LabelQuery browser
    button.
  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
    URL/download/attachments/13436056/rerunning_data_1.png

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

    Code Block
    languagejava
    delete from calls
    where datasource = '\1\'
    and strftime('%Y-%m-%d',datetime) >= '2011-01-22'
    and strftime('%Y-%m-%d',datetime) <= '2011-01-23';
    
    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 object you want to delete calls for.

  5. The query should return a

    Keywordmacro
    LabelNo results set
    message, confirming the selected calls have been deleted.

    Screenshotmacro
    URL/download/attachments/13436056/rerunning_data_2.png

  6. To re-spool the data back in the system, copy the previously-saved backup files and paste them into the following location:

    Code Block
    {Program Files}\Tri-Line\TIM Plus\spool
  7. While the system is processing the data, you can click on the 

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