If Hangup In Script Then...

[Guest thomasvanderhoof]

I have loaded telephone numbers to be called for suspensions notices of a service. I would like to have the customer verify that they got the message by pressing 1. If they don't then readd it to the dialer list. If they hang up in the script, I also would like it to add the number back to the dialer list. Is there a way to perform this. It would be great is there was a module that would delete the number from the dialer list. That way I could accomplish what I would like VG to do.

 

I would like to do this:

 

customer answers -> Script plays (first module would add the dialed number back to the dialer list, so that way it will call again if script doesn't complete or if the customer does not press 1. If customer presses 1, then it would send it to the delete module which will delete the just added "dialed number" from the dialer list. That way they will not be called again if they press 1.)

 

I know I can add it back to the dialer list with "Send Voice Message to Telephone" module, but I do not know how to remove that number if they press 1. Is there a way to accomplish this. It would be very helpful.

Thank you,

thomas

[SupportTeam]

but I do not know how to remove that number if they press 1. Is there a way to accomplish this. It would be very helpful.

The approach would be to specify a unique Result Variable when inserting the call.

 

Then if you wish to delete that entry just use the "DB Query" module and run something like this against the OutDialQue database:

 

DELETE from CallQue WHERE RV LIKE '%{MyRvName}[MyRvalue]%'

 

or just use the dialed number and delete any calls that would dial the same number:

 

DELETE from CallQue WHERE PhoneNumber = $RV_CALLEDNUMBER

 

When loading the number of call you may need to use Dialer_OutDialQueAdd COm command as that lets you specify the activation time of call. If loading call using the Send Phone Message module the call may be made immediately if there is a free line available.

[Guest thomasvanderhoof]

I've tried the method of deleting the called number. I've included the log file. I get a data type mismatch in log. I thought I did everything right, but I guess not.

Thank you,

Thomas

 

 

 

 

115249.86 6 dial [295,5191000,602081114,701,2300,MoTuWeThFrSaSu,,dxxxB1C2,,3,NONE,C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs,IGNORE,none,30,100,30,,none]

115249.86 6 rv clear

115249.86 6 dial callque update id=295 next call time 0602081222

115249.86 6 dial callque DB update returned

115249.86 6 amchk set AMdet=False in DialOnLine

115249.86 6 dial found entry: tel[5191000] ann[NONE] vgs[C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs] am[iGNORE] LineSelection:[,dxxxB1C2,]

115249.86 6 Dialing: 5191000

115249.86 6 MakeCall => 65727

115249.86 6 script interpretor: VgMulti v5.2.5003

115249.86 6 timer set 30 EV_TIMEOUT_MAKECALL_NORESPONSE

115249.86 6 TapiCbTrigSet 65727 7002

115249.88 0 dial start any summary:|5:idx=0|6:dial=0|7:idx=0|8:idx=0|

115250.47 6 tapi Reply (LineEvReply) ok 65727 0

115250.47 6 TapiCbTrigClear

115250.47 6 linedevstate 2048 0 0

115250.48 6 callstate DIALTONE 65675 0 0

115250.48 6 callstate DIALING 65675 0 0

115250.48 6 callstate PROCEEDING 65675 0 0

115250.48 6 callinfo CALLEDID

115250.48 6 callinfo REASON

115250.48 6 ev Lev_CallerID [2542471458,,5191000]

115250.48 6 rv lg add [DNIS]{5191000}

115250.50 6 callinfo ORIGIN

115250.91 0 dial start any summary:|5:idx=0|6:hc>0|7:idx=0|8:idx=0|

115302.47 6 callstate CONNECTED 65675 1 0

115302.47 6 callstate CONNECTED 65675,1,0

115302.47 6 WorkingModeTAPI@Connected=

115302.47 6 WorkingModeScript@Connected=

115302.47 6 rv lg add [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}

115302.47 6 rv lg add [PathApp]{C:\Program Files\VoiceGuide\}

115302.48 6 rv lg add [PathDataVm]{C:\Program Files\VoiceGuide\data\}

115302.48 6 rv lg add [PathVgSys]{C:\Program Files\VoiceGuide\system\}

115302.48 6 rv lg add [OutDial_RetriesLeft]{100}

115302.48 6 rv lg add [$RV_STARTTIME]{08-Feb-06 11:53 AM}

115302.48 6 rv lg add [$RV_DEVICEID]{6}

115302.48 6 rv lg add [$RV_CIDNAME]{NOBLE PHONE SER}

115302.48 6 rv ns add [PathApp]{C:\Program Files\VoiceGuide\}

115302.48 6 rv lg add [$RV_CALLEDNUMBER]{5191000}

115302.48 6 rv lg add [$RV_DNIS]{5191000}

115302.50 6 rv lg add [DNIS]{5191000}

115302.50 0 dial callque delete id=295

115302.50 6 rv ns add [OutDial_Result]{Contacted_Human}

115302.50 6 Live person answered, starting C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs

115302.50 2 tr NewVgsVgm_Goto C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs,,,,,0

115302.50 6 rv lg add [scriptEnd_Time]{08-Feb-06 11:53 AM}

115302.50 6 rv lg add [scriptEnd_Goto_Script]{C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs}

115302.52 6 rv lg add [scriptEnd_Goto_Module]{}

115302.52 6 rv lg add [scriptStart_Time]{08-Feb-06 11:53 AM}

115302.52 6 rv lg add [scriptStart_CalledFrom_Module]{DeleteFromCallQue}

115302.52 0 LoadedVgs_Find C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs at idx=2

115302.52 6 rv ns add [scriptsPath]{C:\Program Files\VoiceGuide\Scripts\}

115302.52 6 eng StartModuleDefault=[AddNumberToQue]

115302.52 6 timer clear

115302.52 6 [AddNumberToQue] Running VB Script...

115302.52 6 rv replace start (strlen>500)

115302.53 6 rv ns none[PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[OutDial_RetriesLeft]{100}[OutDial_Result]{Contacted_Human}[scriptEnd_Time

{08-Feb-06 11:53 AM}[scriptEnd_Goto_Script]{C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs}[scriptEnd_Goto_Module]{}[scriptStart_Time]{08-Feb-06 11:53 AM}[scriptStart_CalledFrom_Module]{DeleteFromCallQue}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\}

115302.53 6 eng run vbs [wscript "C:\Program Files\VoiceGuide\temp\vbs_6_1_0208115302.vbs" //I] copy of script in: vbs_6_1_0208115302.vbs

115302.56 6 VBScript Run continuing...

115302.58 6 timer clear

115302.58 6 [suspensionMessage] Number Input

115302.58 6 [suspensionMessage] Playing (SuspensionMessage.wav)

115302.58 6 play set playid=958515

115302.59 6 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.wav]

115302.59 6 timer clear

115302.59 6 wa(33475,95851500)

115302.59 6 callinfo MONITORMODES

115302.61 0 cl Dialer_OutDialQueAdd 5191000, 602081223, 800, 2100, , dxxB1C1, 1, none, C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs, IGNORE, [FNAME]{5191000}, 40, 100, 30, ,

115302.61 0 dial DialListDB_AddCall '5191000', 602081223, 800, 2100, MoTuWeThFrSaSu, dxxB1C1, 1, none, C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs, IGNORE, [FNAME]{5191000}, 40, 100, 30, ESCALATION:

115302.63 0 sql INSERT INTO CallQue (PhoneNumber, ActivateTime, DayTimeStart, DayTimeStop, DaysCallAllowed, LineSelection, Priority, AnnounceMessage, Script, OnAnswerMachine, RV, AnswerTimeout, CallRetriesLeft, DelayBetweenRetries, OnNotConnected, EscalationCalls) VALUES ('5191000', 602081223, 800, 2100, 'MoTuWeThFrSaSu', ',dxxB1C1,', 1, 'none', 'C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs', 'IGNORE', '[FNAME]{5191000}', '40', '100', '30', '', 'none')

115304.83 6 dtmf 1 (65675,49,2)

115304.84 6 ScriptEventCode 49 iLineState=1300

115304.84 6 LsGetNbrsPlayWelcMsg 1

115304.89 6 PlaySoundStop err=0

115304.89 6 [suspensionMessage] Number Input 1

115304.89 6 rv lg add [suspensionMessage]{1}

115304.89 6 rv ns add [suspensionMessage_PathTaken]{1}

115304.91 6 timer clear

115304.91 6 [CustomerSupport] Send Email

115304.91 6 rv replace start: [suspension Message to $RV_CALLEDNUMBER

on $RV_DATE $RV_MONTHNAME at $RV_HH:$RV_NN:$RV_SS has been received and understood.]

115304.91 6 rv ns none[PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[OutDial_RetriesLeft]{100}[OutDial_Result]{Contacted_Human}[scriptEnd_Time

{08-Feb-06 11:53 AM}[scriptEnd_Goto_Script]{C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs}[scriptEnd_Goto_Module]{}[scriptStart_Time]{08-Feb-06 11:53 AM}[scriptStart_CalledFrom_Module]{DeleteFromCallQue}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\}[suspensionMessage]{1}[suspensionMessage_PathTaken]{1}

115304.91 6 rv replace end: [suspension Message to 5191000

on 8 February at 11:53:04 has been received and understood.]

115304.91 6 rv lg add [CustomerSupport]{2549032030@archwireless.net,thomasvanderhoof@gmail.com}

115304.91 6 rv lg add [CustomerSupport_Subject]{}

115304.92 6 rv lg add [CustomerSupport_Message]{Suspension Message to 5191000on 8 February at 11:53:04 has been received and understood.}

115304.92 6 rv lg add [CustomerSupport_Attachment]{}

115304.92 6 rv lg add [CustomerSupport_Cc]{}

115304.92 6 rv lg add [CustomerSupport_Bcc]{}

115304.92 6 email que to: 2549032030@archwireless.net,thomasvanderhoof@gmail.com

115304.92 0 sql INSERT INTO MsgQue (ToAddress, ToName, ReturnAddress, ReturnName, CcAddress, CcName, BccAddress, BccName, ReplyAddress, MsgSubject, MsgMessage, MsgAttachment, MsgAttachmentDeleteAfterSend, gw1_SmtpServ, gw1_UseAuthentication, gw1_UsePopAuthentication, gw1_AuthUserName, gw1_AuthUserPassword, gw1_POP3Host, gw1_SMTPPort, gw2_SmtpServ, gw2_UseAuthentication, gw2_UsePopAuthentication, gw2_AuthUserName, gw2_AuthUserPassword, gw2_POP3Host, gw2_SMTPPort, SendTime, SendRetriesLeft, SendDelayBetweenRetries) VALUES ('2549032030@archwireless.net,thomasvanderhoof@gmail.com', '2549032030@archwireless.net,thomasvanderhoof@gmail.com', 'd@c.com', '', '', '', '', '', 'd@c.com', '', 'Suspension Message to 5191000

on 8 February at 11:53:04 has been received and understood.', '', 0, 'ErasedforSecurity', 1, 0, 'ErasedforSecurity', 'ErasedforSecurity', '', 0, 'ErasedforSecurity', 1, 0, 'ErasedforSecurity', 'ErasedforSecurity', '', 0, 0, 3, 10)

115304.94 6 rv lg add [CustomerSupport_SendResult]{OK}

115304.94 6 timer clear

115304.94 6 [DeleteFromCallQue] DB Query

115304.94 6 db Jet mode used (To use ODBC mode specify ODBC Connect string)

115304.95 6 rv replace start: [DELETE from CallQue WHERE PhoneNumber = $RV_CALLEDNUMBER]

115304.95 6 rv ns none[PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[OutDial_RetriesLeft]{100}[OutDial_Result]{Contacted_Human}[scriptEnd_Time

{08-Feb-06 11:53 AM}[scriptEnd_Goto_Script]{C:\Program Files\VoiceGuide\Scripts\SuspensionMessage.vgs}[scriptEnd_Goto_Module]{}[scriptStart_Time]{08-Feb-06 11:53 AM}[scriptStart_CalledFrom_Module]{DeleteFromCallQue}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\}[suspensionMessage]{1}[suspensionMessage_PathTaken]{1}[CustomerSupport]{'ErasedforSecurity','ErasedforSecurity'}[CustomerSupport_Subject]{}[CustomerSupport_Message]{Suspension Message to 5191000on 8 February at 11:53:04 has been received and understood.}[CustomerSupport_Attachment]{}[CustomerSupport_Cc]{}[CustomerSupport

Bcc]{}[CustomerSupport_SendResult]{OK}

115304.95 6 rv replace end: [DELETE from CallQue WHERE PhoneNumber = 5191000]

115304.95 6 db About to execute a Modify type operation [DELETE from CallQue WHERE PhoneNumber = 5191000]

115304.95 6 ERROR 5.2.5003 DB Execute: 3464,Data type mismatch in criteria expression.

115304.95 6 rv lg add [DeleteFromCallQue_RowCount]{0}

115304.95 6 db DBEngine.Error nbr:[3464] desc:[Data type mismatch in criteria expression.] src:[DAO.Database]

115304.97 6 path {0} not found

115304.97 6 path {} not found

115304.97 6 rv lg add [Hangup Time]{08-Feb-06 11:53 AM}

115304.97 6 Hanging up call... [GoNextVgm_Boolean fail]

115304.97 6 RecSoundStop ok

115304.97 6 PlaySoundStop err=0

115304.97 6 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP

115304.97 6 fnHangupCall end

115305.02 6 linedevstate 2048 0 0

115305.02 6 callstate IDLE 65675 0 0

115305.02 6 WorkingMode@Idle=

115305.02 6 timer clear

115305.03 6 timer set 1 EV_TIMEOUT_TIMETOREINITLINE

115305.03 6 tapi Reply (LineEvReply) ok 65608 0

115306.03 6 timer fired EV_TIMEOUT_TIMETOREINITLINE

115306.03 6 ScriptEventCode 9008 iLineState=900

115306.03 6 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

115306.03 6 ReinitTelephony due to IDLE

115306.03 6 tapic lineDeallocateCall(MainCall:65675) 0

115306.09 6 lineOpen(6)=>

115306.09 6 Waiting for a call...

115306.09 6 LineHandle=66018

115306.09 6 amchk set AMdet=False in Reinit@idle

115306.09 6 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT

115306.14 0 dial start any summary:|5:idx=0|6:rdy=0|7:idx=0|8:idx=0|

115309.39 6 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT

115309.39 6 ScriptEventCode 9013 iLineState=900

115310.23 0 dial start any summary:|5:idx=0|6:idx=0|7:idx=0|8:idx=0|

[Guest thomasvanderhoof]

I answered my own question for the last post. I'm not sure if this will mess up any other part of VoiceGuide, but I changed the Data Type of PhoneNumber from Text to number, and the script works. Can you please let me know if this is ok to do.

Thank you,

thomas

[Guest thomasvanderhoof]

I have just found that this change is not ok because it messes up the Send Voice Message Module. I used the $RV_CALLEDNUMBER to add to the que list, so I imagine that it is converted to Text format. But to delete from the que list, I cannot just use the variable $RV_CALLEDNUMBER because it's not converted to Text format with the Query Database module. Any help with this would be appreciated.

Thank you,

Thomas

[SupportTeam]

PhoneNumber is a Text filed, so this will work:

 

DELETE from CallQue WHERE PhoneNumber = "5191000"

 

Similarly, although this will NOT work:

 

DELETE from CallQue WHERE PhoneNumber = $RV_CALLEDNUMBER

 

This will work:

 

DELETE from CallQue WHERE PhoneNumber = "$RV_CALLEDNUMBER"

[Guest thomasvanderhoof]

Is this common knowledge or is it aquired by only asking you guys because I feel bad bother you over something so simple. Thanks for all of your help.

Thomas

[SupportTeam]

Constructing SQL statements to match the database is not strictly VoiceGuide related. But as the database in question is part of VoiceGuide system we can assist in such questions.