Guest Guest_zackrspv Report post Posted 02/15/2004 10:53 PM Hello. We sometimes have special orders at our store; currently we have it setup where the order is taken, payment is taken; and then customer leaves happy; and then associate updates the Orders.mdb database with the Persons Name, Order Details and Date/Time of Pickup if available. And then, when the order comes into the store, we have the dialer dial the persons number and play a script that tells the customer to press 1 to accept the message and 2 to reject the message; and then tells them who the call is for, what product was ordered and when it will be available for pickup. The problem here is all of this is automatic. Here is the current VGS script: Version=5.0 DefaultModuleDisplayHeight= StartModule=Main RunAtHangup= StartWithoutAnswer=0 CtmAsiName= [Main] Type=Play DispSize=69 Txt=Play a sound file, then await a response... PlayFile1=C:\Documents and Settings\Administrator\My Documents\vgs files\new\automatedcall.wav Replay=0,0 strTtsText= on {1} goto [Data] on {2} goto [Hangup the Call 109] Position=396,68 [Data] Type=Database Query DispSize=69 Txt=Search the database for data. You can then use the returned results later in your script (see Result Variables), eg: in the Say Number module or as parameters to the program calles in a Run Program module. DbDatabase=C:\Documents and Settings\Administrator\My Documents\orders.mdb DbUser= DbConnectString= DbSql=select name, order, date from Orders where an=1 on {success} goto [PlayData] Position=75,213 [Hangup the Call 109] Type=Hangup the Call DispSize=69 Txt=Hangup the call. Position=733,174 [PlayData] Type=Play DispSize=69 Txt=Play a sound file, then await a response... PlayFile1=C:\Documents and Settings\Administrator\My Documents\vgs files\new\messagefor.wav Replay=0,5 strTtsText= on {timeout 0} goto [PDName] Position=75,341 [PDName] Type=Play DispSize=69 Txt=Play a sound file, then await a response... Replay=0,5 strTtsText=$RV[Data_1_1] on {timeout 0} goto [PD2] Position=258,340 [PD2] Type=Play DispSize=69 Txt=Play a sound file, then await a response... PlayFile1=C:\Documents and Settings\Administrator\My Documents\vgs files\new\orderforthe.wav Replay=0,5 strTtsText= on {timeout 0} goto [PDOrder] Position=263,434 [PDOrder] Type=Play DispSize=69 Txt=Play a sound file, then await a response... Replay=0,5 strTtsText=$RV[Data_2_1] on {timeout 0} goto [PD3] Position=462,436 [PD3] Type=Play DispSize=69 Txt=Play a sound file, then await a response... PlayFile1=C:\Documents and Settings\Administrator\My Documents\vgs files\new\pikupon.wav Replay=0,5 strTtsText= on {timeout 0} goto [PDDate] Position=464,523 [PDDate] Type=Play DispSize=69 Txt=Play a sound file, then await a response... Replay=0,5 strTtsText=$RV[Data_3_1] on {timeout 0} goto [PD4] Position=660,524 [PD4] Type=Play DispSize=69 Txt=Play a sound file, then await a response... PlayFile1=C:\Documents and Settings\Administrator\My Documents\vgs files\new\finalorder.wav Replay=0,0 strTtsText= on {1} goto [Transfer Call 101] on {timeout 3} goto [Hangup the Call 109] on {*} goto [PlayData] Position=664,610 [Transfer Call 101] Type=Transfer Call DispSize=69 Txt=Transfer call to the selected extension. strXferDestExt=8998788 iXferType=0 sXfer2ndLegLinesListFile= sXferPlayWhileDialing= sXferAnnounceMsg= Position=716,312 Now, what we would like to happen is; yes, the associate still enters the data manually (this ensure data integrity) (and also helps because i have no idea how to work with the database that QuickBOoks POS uses) but we want the system to automatically dial when the date is within 3 business days. Is that possible? Share this post Link to post
Guest Guest_zackrspv Report post Posted 02/15/2004 10:54 PM Err typo; i said 'all of this is automatic' when i should have said 'all of this is NOT automatic' Share this post Link to post
SupportTeam Report post Posted 02/15/2004 11:33 PM You will need to use a "Run VB Script" module and VoiceGuide's COM function Dialer_OutDialQueAdd to schedule a call to be made in the future (the Send Phone Message module schedules call to be made immediately).The Dialer_OutDialQueAdd function is described in detail in VG Help file. Basically you need to specify the ActivateTime to be 3 days in future. ActivateTime is specified in format YMMDDHHNN. To obtain a date exactly 3 days in future you can use the following VB Script snippet: dDate = DateAdd("d", 3, Now) sYear = Right(Year(dDate), 1) sCallTime = sYear * 100000000 + Month(dDate) * 1000000 + Day(dDate) * 10000 + Hour(dDate) * 100 + Minute(dDate) and then you use sCallTime when calling Dialer_OutDialQueAdd You can hard code the hour and minute settings if you want the call to be made at a cetein time. eg to call at 10:30am the sCallTime formula would become: sCallTime = sYear * 100000000 + Month(dDate) * 1000000 + Day(dDate) * 10000 + 1030 Share this post Link to post
