Error Recording Values

[Guest amandavs]

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

[Guest amandavs]

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!

[SupportTeam]

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.