Voiceguide V7

[Guest eva]

Hi,

 

We just upgraded our VoiceGuide v6 to v7. As we notice, there're some new functionality.

 

Firstly, it uses SQL instead of Ms Access. We would like to be able to access the data in CallQue table. Is it possible to access the table from Ms Access via ODBC? If yes, could you give us the DNS setting?

 

Secondly, when VG dials out a number and it's busy (not answered) or it's retries exhausted, we would like to send the information into a Ms Access table. Do you have the example of the script to do this?

 

Thirdly, how do we set up so that the VG automatically runs when the server is rebooted?

 

Thank you.

 

 

Regards,

Eva

[SupportTeam]

We would like to be able to access the data in CallQue table.

Please read: http://www.voiceguide.com/vghelp/source/ht...rnal_config.htm

 

If you want to use an alternative outbound calls DB then we'd recommend looking at SQL Server (the free Express version can be used) or MySQL.

 

when VG dials out a number and it's busy (not answered) or it's retries exhausted, we would like to send the information into a Ms Access table.

v7 lets you run a VBScript when either of this happens. Here is an example which shows how to save data in MSAccess from vb script:

 

Set MyConn = CreateObject("ADODB.Connection")

MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myData\aps.mdb"

MyConn.Execute "INSERT INTO APs (BSSID, SSID, MaxSNR) VALUES ('" & BSSID & "', '" & SSID & "', '" & MaxSNR & ")"

MyConn.Close

 

 

Thirdly, how do we set up so that the VG automatically runs when the server is rebooted?

v7 functions as a Windows Service. It already runs automatically when system is rebooted.

[Guest eva]

Thank you.

 

We have another question. When the VoiceGuide call a number, the called number does ring but when we answer the phone, around about 2 seconds, VG hung up the call without playing the recording.

 

Could us please? We have attached the logs.

 

Thank you.

 

 

Regards,

Eva

vg_logs.zip

[SupportTeam]

Which call in the attached traces should we be looking at?

 

In the second trace there was a call:

 

142955.066 6 1 state Dialing 18310755279666...

 

which Dialogic card said got answered:

 

143008.019 18 1 ev Dialogic 133,TDX_CALLP, crn=20000005, 10,3,0,TDX_CALLP,CR_CNCT,CON_PVD

 

but the VoiceGuide hung up as the specified script to use did not exist:

 

143008.019 6 1 WARN cannot find full path to script [M:\Customer_Files\vg_voiceonly\vgonly-live.vgs] or [M:\Customer_Files\vg_voiceonly\vgonly-live.vgp] or [vgonly-live.vgs] or [vgonly-

...

143009.019 6 1 state Hanging up call... [LsWaitAfterDialingOut]

[Guest eva]

Hi,

 

There are two numbers we use to test, one is a landline and the other one is a mobile phone. Both are having the same issue.

 

I have checked the path of .vgs file and it does exist. Is there something that might cause VG can't find the vgs file?

 

Thank you.

 

 

Regards,

Eva

[Guest eva]

Hi,

 

One more question. Somehow, the VG is failed to access the database. We use the same script that works on v6 and it doesn't work on v7. Please find below is the log. Did we do something wrong when we configure v7?

 

 

100122.843 6 1 state [Checkclient] DB Query

100122.843 6 1 rv replace start: [sELECT fldvbcode, fldcontactemail FROM qryseccode WHERE cust_vbpassword_092445734='$RV[Entercode]']

100122.843 6 1 rvns: [PathSysVoice]{C:\VoiceGuide\system\voice\}[PathApp]{C:\VoiceGuide\}[PathDataVm]{C:\VoiceGuide\data\}[PathVgSys]{C:\VoiceGuide\system\}[scriptPath]{C:\ATScript\TComp001\}[scriptsPath]{C:\ATScript\TComp001\}[$RV_STARTTIME]{2009-01-09 10:01:14}[$RV_DEVICEID]{1}[DlgcVoice]{dxxxB1C1}[DlgcNetwork]{dxxxB1C1}[$RV_CIDNAME]{}[PathApp]{C:\VoiceGuide\}[scriptsPath]{C:\ATScript\TComp001\}[$RV_CIDNUMBER]{}[EnterCode]{414727880}[EnterCode_PathTaken]{success}

100122.859 6 1 rv replace end: [sELECT fldvbcode, fldcontactemail FROM qryseccode WHERE cust_vbpassword_092445734=414727880]

100122.859 6 1 db strDatabaseName=[m:\Voicedata\LeadProg-Data.mdb] strDbConnectString=[] sAdoNetFactoriesAvailable=[|System.Data.Odbc|System.Data.OleDb|System.Data.Oracl

eClient|System.Data.SqlClient|VistaDB.NET20|]

100122.859 6 1 db using ado.net OleDb data provider: OleDbConnection/OleDbCommand/etc

100122.859 6 1 t set 20 EV_TIMEOUT_GOTOMODULE

100122.859 6 1 strDirOfDb=m:\Voicedata, keeping strDatabaseName: m:\Voicedata\LeadProg-Data.mdb

100122.859 6 1 db oledb RunQuery_OleDb Checkclient, m:\Voicedata\LeadProg-Data.mdb, , SELECT fldvbcode, fldcontactemail FROM qryseccode WHERE cust_vbpassword_092445734='414727880'

100122.875 6 1 ERROR v7.0.3252.36547 (Wed 26/11/2008 20:18:14.16) vbsDBQuery_Run : Object reference not set to an instance of an object.

 

at ..(String strIn, String strSection)

at ..(Int32 iLineId_In, String strModuleTitle, String strOleDbName, String strOleDbConnectString, String strSQL)

100144.656 20 1 timer fired EV_TIMEOUT_GOTOMODULE

 

 

 

Thank you.

 

Regards,

Eva

[SupportTeam]

Is the M:\ drive a networked drive?

Please try placing the scripts that VoiceGuide uses on the same drive as the VoiceGuide application and see if that makes a difference.

Aloe please download and update to this version: [old link removed] and post traces from this version if you still encounter any issues with the database.