key report on survey campaing

Method 1

mysql  -e "select * from vicidial_list order by entry_date desc limit 100\G;" asterisk

-------------------------------------

Method 2

database name  asterisk

select asterisk;

MariaDB [asterisk]> select * from vicidial_list order by entry_date desc limit 10\G;

*************************** 1. row ***************************

                lead_id: 2874301

             entry_date: 2021-06-14 16:57:51

            modify_date: 2021-06-14 16:58:18

                 status: SVYHU

                   user: VDAD

       vendor_lead_code: 999999

              source_id: NULL

                list_id: 998

         gmt_offset_now: 0.00

called_since_last_reset: Y

             phone_code:

           phone_number: 393333635186

                  title: NULL

             first_name: Test

         middle_initial: NULL

              last_name: Call

               address1: Test Call

               address2: 2

               address3: 3

                   city: Springfield

                  state: IL

               province: NULL

            postal_code: NULL

           country_code: NULL

                 gender: U

          date_of_birth: NULL

              alt_phone: NULL

                  email: NULL

        security_phrase: 6

               comments: ROBOCALL test call placed 2021-06-14 16:57:51

           called_count: 1

   last_local_call_time: 2021-06-14 16:57:51

                   rank: 99

                  owner: Test Outbound Call

          entry_list_id: 0

 http://www.eflo.net/VICIDIALforum/viewtopic.php?f=2&t=38605

change php time zone

edit the 

/etc/php7/apache2/php.ini

Add the New_York time zone

date.timezone = America/New_York

restart apache2

service apache2 restart

http://78.91.2.1/vicidial/admin.php?ADD=999999&stage=TIME

https://www.php.net/manual/en/timezones.php

fixing vici repo issue

 zypper addrepo -f http://packman.inode.at/suse/openSUSE_Leap_15.2/ packman

https://opensuse-guide.org/repositories.php

Re: Increase the length of recordings

 

Re: Increase the length of recordings

by mflorell » Fri Nov 13, 2020 12:46 pm

This is set in the Modify Server admin page for each server on your system:

Recording Limit -
This field is where you set the maximum number of minutes that a call recording initiated by the system can be. Default is 60 minutes. This setting also limits the amount of time a 3-way call that has been left by an agent will stay up before it is terminated.

mflorell

Site Admin

 

Posts: 17607

Joined: Wed Jun 07, 2006 2:45 pm

Location: Florida

Re: Dialing Completed Leads

 

Re: Dialing Completed Leads

by mflorell » Thu Oct 22, 2020 6:51 am

When we've looked into this issue for clients it's usually one of these two causes:
1. Agents manually dialed the numbers
2. Inbound calls came in, were matched to the leads and changed their status

To confirm that the hopper isn't loading them, I'd suggest adding the "--dbdetail" flag to the "/usr/share/astguiclient/AST_VDhopper.pl" entry in the crontab, so you can see what the status of the lead was before it was loaded into the hopper.

Call status report with caller numbers

 by mflorell » Sun Aug 23, 2020 11:49 am

That's the whole reason we created "Drop Lists" as a feature in VICIdial:

"Drop Lists are a feature that allows you to add new leads to a list built from DROPped calls from inbound groups 

on a scheduled basis. To enable Drop Lists, you need to go to Admin -> System Settings, and Enabled Drop Lists. 

Then you can go to Lists -> Drop Lists, and Add a New Drop List."

mflorell

Site Admin

 

Posts: 17578

Joined: Wed Jun 07, 2006 3:45 pm

Location: Florida

Top

Loading new leads with existing call status

 

Re: Loading new leads with existing call status

by mflorell » Tue Jul 26, 2016 8:07 am

You can use the CLI lead loader to load leads with a pre-defined status, just use the "standard" format:
/usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --help

standard:
vendor_lead_code|source_id|list_id|phone_code|phone_number|title|first_name|middle|last_name|address1|address2|address3|city|state|province|postal_code|country|gender|date_of_birth|alt_phone|email|security_phrase|COMMENTS|called_count|status|entry_date|multi-alt-entries
3857822|31022|105|01144|1625551212|MRS|B||BURTON|249 MUNDON ROAD|MALDON|ESSEX||||CM9 6PW|UK||||||COMMENTS|2|B|2007-08-09 00:00:00|7275551212_1_work!7275551213_61_sister house!7275551214_44_neighbor