Guest amandavs Report post Posted 05/10/2006 08:12 PM We had some trouble earlier with recording the data to a Microsoft Access file. In attempting to trace whether or not the problem was with Voiceguide or Access, we added a Send Email test field to output the recorded values that were presenting problems to an email. The relevant code has been posted below. The phone call hangs up rather than completing the interview and the email message goes that one of the values is not picked up. Any insight? (note: the password on the email account has been deleted for privacy purposes in both the trace log and the .vgs file, the function still works correctly) Email Message: Question CONNECTEDquestion 3 B] Question 4: 4 *note - the script in send email reads in the message box: Question 3: $RV[bDI - question 3 B] Question 4: $RV[bDI - question 4 B] Trace Log: 160145.06 6 state [bDI - question 20] Playing 160145.06 6 state [bDI - question 20] Playing (BDI Q20.wav) 160145.08 6 play set playid=673718 160145.11 6 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\BDI Q20.wav] 160145.11 6 timer clear 160145.11 6 RunModule PLAY end 160145.13 6 callinfo MONITORMODES 160210.69 6 play end current play (playid=673718) 160210.69 6 ScriptEventCode 8001 iLineState=1100 160210.69 6 LsPlayMsg EV_PLAY_FINISHED 160210.70 6 timer set 10 EV_TIMEOUT_HANGUP 160210.70 6 timer set 0 EV_TIMEOUT_GOTOMODULE 160210.70 6 ScriptEventCode 9002 iLineState=1101 160210.70 6 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE 160210.72 6 rv lg add [bDI - question 20]{timeout} 160210.72 6 timer clear 160210.72 6 state [bDI - question 20 B] Playing 160210.72 6 state [bDI - question 20 B] Playing () 160210.73 6 ScriptEventCode 8001 iLineState=1100 160210.73 6 LsPlayMsg EV_PLAY_FINISHED 160210.73 6 eng set timer EV_TIMEOUT_REPLAYMSG time=5 160210.73 6 timer set 5 EV_TIMEOUT_REPLAYMSG 160210.75 6 RunModule PLAY end 160211.56 6 dtmf 4 (66184,52,2) 160211.56 6 ScriptEventCode 52 iLineState=1101 160211.56 6 LsPlayMsgFinished 4 160211.58 6 rv lg add [bDI - question 20 B]{4} 160211.58 6 timer clear 160211.58 6 state [Test] Send Email 160211.58 6 rv replace start: [Question 3: $RV[bDI - question 3 B] Question 4: $RV[bDI - question 4 B]] 160211.59 6 rv ns [PathSysVoice]{C:\Program Files\VoiceGuide\system\voice\}[PathApp]{C:\Program Files\VoiceGuide\}[PathDataVm]{C:\Program Files\VoiceGuide\data\}[PathVgSys]{C:\Program Files\VoiceGuide\system\}[DNIS]{0000}[scriptsPath]{C:\Program Files\VoiceGuide\Scripts\}[scriptPath]{C:\Program Files\VoiceGuide\Scripts}[$RV_STARTTIME]{5/10/2006 3:50:12 PM}[$RV_DEVICEID]{6}[$RV_CIDNAME]{}[PathApp]{C:\Program Files\VoiceGuide\}[$RV_CIDNUMBER]{9198438143}[$RV_DNIS]{0000}[DNIS]{0000}[Welcome]{1}[Welcome 2]{1}[iD]{1111}[iD_PathTaken]{success}[Parent/Child]{1}[Parent Instructions]{1}[Parent example question]{1}[if 1 is answer to example question]{1}[bDI - question 1]{timeout}[bDI - question 1 B]{1}[bDI - question 2]{timeout}[bDI - question 2 B]{2}[bDI - question 3]{timeout}[bDI - question 3 B]{3}[bDI - question 4]{timeout}[bDI - question 4 B]{4}[bDI - question 5]{timeout}[bDI - question 5 B]{1}[bDI - question 6]{timeout}[bDI - question 6 B]{2}[bDI - question 7]{timeout}[bDI - question 7 B]{3}[bDI - question 8]{timeout}[bDI - question 8 B]{4}[bDI - question 9]{timeout}[bDI - question 9 B]{1}[bDI - question 10]{timeout}[bDI - question 10 B]{2}[bDI - question 11]{timeout}[bDI - question 11 B]{3}[bDI - question 12]{timeout}[bDI - question 12 B]{4}[bDI - question 13]{timeout}[bDI - question 13 B]{1}[bDI - question 14]{timeout}[bDI - question 14 B]{2}[bDI - question 15]{timeout}[bDI - question 15 B]{3}[bDI - question 16]{timeout}[bDI - question 16 B]{4}[bDI - question 17]{timeout}[bDI - question 17 B]{1}[bDI - question 18]{timeout}[bDI - question 18 B]{2}[bDI - question 18b]{2}[bDI - question 19]{timeout}[bDI - question 19 B]{3}[bDI - question 20]{timeout}[bDI - question 20 B]{4} 160211.59 6 rv replace end: [Question CONNECTEDquestion 3 B] Question 4: 4] 160211.59 6 rv lg add [Test]{rlandoll@email.unc.edu} 160211.61 6 rv lg add [Test_Subject]{} 160211.61 6 rv lg add [Test_Message]{Question CONNECTEDquestion 3 B] Question 4: 4} 160211.61 6 rv lg add [Test_Attachment]{} 160211.61 6 rv lg add [Test_Cc]{} 160211.63 6 rv lg add [Test_Bcc]{} 160211.63 6 email que to: rlandoll@email.unc.edu 160211.63 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 ('rlandoll@email.unc.edu', 'rlandoll@email.unc.edu', '', '', '', '', '', '', '', '', 'Question CONNECTEDquestion 3 B] Question 4: 4', '', 0, 'smtp.unc.edu', 1, 0, 'rlandoll', 'password', '', 587, '', 0, 0, '', '', '', 0, 0, 3, 10) 160211.64 6 rv lg add [Test_SendResult]{OK} 160211.64 6 rv lg add [Hangup Time]{5/10/2006 4:02:11 PM} 160211.64 6 state Hanging up call... [No path found from Send Email module.] 160211.66 6 RecSoundStop ok 160211.67 6 PlaySoundStop err=0 160211.67 6 timer set 2 EV_TIMEOUT_WAITFORIDLEAFTERLINEDROP 160211.69 6 fnHangupCall end 160211.73 6 devstate NUMCALLS 0 0 160211.73 6 tapi callstate start 160211.73 6 tapi callstate IDLE 66184 0 0 160211.75 6 WorkingMode@Idle= 160211.75 6 timer clear 160211.75 6 timer set 1 EV_TIMEOUT_TIMETOREINITLINE 160211.77 6 tapi Reply (LineEvReply) ok 66150 0 160212.78 6 timer fired EV_TIMEOUT_TIMETOREINITLINE 160212.78 6 ScriptEventCode 9008 iLineState=900 160212.78 6 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE 160212.78 6 ReinitTelephony due to IDLE 160212.80 6 tapic lineDeallocateCall(MainCall:66184) 0 160212.89 6 lineOpen(6)=> 160212.89 6 state Waiting for a call... 160212.89 6 LineHandle=66133 160212.89 6 amchk set AMdet=False in Reinit@idle 160212.91 6 timer set 3 EV_TIMEOUT_ATERIDLE_ALLOWOUT 160213.39 0 dial start any summary:|6:rdy=0| 160216.19 6 timer fired EV_TIMEOUT_ATERIDLE_ALLOWOUT 160216.19 6 ScriptEventCode 9013 iLineState=900 160216.39 0 dial start any summary:|6:idx=0| Projectchat.vgs Share this post Link to post
Guest amandavs Report post Posted 05/11/2006 07:12 PM We figured out the problem in the last post - please disregard it. Now the error when we call in is "could not find output table". We have done the following things to try to save our data from voiceguide in Access: We used a database query module in our script, and filled it out like so: Database or ODBC data source: ProjectChat Connect String: ODBC;DRIVER={Microsoft Access Driver (*.mdb)} and then the SQL query, which begins: INSERT INTO ProjectChatLogParent (ID, BDIone, etc.) We set up a file in Access. The name of the file is ProjectChat. The name of the table we want to insert the data in is ProjectChatLogParent. Project Chat is listed as a data source in the ODBC data source administrator. Did I miss a step? Please help! Share this post Link to post
SupportTeam Report post Posted 05/11/2006 09:36 PM We figured out the problem in the last post What was causing the problem? How did you resolve it? You do not need to use ODBC for Access - just specify the Access Database's filename (with full path). You may want to try using SELECT SQL statements first to see if the connection got the DB is working, and then you know it's working then move onto more complicated SQL statements. Share this post Link to post