CDR "dateTimeOrigination" conversion formula in Excel?
Can someone point me to some documentation or an answer for converting the "dateTimeOrigination" entry in the CDR database into a real Date/Time format. The timestamps are in UTC format and we would like to make the conversion within an Excel spreadsheet.
Microsoft Excel =(A1 / 86400) + 25569 Format the result cell for date/time, the result will be in GMT time (A1 is the cell with the epoch number). For other time zones: =((A1 +/- time zone adjustment) / 86400) + 25569.
It gives you GMT time. If you would like to convert MST (in our case) time please use the below formula in excel.
Contact Center users dial out/call customers from their computers via a desktop based application like Cisco Finesse Agent / CAD (Cisco Agent Desktop) application or any other 3rd party application.As per organizational process the requirement is ...
i want share with you my setup, how i configure TMS 15.6.0 with SQL 2012:
-first of all this deployment design in LAB just for practice, my deployment contain SQL and TMS in same server if you need to install TMS in another server yo...