Missed Call

[NOC12]

Hi,

I want to automate missed calls to be posted to an online spreadsheet.

I can do this by using a notification of a missed call VIA email but if it does not get to the final destination it does not work for me.

At the moment I have a ring group and if that does not answer it goes to another ring group and if they don't answer it goes to a virtual extension which then sends an email to which it posts it to the excel sheet automatically. But if the customer hangs up before reaching the virtual extension I have no way of automating this.

Is there a way I can access this through the database or something similar?

I am using power automate to automate this process.

 

[VasilisV_3CX]

Hi @NOC12,

If you send the last leg to a call queue (requiring a PRO license), you should be able to run an Abandoned Call Report and concatenate the data in order to get a clearer picture. Alternately in your situation, you can run a Call Report and only generate a report of 'unanswered' calls for that specific extension.

 

[NOC12]

Hi,

I want to automate the process, once a missed call is logged then post it to the spreadsheet without me having to do anything?

 

[VasilisV_3CX]

Hi @NOC12,

Yes, you'll need to figure out how to automate that. I'm letting you know where you can find the data. It can be exported in .csv which with some scripting, you may be able to pull the data and concatenate it. How though? That'd be your challenge I'm afraid.

If anyone else has done this they may be able to chime in and help out.

 

[NOC12]

Is there no other way to pull the data other than using those Reports in the management console?

 

[VasilisV_3CX]

What about if you can enable the CDR, which if you tell it to add a new line on each new call, will create a log of all calls which will allow you to pull only lines you're looking for.

 

[NOC12]

Ok, thank you, I will look into that.

 

[NOC12]

Is there any more info available besides https://www.3cx.com/docs/cdr-call-data-records/#h.xqscimnsx9j4 ?

 

[VasilisV_3CX]

Hi @NOC12,

What other information would you be looking for specifically?