Skip to main content
Kofax

How to setup the timing of LiteScape ODBC Interface to track Telephone on EP5 System

Article # 3016273 - Page views: 161

How to setup the timing of LiteScape ODBC Interface to track Telephone on EP5 System

Question:

How to setup the timing of LiteScape ODBC Interface to track Telephone on EP5 System

Answer:

There can be a timing issue with the the way LiteScape process data at midnight and when Equitrac polls the LiteScape SQL Server.

Explaination of LiteScape Process starting at 11:00 PM Nightly:

  • Once the call is made, LiteScape saves the record without duration to CallRecordlog table with tsinternalconnect, tsinternaldisconnect populated
  • Every 10 minutes LiteScape runs a process called LiteScapeCDR that picks up CDR files from ftp server and add them to temp table cdrparams
  • LiteScape then runs a SQL job called SyncCDRBatched that runs every night at 11pm and takes all the records from CDRParams and adds to CallRecordlog table
  • Another SQL job runs at midnight called SyncCDRAmount, that populates duration from Long Distance and International calls.

Best Practice:

  • Essentially Equitrac needs to only read CallRecordlog table once a day after midnight, so probably at 2 am or after
  • To set this up in EP5 - You need to set the polling interval 1440 minutes (once a day)
    • Open System Manager > In left pane click on 'Call Accounting'
    • In right pane click on LiteScape ODBC device
    • Enter 1440 minutes (24 hours) in the polling interval field > OK to save. By setting this value the timer starts.

NOTE: EP5 does not allow you to specify the exact time you want to poll a device; if you want to have the system to poll the LiteScape Server at 2:00 AM you have to set/save the polling interval at 2:00 AM. that way the timer will start at 2:00 AM and poll every 1440 minutes.