voipcall_report show no data

[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?

[areski]

It works perfectly for us and many installation we have done.
Make sure to select the right campaign and date.

[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)"

[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

[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

[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

[joedialer]

Yes, that was it. Thank you again.