Dynamic Call Reports

[MaxL]

I am trying to set up a dynamically updating call report that will show calls that have come in between 8:00AM and 12:00PM every day. I tried setting a custom time frame template in the reporting creator for today between those times thinking it would update the date daily. Is does not appear to have done that. Is there any way to create a call report that will always show data from the day the report was run? This is a scheduled report that should run automatically.

 

[VasilisV_3CX]

Hi @MaxL,

I don't think that it will increment the custom value by 1 when you set the report to run daily. What you could do is set a daily report to run at 12, that way you'd have it run from 00:00 - 12:00 daily, which if opening is at 08:00 means that you'd get the same data you're looking for without the need for a custom selection.

 

[MaxL]

This really won't work. We have very specific needs for reports to come with certain blocks of data as we do not have time to split the data once it comes in. Are there any other options available for dynamically pulling data based on the date?

 

[VasilisV_3CX]

Hi @MaxL,

The built in options will provide you with more data than you'd like. The options I can think of would be to create a filter in excel and export the data as a .csv, so you only see 8am to 12pm, or if you'd like something more custom, you'd need to write your own script that makes use of the CDR data, outputting it where you'd like and sifting it to only include the data between the timeframes you require.

 

[VoIPTools]

As @VasilisV_3CX suggests, you could build custom reports from scratch using the data available in the CDR files 3CX can optionally create. There is very useful call summary information provided by these files. The trick is automating the process of accessing the CDR files, parsing the data, and placing the data into a database that your reporting tool can access. I encourage you to take a look at our 3CX Exporter tool. It solved all of the complexities outlined above.

However, you do not have to settle for just the summary information provided by the CDR files. Exporter can replicate to SQL / MySQL all the same data 3CX uses for their built-in reports so you can build whatever reports you need using the reporting tool you prefer.