Dial statuses are specific times

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Dial statuses are specific times

Postby hansg » Wed Jun 12, 2019 12:08 pm

Hi,

Is it possible to have a dial status within a campaign that will only load into the hopper between certain hours.

For example if a customer says Call back after 4pm. Disposition the call as "Evening Callback" and then the status is only loaded in after a set time.

If there isn't a way to do this using the interface, would it be possible to do via cron entry which would add a status to a campaigns dialable statuses?


Also on a totally different topic... Is it safe to delete the below files. If not how do i clear them?

/var/lib/mysql/asterisk/call_log_archive.MYD
/var/lib/mysql/asterisk/vicidial_dial_log_archive.MYD
/var/lib/mysql/asterisk/vicidial_carrier_log_archive.MYD

It is taking up a large amount of space.
Dual Core - 4GB DDR3 - 80GB SSD
Vicibox 9
VERSION: 2.14-751a
BUILD: 200425-0949
SSL Installed
hansg
 
Posts: 129
Joined: Wed May 11, 2016 8:56 pm

Re: Dial statuses are specific times

Postby williamconley » Wed Jun 12, 2019 12:31 pm

1) You posted the base requirement of Vicidial Version with Build. Well done. Please also try to include your installer with version (it makes a difference!).

2) Two questions in one post? Consider that the subject line will make that second question difficult to find. Two questions should be two topics each with its own subject line appropriate to the question. Hang your head in shame.

3) Campaigns have filters, filters can contain times and statuses and pretty much everything else. Start simple by having a filter disallowing all callbacks and another one allowing the one you want to fire right now. Then at 4PM, change the filter to allow evening callbacks. Later you can begin writing one that includes the present time and allows appropriate callbacks based on the present time. Best to test that against your "simple" manual ones to be sure they don't misfire.

4) Those are table data files. Delete the data from the tables and await the nightly "optimization" process and they will zero out. Assuming, of course, you no longer need that data. You can also "mysqldump" that data to disk, gzip the result, and store it on your laptop "just in case".
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Dial statuses are specific times

Postby hansg » Wed Jun 12, 2019 1:44 pm

Thanks for your reply William.

When you say "Delete the data from the files". Is that any different than right clicking the .myd file and hitting delete?
Dual Core - 4GB DDR3 - 80GB SSD
Vicibox 9
VERSION: 2.14-751a
BUILD: 200425-0949
SSL Installed
hansg
 
Posts: 129
Joined: Wed May 11, 2016 8:56 pm

Re: Dial statuses are specific times

Postby williamconley » Wed Jun 12, 2019 1:54 pm

sorry for the error: Delete the data from the TABLES. Those are table data files. Deleting the data from the table will not reduce file size immediately, but when optimization runs the file size will drop.

of course, you won't have the data that was in the table because you deleted it.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Dial statuses are specific times

Postby hansg » Wed Jun 12, 2019 1:55 pm

Thanks for the clarification.

What is the best command to do that?
Dual Core - 4GB DDR3 - 80GB SSD
Vicibox 9
VERSION: 2.14-751a
BUILD: 200425-0949
SSL Installed
hansg
 
Posts: 129
Joined: Wed May 11, 2016 8:56 pm

Re: Dial statuses are specific times

Postby williamconley » Wed Jun 12, 2019 2:04 pm

"truncate TABLENAME" will empty any table.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 62 guests