Call Times not correct for time zone 3CX server is running in

[Simon Dulwich]

I have multiple 3CX servers around the world and have cdr.log files created and then exported into a database for call reporting.

When I use a Powershell script to copy the cdr.log file and rename it with today's date and current time the new filename matches the local server's time. However when I look at the calls logged by 3CX the times are based on GMT time regardless of which office around the world I'm viewing.

Does anyone know how I can change the cdr.log files to output the call times for the local server, and not use GMT times?

 

[YiannisH_3CX]

Hello @Simon Dulwich

Please note that all CDR files will be created in UTC time and there is no setting to adjust this. You will need to provision for the time difference of the output.

 

[Simon Dulwich]

So I need to modify the output of the cdr.log file to make it correct. Why can't the system do this, as the Call logs show the correct times?

 

[Simon Dulwich]

We use reports to see how many calls a user has made and received. They are required to make x amount of hours of calls a month so we need to report on this. 3CX doesn't offer this type of report so we've had to export the calls using cdr.log and import into a database to run the reports from.

Can 3CX fix this so cdr.log files match the Call log report figures that show correct times?

 

[YiannisH_3CX]

Call logs and reports automatically compensate for the time difference and present the results in the PBX time. CDR logs however do not as they are exported from the PBX in raw form.
I would recommend posting this as a feature request to our ideas section of the forum https://www.3cx.com/community/forums/3cx-ideas/ . All posts are reviewed by their corresponding Departments and, if feasible and voted for by other users as well, may be implemented in an upcoming service pack or update.

 

[Simon Dulwich]

Call logs and reports automatically compensate for the time difference and present the results in the PBX time. CDR logs however do not as they are exported from the PBX in raw form.
I would recommend posting this as a feature request to our ideas section of the forum https://www.3cx.com/community/forums/3cx-ideas/ . All posts are reviewed by their corresponding Departments and, if feasible and voted for by other users as well, may be implemented in an upcoming service pack or update.

Okay I have just done this.