Call Log Issues

[ahaggard]

Hello,

 

I need some flexibility to design call log reports and print them out. Specifically, I would like to have the following:

 

Date Caller Name Caller Number GetNumbersCode Duration of Call

 

 

I then need totals of all minutes by date of caller time on system. Finally, I would like to run monthly time totals for all calls. Can I do this?

 

Thanks

[SupportTeam]

Some simple customization is required to create this (takes less then 5 minutes)...

 

To have VoiceGuide save "Date Caller Name Caller Number GetNumbersCode Duration of Call" in a file readable by Excel:

 

Create a new script which has just one module - a Run Program type module and have it run this command (specify all on one line):

 

command.com /c echo $RV_DD, $RV_MM, $RV_CIDNAME, $RV_CIDNUMBER, $RV[GetNumbersCode], $RV_CALLLENGTH >> c:\CallLog$RV_YY$RV_MM.csv

 

Then specify this script to be the "Script to run when call is finished". (See the Edit->Script Properties menu in the Script Designer)

 

That’s it…

 

 

The file c:\CallLogYYMM.csv can then be opened in Excel and the number of seconds for each call will be visible in the column "F".

Note that we have indicated that each month the information will be saved in a differently named file - so when the month is finished just open the right file eg: November 2003 will be C:\CallLog0311.csv and then just sum the numbers in Column F to give you the total for this month...

 

 

You can get more complicated and save data in a database and then have it generate reports (or use Crystal Reports) etc, but the principle is the same - save what you want to save from the "Script to run when call is finished" script...

[ahaggard]

Well, I did exactly this and it doesn't cut the call log. The debug shows that it goes to the script, but no log.

[SupportTeam]

Can you poast the Trace Log please?

 

I just tried it here and it worked fine, here is the log:

 

141450.53 16 callstate IDLE 65946 0 0

141450.53 16 WorkingMode@Idle=

141450.53 16 TimeoutClear

141450.55 16 After Hangup script:[C:\Projects\vg32\Scripts\Voicemail Server\LogStuff.vgs]

141450.55  0 Script Load C:\Projects\vg32\Scripts\Voicemail Server\LogStuff.vgs

141450.55 16 Loaded VbsAtHangup into:1

141450.55 16 TimeoutClear

141450.55 16 [Run Program 7] Run Program

141450.55 16 RVreplace start (strlen>100)

141450.56 16 RVreplace end: [command.com /c echo 12, 08, , , , 20 >> c:\Log0308.csv]

141450.56 16 running:[command.com /c echo 12, 08, , , , 20 >> c:\Log0308.csv] WindowMode:[NormalFocus]

141450.69 16 Run Program continuing...

 

The command used was:

 

command.com /c echo $RV_DD, $RV_MM, $RV_CIDNAME, $RV_CIDNUMBER, $RV[GetNumbersCode], $RV_CALLLENGTH >> c:\Log$RV_YY$RV_MM.csv

 

and the file c:\Log0308.csv was created with the right data in it...

[ahaggard]

Here's the log. I probably have something set up wrong. You'll need to give any additional settings to me as I am not an expert.

 

Thanks

 

 

175838.86 6 linedevstate 2048 0 0

175838.89 6 callstate OFFERING 66083 0 4

175838.91 6 Lev_CallerID [9725672583,WIRELESS CALLER]

175838.92 6 callinfo CALLEDID

175838.92 6 callinfo ORIGIN

175838.92 6 ring 0

175844.86 6 ring 2

175844.86 6 Answer the call at 8/12/2003 5:58:44 PM

175844.86 6 lineAnswer(66083) => 66066

175845.41 6 callstate CONNECTED 66083,1,0

175845.41 6 WorkingModeTAPI=

175845.41 6 WorkingModeScript=

175845.42 6 Inband detection not enabled

175845.44 6 StartLoadedVgs at 8/12/2003 5:58:45 PM

175845.44 6 tapi Reply 66066 0

175845.44 6 [Welcome to DNP] Playing

175845.44 6 [Welcome to DNP] Playing (C:\WINNT\data\VmWelc\Main_Greeting.wav)

175845.48 6 PlaySoundStart ok [C:\WINNT\data\VmWelc\Main_Greeting.wav]

175845.48 6 RunModule PLAY end

175847.53 6 dtmf 1 (49,2)

175847.53 6 LsPlayMsg 1

175848.55 6 PlaySoundStop ok

175848.56 6 [Get3Numbers] Number Input

175848.56 6 [Get3Numbers] Playing (C:\WINNT\data\VmWelc\Get_Numbers.wav)

175848.58 6 PlaySoundStart ok [C:\WINNT\data\VmWelc\Get_Numbers.wav]

175850.64 6 dtmf 4 (52,2)

175850.64 6 LsGetNbrsPlayWelcMsg 4

175851.66 6 PlaySoundStop ok

175851.66 6 [Get3Numbers] Number Input 4

175851.66 6 dtmf 5 (53,2)

175851.66 6 LsGetNbrsRxDigits 5

175851.66 6 [Get3Numbers] Number Input 45

175851.91 6 dtmf 0 (48,2)

175851.91 6 LsGetNbrsRxDigits 0

175851.91 6 [Get3Numbers] Number Input 450

175851.91 6 [GetAdCode] Number Input

175851.91 6 [GetAdCode] Playing ()

175851.91 6 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED

175852.44 6 dtmf 8 (56,2)

175852.44 6 LsGetNbrsRxDigits 8

175852.44 6 [GetAdCode] Number Input 8

175852.44 6 [LogEnteredCode] Evaluate ["$RV[Get3Numbers]$RV[GetAdCode]"]

175852.44 6 RVreplace start: ["$RV[Get3Numbers]$RV[GetAdCode]"]

175852.44 6 RVreplace end: ["4508"]

175852.44 6 .Eval(Cstr("4508"))

175852.47 6 Eval Expr result:[4508] stored in $RV[4DigitCode]

175852.47 6 RVreplace start: [on {true} goto [Voicemail Box $RV[Get3Numbers]]

]

175852.47 6 RVreplace end: [on {true} goto [Voicemail Box 450]

]

175852.47 6 RVreplace start: [Voicemail Box $RV[Get3Numbers]]

175852.47 6 RVreplace end: [Voicemail Box 450]

175852.48 0 Script Load C:\WINNT\system\vm\VmLm.vgs

175852.56 6 Loaded C:\WINNT\system\vm\VmLm.vgs into:2

175852.58 6 [VmLmStart] Running vb script:[VmLmHangup.vgs]

175906.11 0 Script Load C:\WINNT\system\vm\VmLmHangup.vgs

175906.13 6 Loaded VbsAtHangup into:3

175906.13 6 tapi Reply 66049 0

175906.14 6 [VmLmHangup_ForwardLastMsg] Running VB Script...

175906.14 6 RVreplace start (strlen>100)

175906.16 6 VBScript Run continuing...

175906.16 6 Hanging up call... [Run module : no success path defined]

175906.16 6 HangupCall_Common Mode=AfterHangupRun

175906.16 6 ReinitTelephony due to IDLE start

175906.16 6 tapic lineDeallocateCall(MainCall:66083) 0

175906.27 6 lineOpen(6) => 0

175906.27 6 Waiting for a call...

175906.27 6 lineOpen(6)LineHandle=66032

175906.28 6 cl Vm_ForwardMsg 6, 450, C:\WINNT\data\VmSave\450_0812175857_1_6_9725672583_.wav

175906.28 6 vm frwrd vmb 450

175906.28 6 vm frwrd 450->999

175906.30 6 vm copy C:\WINNT\data\VmSave\450_0812175857_1_6_9725672583_.wav -> C:\WINNT\data\VmSave\999_0812175857_1_6_9725672583_.wav

175906.31 6 vm frwrd vmb 999

175906.31 6 RVreplace start (strlen>100)

175906.31 6 RVreplace end: [From WIRELESS CALLER, 9725672583, 450, 8 at 17:59 8/12]

[SupportTeam]

I see that the call was hung up in a Voicemail script...

 

So the caller was in a different script to that which had the logging script set up as the "Script to run when call is finished" script...

 

To ensure that calls that hangup while in the voicemail script also log information to the special log file, the logging module will need to be added to the script which is the "Script to run when call is finished" for the voicemail script...

 

The voicemail script used was C:\WINNT\system\vm\VmLm.vgs (you can see this when you read the trace log..)

If you open that script and look at it's properties you will see that it has set script "VmLmHangup.vgs" as it's "Script to run when call is finished" script.

 

So "VmLmHangup.vgs" needs to be edited to also log information to the special log file...

 

I've modified one as a demo- you can use the attached file to replace the VmLmHangup.vgs on your machine (in C:\WINNT\system\vm\VmLmHangup.vgs).

 

 

Basically it all boils down to ensuring that whichever script is being ran, that scripts "Script to run when call is finished" script will log the information at hangup...

[SupportTeam]

here is that new VmLmHangup.vgs

VmLmHangup.vgs

[ahaggard]

Sounds good. However, I need a VGS type file - not the HTML provided. Thanks..

[ahaggard]

Forget my last post....I did a copy and paste with the old file and converted it. It does work now...thanks a lot for the script. The only odd thing is that it truncates the log file name to 8 characters. Any idea why?

[SupportTeam]

The posted file was a .vgs file - as the description shows..

 

Left clicking on the link will just show contents of the file in a new window...

 

The save the file to local hard disk you need to right-click on the link and select "Save Target As..."

 

The filename will be truncated to 8 characters as the command is ran in a DOS window - DOS only allows 8 character filenames...

[Guest Robert]

Hello i want this to

 

Date Caller Name Caller Number GetNumbersCode Duration of Call.

 

but i want it to have in microsoft access.

 

can you give me a script for it.

 

thanks robert

[jimpeduto]

We are trying to insert the data into an Access database named response. We are using the database module. The table that should accept the data is named calls. This is the statement that we wrote (actually we stripped out everything just to try to make the connection: INSERT INTO Calls (Phone) VALUES ('$RV[GetPhoneNumber]'). I am sure the path is correct but the database is not being updated. Where have we gone wrong?

[SupportTeam]

Could you please post a copy of VoiceGuide's Debug Printout which captures the problem, this will allow us to see what is going wrong.

 

(When running the script click on VoiceGuide's View menu and select 'Event Trace Log' option - any log information will then appear in this window. You must open the trace window before making the call.)

[jimpeduto]

I can establish a connection with the database but as you can see from the log the rv are blank. Where is my error?

 

174354.42 0 Tapi device 3 is: Analog Line 4(dxxxB1C4)

174354.44 0 Tapi device 2 is: Analog Line 3(dxxxB1C3)

174354.44 0 Tapi device 1 is: Analog Line 2(dxxxB1C2)

174354.45 0 Tapi device 0 is: Analog Line 1(dxxxB1C1)

174354.53 0 Inband Signaling Config file not specified

174354.54 0 Loading VMB data begin

174354.56 0 Loading VMB data - about to delete old entries

174354.58 0 Loading VMB data - sorting/ordering

174354.59 0 Loading VMB data end

174354.67 0 Initialising...

174354.68 1 Initialising...

174354.68 2 Initialising...

174354.69 3 Initialising...

174354.69 0 Script Load C:\Program Files\VoiceGuide\Scripts\Employment\Job Line.vgs

174354.77 0 Calling .lineOpen on device 1

174354.85 0 Calling .GetLineHandle on LineId 0

174354.85 0 hLine=11939448

174354.85 0 Calling .GetProviderInfo on LineId 0

174354.87 0 Line 0 Provider: D41MT.TSP: Dialogic D41 Service Provider

174354.87 0 Calling lineSetNumRings on lLineHandle 11939448

174354.88 0 Waiting for a call...

174354.88 0 Calling .lineOpen on device 2

174354.95 0 Calling .GetLineHandle on LineId 1

174354.95 1 hLine=11939224

174354.95 0 Calling .GetProviderInfo on LineId 1

174354.95 1 Line 1 Provider: D41MT.TSP: Dialogic D41 Service Provider

174354.96 0 Calling lineSetNumRings on lLineHandle 11939224

174354.96 1 Waiting for a call...

174354.96 0 Calling .lineOpen on device 3

174355.04 0 Calling .GetLineHandle on LineId 2

174355.04 2 hLine=11940736

174355.04 0 Calling .GetProviderInfo on LineId 2

174355.04 2 Line 2 Provider: D41MT.TSP: Dialogic D41 Service Provider

174355.04 0 Calling lineSetNumRings on lLineHandle 11940736

174355.04 2 Waiting for a call...

174355.04 0 Calling .lineOpen on device 4

174355.11 0 Calling .GetLineHandle on LineId 3

174355.11 3 hLine=11939000

174355.11 0 Calling .GetProviderInfo on LineId 3

174355.13 3 Line 3 Provider: D41MT.TSP: Dialogic D41 Service Provider

174355.13 0 Calling lineSetNumRings on lLineHandle 11939000

174355.13 3 Waiting for a call...

174422.58 0 linedevstate 2048 0 0

174422.59 0 callstate OFFERING 11940016 0 4

174422.59 0 callinfo CALLEDID

174422.59 0 callinfo ORIGIN

174422.59 0 ring 0

174422.59 0 Answer the call at 10/27/03 5:44:22 PM

174422.59 0 lineAnswer(11940016) => 1

174423.14 0 callstate CONNECTED 11940016,1,0

174423.14 0 WorkingModeTAPI@Connected=

174423.14 0 WorkingModeScript@Connected=

174423.15 0 Inband detection not enabled

174423.15 0 StartLoadedVgs at 10/27/03 5:44:23 PM

174423.16 0 tapi Reply (LineEvReply) ok 1 0

174423.16 0 [Welcome] Playing

174423.16 0 [Welcome] Playing (Welcome.wav)

174423.20 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Welcome.wav]

174423.20 0 RunModule PLAY end

174440.09 0 wb(85817400)

174441.10 0 Play End line[0] (id=858174)

174441.10 0 LsPlayMsg EV_PLAY_FINISHED

174441.10 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

174441.13 0 [say Your Name Preface] Playing

174441.13 0 [say Your Name Preface] Playing (Say Your Name Preface.wav)

174441.15 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Say Your Name Preface.wav]

174441.15 0 RunModule PLAY end

174444.89 0 wb(87614000)

174445.90 0 Play End line[0] (id=876140)

174445.90 0 LsPlayMsg EV_PLAY_FINISHED

174445.90 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

174445.93 0 [Name] Recording

174445.95 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\system\voice\beep1.wav]

174446.15 0 wb(88094700)

174447.15 0 Play End line[0] (id=880947)

174447.15 0 LsRecPlayBeep EV_PLAY_FINISHED

174447.16 0 RVreplace start: [$RV_CIDNUMBER_$RV_CIDNAME_$RV_MM$RV_DD_$RV_HH$RV_NN$RV_SS.wav]

174447.16 0 RVreplace end: [__1027_174447.wav]

174447.17 0 RecSoundStart file[C:\Program Files\VoiceGuide\Scripts\Employment\__1027_174447.wav] ok

174447.17 0 RecFile[C:\Program Files\VoiceGuide\Scripts\Employment\__1027_174447.wav]

174448.07 0 LsRecRecording EV_TIMEOUT_GOTOMODULE

174449.07 0 RecSoundStop ok

174449.07 0 Name_RecLen100ms = 8

174449.10 0 [PhoneNumber] Number Input

174449.10 0 [PhoneNumber] Playing (Enter Phone Number.wav)

174449.12 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Enter Phone Number.wav]

174454.82 0 wb(88411100)

174455.83 0 Play End line[0] (id=884111)

174455.83 0 LsGetNbrsPlayWelcMsg EV_PLAY_FINISHED

174455.89 0 dtmf 6 (11940016,54,2)

174455.89 0 LsGetNbrsRxDigits 6

174455.89 0 [PhoneNumber] Number Input 6

174455.89 0 path {6} not found

174456.27 0 dtmf 6 (11940016,54,2)

174456.28 0 LsGetNbrsRxDigits 6

174456.28 0 [PhoneNumber] Number Input 66

174456.28 0 path {66} not found

174456.33 0 sys cleanup Start

174456.33 0 sys cleanup End

174456.66 0 dtmf 6 (11940016,54,2)

174456.66 0 LsGetNbrsRxDigits 6

174456.66 0 [PhoneNumber] Number Input 666

174456.66 0 path {666} not found

174458.32 0 dtmf 1 (11940016,49,2)

174458.32 0 LsGetNbrsRxDigits 1

174458.34 0 [PhoneNumber] Number Input 6661

174458.34 0 path {6661} not found

174458.71 0 dtmf 2 (11940016,50,2)

174458.71 0 LsGetNbrsRxDigits 2

174458.71 0 [PhoneNumber] Number Input 66612

174458.71 0 path {66612} not found

174459.10 0 dtmf 3 (11940016,51,2)

174459.10 0 LsGetNbrsRxDigits 3

174459.10 0 [PhoneNumber] Number Input 666123

174459.11 0 path {666123} not found

174459.48 0 dtmf 4 (11940016,52,2)

174459.48 0 LsGetNbrsRxDigits 4

174459.48 0 [PhoneNumber] Number Input 6661234

174459.48 0 path {6661234} not found

174500.77 0 dtmf 5 (11940016,53,2)

174500.77 0 LsGetNbrsRxDigits 5

174500.77 0 [PhoneNumber] Number Input 66612345

174500.77 0 path {66612345} not found

174501.27 0 dtmf 6 (11940016,54,2)

174501.27 0 LsGetNbrsRxDigits 6

174501.27 0 [PhoneNumber] Number Input 666123456

174501.27 0 path {666123456} not found

174501.65 0 dtmf 7 (11940016,55,2)

174501.65 0 LsGetNbrsRxDigits 7

174501.65 0 [PhoneNumber] Number Input 6661234567

174501.65 0 path {6661234567} not found

174501.66 0 path {6661234567} not found

174501.66 0 [CurrentAssociate] Playing

174501.66 0 [CurrentAssociate] Playing (Current Associate.wav)

174501.67 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Current Associate.wav]

174501.68 0 RunModule PLAY end

174502.07 0 dtmf 8 (11940016,56,2)

174502.08 0 LsPlayMsg 8

174502.08 0 path {8} not found

174504.26 0 dtmf 1 (11940016,49,2)

174504.26 0 LsPlayMsg 1

174505.27 0 PlaySoundStop ok

174505.29 0 [PastAssociate] Playing

174505.30 0 [PastAssociate] Playing (Past Associate.wav)

174505.30 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Past Associate.wav]

174505.32 0 RunModule PLAY end

174507.07 0 dtmf 1 (11940016,49,2)

174507.07 0 LsPlayMsg 1

174508.07 0 PlaySoundStop ok

174508.11 0 [Age] Playing

174508.11 0 [Age] Playing (18 or older.wav)

174508.13 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\18 or older.wav]

174508.13 0 RunModule PLAY end

174509.88 0 dtmf 1 (11940016,49,2)

174509.89 0 LsPlayMsg 1

174510.89 0 PlaySoundStop ok

174510.92 0 [Felony] Playing

174510.92 0 [Felony] Playing (Felony.wav)

174510.94 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Felony.wav]

174510.94 0 RunModule PLAY end

174512.96 0 dtmf 1 (11940016,49,2)

174512.96 0 LsPlayMsg 1

174513.98 0 PlaySoundStop ok

174513.00 0 [Transport] Playing

174513.00 0 [Transport] Playing (Transportation.wav)

174514.02 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Transportation.wav]

174514.02 0 RunModule PLAY end

174515.78 0 dtmf 1 (11940016,49,2)

174515.78 0 LsPlayMsg 1

174516.78 0 PlaySoundStop ok

174516.81 0 [Region] Playing

174516.81 0 [Region] Playing (Region.wav)

174516.83 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Region.wav]

174516.83 0 RunModule PLAY end

174518.46 0 dtmf 1 (11940016,49,2)

174518.46 0 LsPlayMsg 1

174519.48 0 PlaySoundStop ok

174519.50 0 [interviewTime] Playing

174519.50 0 [interviewTime] Playing (Call Back Time.wav)

174519.54 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Call Back Time.wav]

174519.54 0 RunModule PLAY end

174521.41 0 dtmf 1 (11940016,49,2)

174521.41 0 LsPlayMsg 1

174522.41 0 PlaySoundStop ok

174522.44 0 [Thank You] Playing

174522.45 0 [Thank You] Playing (Thank You No.wav)

174522.46 0 PlaySoundStart ok [C:\Program Files\VoiceGuide\Scripts\Employment\Thank You No.wav]

174522.46 0 RunModule PLAY end

174527.53 0 wb(91745900)

174528.53 0 Play End line[0] (id=917459)

174528.53 0 LsPlayMsg EV_PLAY_FINISHED

174528.53 0 LsPlayMsgFinished EV_TIMEOUT_GOTOMODULE

174528.55 0 [updateDatabase] DB Query

174528.55 0 Jet mode used (To use ODBC mode specify ODBC Connect string)

174528.64 0 RVreplace start: [iNSERT INTO Calls (Phone, Age) VALUES ('$RV[GetPhoneNumber]', '$RV[GetAge]')]

174528.64 0 RVreplace end: [iNSERT INTO Calls (Phone, Age) VALUES ('', '')]

174528.64 0 About to execute Action Query

174528.66 0 Hanging up call... [Hangup Module]

174528.66 0 RecSoundStop ok

174528.66 0 PlaySoundStop ok

174528.66 0 fnHangupCall end

174528.70 0 linedevstate 2048 0 0

174528.70 0 callstate IDLE 11940016 0 0

174528.70 0 WorkingMode@Idle=

174528.71 0 After Hangup script:[C:\Program Files\VoiceGuide\Scripts\Employment\Update Db.vgs]

174528.71 0 Script Load C:\Program Files\VoiceGuide\Scripts\Employment\Update Db.vgs

174528.72 0 Loaded VbsAtHangup into:2

174528.72 0 [updateDatabase_1] DB Query

174528.72 0 tapi Reply (LineEvReply) ok 2 0

174528.72 0 Jet mode used (To use ODBC mode specify ODBC Connect string)

174528.75 0 RVreplace start: [iNSERT INTO Calls (Felony) VALUES ('$RV[GetFelony]')]

174528.75 0 RVreplace end: [iNSERT INTO Calls (Felony) VALUES ('')]

174528.75 0 About to execute Action Query

174528.76 0 Hanging up call... [srlib 282]

174528.76 0 HangupCall_Common Mode=AfterHangupRun

174528.76 0 ReinitTelephony due to IDLE start

174528.77 0 tapic lineDeallocateCall(MainCall:11940016) 0

174528.86 0 lineOpen(0) => 0

174528.86 0 Waiting for a call...

174528.86 0 lineOpen(0)LineHandle=11940944

[SupportTeam]

I see that in the SQL query a Result Variable $RV[GetPhoneNumber] is used, but this RV has not been defined at during the call by any module, and is not the title of any prevuiously executed module in the script...

 

I see that there is however a module called [PhoneNumber] .... I suspect you should be using $RV[PhoneNumber] in the SQL query

 

similarly $RV[GetAge] should be $RV[Age]

and $RV[GetFelony] should be $RV[Felony]

[Guest joostica]

Hello i want to have a call log every day.

 

at the time at 16.00 houres

 

command.com /c echo $RV_DD, $RV_MM, $RV_CIDNAME, $RV_CIDNUMBER, $RV[GetNumbersCode], $RV_CALLLENGTH >> c:\CallLog$RV_YY$RV_MM.csv

 

 

can you help me

 

thanks joost

[SupportTeam]

The question above was not a continuation of the thread and as such was split into a new thread. Plz see:

http://voiceguide.com/forums/index.php?showtopic=872