Page 1 of 1

voipcall_report show no data

PostPosted: Thu Oct 10, 2013 2:22 am
by joedialer
When going to voipcall_report the report shows no data forany campaign. The campaign run, and you can see results under survey_report.
Also the calls are showing up when using /dialer_cdr/callrequest/

My guess is that maybe the voipcall_report is looking up the calls in the wrong tables of the DB or maybe it can not understand the results of the calls in the FreeSwitch. Any ideas what the issue might be? Where should we look for clues?

Re: voipcall_report show no data

PostPosted: Thu Oct 10, 2013 7:31 am
by areski
It works perfectly for us and many installation we have done.
Make sure to select the right campaign and date.

Re: voipcall_report show no data

PostPosted: Thu Oct 10, 2013 10:56 pm
by joedialer
Can this be caused by us re-compiling freeswitch? We also installed 2.8 after the original 2.7 was installed. We do select the right campaign but it still not showing any data. Also when trying to choose DNC option we get "/usr/share/newfies-lua/libs/database.lua:283: attempt to concatenate local 'dnc_id' (a nil value)"

Re: voipcall_report show no data

PostPosted: Thu Oct 10, 2013 11:04 pm
by areski
Make sure you are using DNC node on a campaign that have a DNC list select, this error will happen if you created the campaign and left the DNC option empty

Re: voipcall_report show no data

PostPosted: Thu Oct 10, 2013 11:47 pm
by joedialer
Thank you, that resovled the DNC issue. But on the reporting still not show anything, regardless of which campaign I choose. When I look at dialer_cdr/callrequest/ all calls show status is still "Calling" even though the freeswitch show hangup already. I am not sure if its related but the campaign also does not retry when there is no answer. Even when changing the Time Between Retries & Completion Time Between Retries

Re: voipcall_report show no data

PostPosted: Fri Oct 11, 2013 7:34 am
by areski
This could be because you reinstalled manually Freeswitch.
If it's the case make sure you have /etc/freeswitch/autoload_configs/lua.conf.xml as this file :
https://github.com/Star2Billing/newfies ... a.conf.xml

Re: voipcall_report show no data

PostPosted: Fri Oct 11, 2013 9:43 pm
by joedialer
:) Yes, that was it. Thank you again.