DROP calls are missing from Export Call Reports

[ccetech20]

Hi

On my install, I have found a very annoying thing thats happening.

CAMPAIGN SETTINGS
The campaign is a blended one with 2 DID as inbound and Manual outbound.
- Campaign is able to rec calls and dial out manual calls as normal.

Problem
If a call comes and is registered in the system as DROP, there is no way that the manager can get to see what numbers are dropped out of the system. We have tried exporting call reports but it does not include DROP status.

[omarrodriguezt]

Go to Reports->Export Leads Report->Choose the date , the campaign, the ingroup, the list, and chose "DROP" in the statuses option.
It works for me.

[ccetech20]

I have tried it and it gives error:

Code: Select all

There are no outbound calls during this time period for these parameters

[omarrodriguezt]

Well, I recommend you to add DB=Y to the url and look for the mySQL code.

[ccetech20]

Thanks for quick reply.

Here is the code:

Code: Select all

SELECT use_non_latin,outbound_autodial_active,slave_db_server,reports_use_slave_db,custom_fields_enabled FROM system_settings; |SELECT count(*) from vicidial_users where user='admin' and pass='XXXXX' and user_level > 6 and export_reports='1' and active='Y';| |SELECT count(*) from vicidial_users where user='admin' and pass='XXXXXXXXXX' and user_level='7' and view_reports='1' and active='Y';| |SELECT user_group from vicidial_users where user='admin' and pass='XXXXXX' and user_level > 6 and view_reports='1' and active='Y';| |SELECT allowed_campaigns,allowed_reports from vicidial_user_groups where user_group='ADMIN';| SELECT vl.call_date,vl.phone_number,vl.status,vl.user,vu.full_name,vl.campaign_id,vi.vendor_lead_code,vi.source_id,vi.list_id,vi.gmt_offset_now,vi.phone_code,vi.phone_number,vi.title,vi.first_name,vi.middle_initial,vi.last_name,vi.address1,vi.address2,vi.address3,vi.city,vi.state,vi.province,vi.postal_code,vi.country_code,vi.gender,vi.date_of_birth,vi.alt_phone,vi.email,vi.security_phrase,vi.comments,vl.length_in_sec,vl.user_group,vl.alt_dial,vi.rank,vi.owner,vi.lead_id,vl.uniqueid,vi.entry_list_id from vicidial_users vu,vicidial_log vl,vicidial_list vi where vl.call_date >= '2013-05-01 00:00:00' and vl.call_date <= '2013-05-07 23:59:59' and vu.user=vl.user and vi.lead_id=vl.lead_id and vl.campaign_id IN('trin') and vl.status IN('DROP') order by vl.call_date limit 100000; There are no outbound calls during this time period for these parameters


[omarrodriguezt]

Ok, were you able to find out and fix the issue?

[ccetech20]

Nope, infact I just found out some hack attempts and was resolving them.

I am stumped, why is it not showing DROP calls.

[omarrodriguezt]

What is your actual vicidial version?
What is the last build?

[ccetech20]

VERSION: 2.4-309a
BUILD: 110430-1642

[omarrodriguezt]

Are you using vicidial or go auto dial?

[ccetech20]

@omar
its goautodial.

[omarrodriguezt]

Ok. Because the releases are being updated just for vicibox at the moment. Goautodial is a customized solution.
Try to find out the same php report in the vicibox iso and let us know if works

[ccetech20]

I could figure out one glitch; at times it shows drop calls at times it does not.

Also, if I export call reports, only then it shows DROP call that too if I select all status(s) to be exported. If I select "DROP" as an export option, it shows no outbound call made during this period.

[omarrodriguezt]

Ok. Anyway I recommend you upgrade to the last vicibox version.,

[ccetech20]

If it is goautodial, can I upgrade it as well?

[striker]

yes you can upgarde to latest vicidial version.
You will loose the goautodial fancy User interface and u need to use the default vicidial UI

check this link http://wiki.vicidial.org/index.php/SVN:howto

[gardo]

You can also download and install the latest GoAutoDial ISO (v3.0 RC1a) from http://goautodial.org. It's based on Vicidial 2.4 RC2 and has graphical and comprehensive reporting tools available via our GOreports application. Check the screenshots here: http://goautodial.org/news/10.