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

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.