Vicidial Deactivate Campaign Automatically by Specified Time

All installation and configuration problems and questions

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

Vicidial Deactivate Campaign Automatically by Specified Time

Postby justasking » Wed Sep 09, 2015 8:44 pm

Good day!

I would like to ask for your assistance on how to deactivate vicidial campaigns automatically base on specified time, or is it not possible to do that?

Example:

Campaign 1 should be deactivated at 8:00 am - 09:00 am (In this case, campaign 2 is activated)
Campaign 2 should be deactivated at 9:01 am - 10:00 am (In this case, campaign 1 is activated

Is there any alternative ways to achieve this? Agents are only using manual dial method. Thanks!

Vicidial version is VERSION: 2.6-395a BUILD: 130221-1736
Vicidial version is VERSION: 2.6-395a BUILD: 130221-1736 and our Asterisk version is 1.4.44-vici build 13 (1 DB, 1 WEB, 3 Telephony)
justasking
 
Posts: 43
Joined: Tue Sep 08, 2015 10:26 pm

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby williamconley » Wed Sep 09, 2015 10:02 pm

A couple methods ... you could create a script that would "POST" to the appropriate web page at the appropriate time or you could create a script that would change the necessary table entries for the campaign directly in the DB.
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby justasking » Wed Sep 09, 2015 10:18 pm

williamconley wrote:A couple methods ... you could create a script that would "POST" to the appropriate web page at the appropriate time or you could create a script that would change the necessary table entries for the campaign directly in the DB.


Whoaaa.. Creating script is out of my league :cry:
Vicidial version is VERSION: 2.6-395a BUILD: 130221-1736 and our Asterisk version is 1.4.44-vici build 13 (1 DB, 1 WEB, 3 Telephony)
justasking
 
Posts: 43
Joined: Tue Sep 08, 2015 10:26 pm

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby williamconley » Wed Sep 09, 2015 10:33 pm

In that case, you have a bit of a challenge. While it's fairly easy to do with a script ... it's virtually impossible to do without a script.

It's fairly simple to do, but you must also remember to log the agents out of the campaign or they'll just continue to call.
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby justasking » Wed Sep 09, 2015 10:51 pm

williamconley wrote:In that case, you have a bit of a challenge. While it's fairly easy to do with a script ... it's virtually impossible to do without a script.

It's fairly simple to do, but you must also remember to log the agents out of the campaign or they'll just continue to call.


Yup. Basically that's the idea. I'll try to learn on how to create scripts on vicidial.
Vicidial version is VERSION: 2.6-395a BUILD: 130221-1736 and our Asterisk version is 1.4.44-vici build 13 (1 DB, 1 WEB, 3 Telephony)
justasking
 
Posts: 43
Joined: Tue Sep 08, 2015 10:26 pm

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby williamconley » Wed Sep 09, 2015 11:04 pm

You'll be creating the script in PHP or PERL, not Vicidial. and it will be executing a SQL statement or two (or three ...).

Vicidial ... IS scripts. LOL (PHP and PERL scripts ...).

my advice: PHP. It's easier to learn!

Although, technically, you could just execute the sql statements directly at the command line. then you can skip the learning curve on php/perl completely!

Sort of depends on what you're comfortable with.

Look at "crontab -e" for the timed execution and the changes that are made to the "vicidial_campaigns" table when you turn a campaign on/off. Plus what changes are made to log agents off of a campiagn. In many cases, the SQL commands can be viewed on the Vicidial web pages by adding "&DB=1" to the end of the web page on which you make the changes. 8-)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby justasking » Wed Sep 09, 2015 11:07 pm

williamconley wrote:You'll be creating the script in PHP or PERL, not Vicidial. and it will be executing a SQL statement or two (or three ...).

Vicidial ... IS scripts. LOL (PHP and PERL scripts ...).

my advice: PHP. It's easier to learn!

Although, technically, you could just execute the sql statements directly at the command line. then you can skip the learning curve on php/perl completely!

Sort of depends on what you're comfortable with.

Look at "crontab -e" for the timed execution and the changes that are made to the "vicidial_campaigns" table when you turn a campaign on/off. Plus what changes are made to log agents off of a campiagn. In many cases, the SQL commands can be viewed on the Vicidial web pages by adding "&DB=1" to the end of the web page on which you make the changes. 8-)


My head hurt a bit while reading scripts, php and perl :?
Vicidial version is VERSION: 2.6-395a BUILD: 130221-1736 and our Asterisk version is 1.4.44-vici build 13 (1 DB, 1 WEB, 3 Telephony)
justasking
 
Posts: 43
Joined: Tue Sep 08, 2015 10:26 pm

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby omarrodriguezt » Thu Sep 10, 2015 8:22 am

Hello,
If you are not familiar with scripts, you can hire someone to help you like @William, or official vicidial sales@vicidial.com or create a Job Post in:
Jobs - Requests for Consultation
This is the forum used by people to post job openings or requests for quotes or consultations
http://www.ITContinental.com
Dedicated USA Servers - Vicibox - Vicidial - Limesurvey - Vtiger CRM - More than 15 years experience - Hablamos Español
omarrodriguezt
 
Posts: 667
Joined: Fri Jun 05, 2009 12:22 pm
Location: Dominican Republic

Re: Vicidial Deactivate Campaign Automatically by Specified

Postby justasking » Thu Sep 10, 2015 3:05 pm

omarrodriguezt wrote:Hello,
If you are not familiar with scripts, you can hire someone to help you like @William, or official vicidial sales@vicidial. com or create a Job Post in:
Jobs - Requests for Consultation
This is the forum used by people to post job openings or requests for quotes or consultations


Thank you for that.

If I have a spare time, I'll try to learn scripting.
Vicidial version is VERSION: 2.6-395a BUILD: 130221-1736 and our Asterisk version is 1.4.44-vici build 13 (1 DB, 1 WEB, 3 Telephony)
justasking
 
Posts: 43
Joined: Tue Sep 08, 2015 10:26 pm


Return to Support

Who is online

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