<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style='font-size:10pt;font-family:Verdana,Arial,Helvetica,sans-serif;'>So just to verify that I am understanding all of that right as of right now call records for the subsriber will always siwn with a UTC time stamp? And when I export for use of an external billing system the timestamp should show correct for whatever I have set? <div id="message"></div><br id="br3"><div id="signature"><div><span style="font-size: 10pt;">Brian Pelletier</span></div></div><div id="content"><br> ---- On Wed, 21 Mar 2018 16:56:00 -0400 <b> rkrenn@sipwise.com </b> wrote ----<br><br><blockquote style="border-left: 1px solid rgb(204, 204, 204); padding-left: 6px; margin-left: 5px;"><meta><meta><div><div><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">Hi,</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">></span><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> Does anyone know how to adjust the time stamps on the call history when looking at subscribers? </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">Good news - we started to introduce timezones throughout ngcp, and CDR/EDR exporters are already covered (5.5.x backports pending).</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">No need to change the system timezone, instead it can be configured per subscriber/contract/reseller (using inheritance logic).</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">There are are new „localized“ variants of the export columns showing datetime:</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">CDR:</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">TIMEZONE</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">INIT_TIME_LOCALIZED</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">START_TIME_LOCALIZED</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">END_TIME_LOCALIZED</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> </span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">EDR:</span></p><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">TIMESTAMP</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">EVENT_TIMESTAMP</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">EVENT_TIMEZONE</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">EVENT_TIMESTAMP_LOCALIZED</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">With „</span><span style="font-size: 10pt; font-family: "Verdana", sans-serif">all of my time stamps seem to be 5 hours“ you most likely refer to the call start or init time, which are stored as epoch, and you them in UTC.<br><br></span><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)"></span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">Applying timezones to Panel UI timestamps is implemented soon. Meanwhile, a „tz“ parameter is supported for the calllist rest-api.</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)"> </span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)">regards</span></p><p class="MsoNormal"><span style="font-size: 11pt; font-family: "Calibri", sans-serif; color: rgb(31, 73, 125)"> </span></p><div><div style="border: none; border-top: solid rgb(225, 225, 225) 1pt; padding: 3pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span lang="DE" style="font-size: 11pt; font-family: "Calibri", sans-serif">Von:</span></b><span lang="DE" style="font-size: 11pt; font-family: "Calibri", sans-serif"> Spce-user [mailto:<a href="mailto:spce-user-bounces@lists.sipwise.com" target="_blank">spce-user-bounces@lists.sipwise.com</a>] <b>Im Auftrag von </b>Brian Pelletier<br><b>Gesendet:</b> Mittwoch, 21. März 2018 20:39<br><b>An:</b> <a href="mailto:spce-user@lists.sipwise.com" target="_blank">spce-user@lists.sipwise.com</a><br><b>Betreff:</b> [Spce-user] CDR Timestamps</span></p></div></div><p class="MsoNormal"> </p><div><p class="MsoNormal" style="margin-bottom: 12pt"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">Does anyone know how to adjust the time stamps on the call history when looking at subscribers? I am running 5.5.3 and in the eastern time zone. My system time shows correct along with the correct time zone. All of the different places i have been able to fine a setting for time zones seem too all match within SPCE itself when i query the mysql database for its time it returned everything correctly. all of my time stamps seem to be 5 hours ahead of what they should be.<br><br></span></p><div><div><p class="MsoNormal"><span style="font-size: 10pt; font-family: "Verdana", sans-serif">Brian Pelletier</span></p></div></div></div><p class="MsoNormal"> </p></div></div></blockquote></div></div><br></body></html>