Search Callers Details In Database

[health4us]

1\ I am trying to stop voice guide calling more people when I am already speaking to a live person on the same line - is there anyway of stopping voice guide from calling if I am on the phone using the same phone line already as at the moment it tries to dial out when I am already on the phone which is a little annoying.... what I am doing is picking the phone up when voice guide plays a message to say that someone live has answered the call but then find it tries and calls someone else...

 

 

2\ Is there anyway to get voice guide to open up Access and do a search for the callers details so that when I have a live call I also have the clients details in front of me?

 

3\ Has anyone tried to use Voice Guide with ACT2000 contact management?

Where do you get the ODBC drivers?

 

If you could help/examples would be appreciated as at the moment it is a little slow in getting ready for the off..

 

Thanks

Matt Thompson

[SupportTeam]

1\ I am trying to stop voice guide calling more people when I am already speaking to a live person on the same line - is there anyway of stopping voice guide from calling

You will need to click the "Allow VoiceGuide to dial out on this line" check box (to deselect it). See the View menu, Line Device Config option.

 

2\ Is there anyway to get voice guide to open up Access and do a search for the callers details so that when I have a live call I also have the clients details in front of me?

Sure - just have a DB Query module as the first module of the script which VoiceGuide is to run after a call has been answered by a live person, have it retrieve the details you need and pop them up using a "msgbox" command from a Run VBScript module ( see the Call Recorder sample script in v5.0 of VG)

 

3\ Has anyone tried to use Voice Guide with ACT2000 contact management?

Where do you get the ODBC drivers?

ACT2000 should provide the ODBC drivers for it's database. Once these are installed VoiceGuide can then retrieve information from the ACT database using normal SQL queries.

 

For examples of SQL queries please see the VoiceGuide Help files's sections on DB Query module.

[SupportTeam]

Matt Thompson wrote:

 

Thanks for the reply I am totally confused as surely if I select the option

to stop voiceguide to call out then it will never call anyone so I think you

must have misunderstood that when I am ringing people I am making voice

guide play a sound when a live person answers the phone - at this stage I

pick up the phone and take over but I want voice guide to automatically stop

calling more people whilst I am on the line but don't want to have to fiddle

with voice guide etc manually on each call as this will take my mind of the

call.. is there no way voice guide can have this written into the call

script so once I pick up voice guide is shut down or stops calling?

 

2\ Sure - just have a DB Query module as the first module of the script

which VoiceGuide is to run after a call has been answered by a live person,

have it retrieve the details you need and pop them up using a "msgbox"

command from a Run VBScript module ( see the Call Recorder sample script in

v5.0 of VG)

 

I understand this but is there no way of actually opening

ACCESS up and finding the record in ACCESS so i am in the right place to

update Access??

[SupportTeam]

If you do not want to manually click the "Allow VoiceGuide to dial out on this line" check box then another option would be to create a script which after playing a sound files over the PC speaker (when a live person answers) it just then waits (use a long "Timeout" path)...

 

VoiceGuide will then stay on the line - (e: not make any other calls on the same line) and will hang up when it hears the buys tone when the call is finished.

 

(instead of it just waiting for end of call you can probably put VoiceGuide to better use by having it record the conversation...)

 

I understand this but is there no way of actually opening ACCESS up and finding the record in ACCESS so i am in the right place to update Access??

This can be done as well - you will need to figure out what keys would need to be pressed on your computer to bring up the right database entry - and you can then have a "Run VBScript" module 'press' these keys using the VBScript SendKeys function. Please consult VBScript Documentation for info on how to use SendKeys...

 

A short example on how the VB Script module can be sued to start other applications and then SendKeys to them is in the Help file:

 

Example 8:

The VB Script below sends keystrokes to another application running on the PC. eg: to start the Windows Calculator and make it add 1+2 the following script would be used:

 

set WshShell = WScript.CreateObject("WScript.Shell")

WshShell.Run "calc"    

WScript.Sleep 100

WshShell.AppActivate "Calculator"

WScript.Sleep 200

WshShell.SendKeys "1{+}2~"

 

More info on using the SendKeys function can be found at:

 

http://msdn.microsoft.com/library/default....mthsendkeys.asp

[health4us]

1. I tried the VBS box but it did not write to screen the info from my

database for some reason and only wrote to the screen the phone number i called. I have attached the debug printout for you to look at as requested.

I have also add the script.

 

 

092606.48 0 dial callque update id=623 next call time 0308121126

092606.48 6 dial found entry: tel[1051661180060] ann[NONE] vgs[D:\telephone\scripts\recruiting\trial3\write to screen.vgs] am[D:\telephone\scripts\recruiting\trial3\Answer-Machine.vgs]

092606.48 6 Dialing: 1051661180060

092606.48 6 MakeCall => 65767

092606.48 6 TapiCbTrigSet 65767 7002

092607.27 6 tapi Reply 65767 0

092607.27 6 TapiCbTrigClear

092607.27 6 linedevstate 2048 0 0

092607.27 6 callstate DIALTONE 65904 0 0

092607.27 6 callstate DIALING 65904 0 0

092607.27 6 callstate PROCEEDING 65904 0 0

092607.27 6 callinfo CALLEDID

092607.27 6 callinfo REASON

092607.27 6 Lev_CallerID [08712770002,]

092607.27 6 callinfo ORIGIN

092616.31 6 callstate CONNECTED 65904,1,0

092616.32 6 WorkingModeTAPI=

092616.32 6 WorkingModeScript=

092616.33 0 dial callque delete id=623

092616.37 6 Live person answered, starting D:\telephone\scripts\recruiting\trial3\write to screen.vgs

092616.37 2 tr NewVgsVgm_Goto D:\telephone\scripts\recruiting\trial3\write to screen.vgs,,,,,0

092616.37 0 Script Load D:\telephone\scripts\recruiting\trial3\write to screen.vgs

092616.37 6 Loaded D:\telephone\scripts\recruiting\trial3\write to screen.vgs into:2

092616.38 6 cl NewVgsVgm_RunModule module not found:

092616.38 2 tr NewVgsVgm_Goto 1

092616.38 2 tr NewVgsVgm_Goto 2

092616.38 6 [Database Query 10] DB Query

092616.38 6 Jet mode used (To use ODBC mode specify ODBC Connect string)

092616.40 6 RVreplace start (strlen>100)

092616.40 6 About to execute Retrieve Operation [sELECT Title, Name, Surname, CallStatus, LeadSource, CallersName, ScriptURL, CallSubject, UkPhoneNumber FROM NamesList WHERE PhoneNumber=1051661180060]

092616.44 6 [Database Query 10] row count=1

092616.44 6 [Popup] Running VB Script...

092616.44 6 RVreplace start (strlen>100)

092616.88 6 Run Script waiting... (shellid=4968, process=788)

092616.88 2 tr NewVgsVgm_Goto end

092617.79 6 task still running (shellid=4968, process=788)

092618.80 6 task still running (shellid=4968, process=788)

092619.80 6 task still running (shellid=4968, process=788)

092620.81 6 task still running (shellid=4968, process=788)

092621.81 6 task still running (shellid=4968, process=788)

092622.81 6 task still running (shellid=4968, process=788)

092623.81 6 task still running (shellid=4968, process=788)

092624.81 6 task still running (shellid=4968, process=788)

092625.45 6 callstate DISCONNECTED 65904,0,0

092625.45 6 LsRunWaitTillFinished EV_REMOTEPARTY_DISCONNECT

092625.45 6 Hanging up call...

092625.45 6 RecSoundStop ok

092625.45 6 PlaySoundStop ok

092625.45 6 fnHangupCall end

092625.49 6 linedevstate 2048 0 0

092625.49 6 callstate IDLE 65904 0 0

092625.49 6 WorkingMode@Idle=

092625.77 6 tapi Reply 65699 0

092626.66 6 LsAwaitingCalls EV_TIMEOUT_TIMETOREINITLINE

092626.66 6 ReinitTelephony due to IDLE start

092626.66 6 tapic lineDeallocateCall(MainCall:65904) 0

092626.82 6 lineOpen(6) => 0

092626.82 6 Waiting for a call...

092626.82 6 lineOpen(6)LineHandle=65835

write_to_screen.vgs

[SupportTeam]

The script has a module named [Database Query 10] which does the database query, so the Result Variables which would be used to access the results returned by this module would be:

 

$RV[Database Query 10_1_1]

$RV[Database Query 10_2_1]

$RV[Database Query 10_3_1]

$RV[Database Query 10_4_1]

$RV[Database Query 10_5_1]

etc... etc... for each of the fields retured from the database....

 

From VG Help file's section on DB Query module:

 

Query Results

The results of the database query are accessible using Result Variables. The following Result Variables can be used to access data retrieved by a Db Query module:

 

ModuleTitle_ColumnIndex_RowIndex

 

If more then one item was requested in the query, the Column Index can be used to access the individual items in each retrieved row.

 

eg: module LookupTelFax uses a query: SELECT Tel, Fax FROM Customer WHERE CustId='$RV[Get CustId]' . We can use $RV[LookupTelFax_1_1] to access the contents of the Tel column and use LookupTelFax_2_1 to access he contents of the Fax column for customer 1. We can use $RV[LookupTelFax_1_2] to access the contents of the Tel column for customer 2, etc.

 

 

I can see in the script that the query issued by [Database Query 10] is:

 

SELECT Title, Name, Surname, CallStatus, LeadSource, CallersName, ScriptURL, CallSubject, UkPhoneNumber FROM NamesList WHERE PhoneNumber='$RV_CALLEDNUMBER'

 

so for example to display the CallersName you should use: $RV[Database Query 10_6_1] - as it is the sixth field specified in the database query.

 

Of course if the title of the DB Query module gets changed then the Result Variables names need to be changed accordingly as well...