Guest thomasvanderhoof Report post Posted 02/06/2006 10:48 PM 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 Share this post Link to post
SupportTeam Report post Posted 02/06/2006 11:04 PM 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. Share this post Link to post
Guest thomasvanderhoof Report post Posted 02/08/2006 06:08 PM 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| Share this post Link to post
Guest thomasvanderhoof Report post Posted 02/08/2006 08:56 PM 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 Share this post Link to post
Guest thomasvanderhoof Report post Posted 02/08/2006 09:28 PM 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 Share this post Link to post
SupportTeam Report post Posted 02/08/2006 10:07 PM 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" Share this post Link to post
Guest thomasvanderhoof Report post Posted 02/08/2006 10:18 PM 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 Share this post Link to post
SupportTeam Report post Posted 02/08/2006 10:45 PM 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. Share this post Link to post