VoiceGuide IVR Software Main Page
Jump to content

Dialout History

Recommended Posts

Hi,

 

tasks inserted to callque table.

 

Where or how can we know retries history?

 

 

Share this post


Link to post

The calltrack table should hold information on when a call was made.

 

There should be a "dialed@HHMMSS" entry in the "history" column of the calltrack table for each dial attempt made for that loaded call.

Share this post


Link to post

Could you please .ZIP up and post the vgEngine trace file that captures system startup and the outgoing call?

Share this post


Link to post

vgEngine trace shows that the SQL calls to update the CallTrack table are being issued :

    Line 3382: 102024.083   9  92  30       ct    calltrack_set ID=61083, guid=179a5d95-3942-45e1-9cfa-e53076805424
    Line 3384: 102024.083   9  92  30       ct    calltrack_set sql UPDATE calltrack SET History='dialed@102024|', TimeLastCall='2017-06-16 10:20:24', RetriesLeft=2 WHERE (QueID=61083 OR QueGUID=@guidDialoutGuid);
    Line 3386: 102024.086  14               db    Db_UpdateCallTrack call: UPDATE calltrack SET History='dialed@102024|', TimeLastCall='2017-06-16 10:20:24', RetriesLeft=2 WHERE (QueID=61083 OR QueGUID=@guidDialoutGuid);
    Line 3391: 102024.088  14               db    Db_UpdateCallTrack returned
    Line 3488: 102034.527   9  92  30       ct    calltrack_set ID=61083, guid=179a5d95-3942-45e1-9cfa-e53076805424
    Line 3489: 102034.527   9  92  30       ct    calltrack_set sql UPDATE calltrack SET Outcome='Answered_Live', History='dialed@102024|Answered_Live@102034|', TimeCallAnswered='2017-06-16 10:20:34', RetriesLeft=2 WHERE (QueID=61083 OR QueGUID=@guidDialoutGuid);
    Line 3490: 102034.527  14               db    Db_UpdateCallTrack call: UPDATE calltrack SET Outcome='Answered_Live', History='dialed@102024|Answered_Live@102034|', TimeCallAnswered='2017-06-16 10:20:34', RetriesLeft=2 WHERE (QueID=61083 OR QueGUID=@guidDialoutGuid);
    Line 3494: 102034.529  14               db    Db_UpdateCallTrack returned

are you seeing the CallTracktable being updated as per SQL above?

 

 

It looks like this system was set up to use a Postgresql database engine.

 

How are the new calls inserted? Are your perhaps inserting the calls yourself directly into the PortToUse and CallQue tables?

 

When inserting the calls yourself directly into the PortToUse and CallQue tables then a corresponding entry must also be created in the CallTrack table.

 

Please use the Outbound Call Loader to load some calls and see how the CallTrack table needs to be populated.

Share this post


Link to post

If you are inserting the calls yourself directly into the PortToUse and CallQue tables (instead of using VoiceGuide's Outbound Call Loader, or XML File method, or APIs) then here are some notes on inserting rows into the CallTrack table:

 

After inserting a row into the CallQue table the value of the autogenerated ID field needs to be retrieved and the value of that ID field should be used in the CallTrack.QueID
field when inserting related rows into the CallTrack table.

An alternative approach: instead of placing the CallQue.ID in the CallTrack.QueID column would be to use a GUID to link the CallQue entries to the CallTrack entry.
Just generate a GUID and write the same GUID into the CallTrack.QueGUID column and into the CallQue.GUID column.

Share this post


Link to post

Can You send outcome status list?

 

What is number after @ sign

 

history: dialed@132137|Disconnected@132228|NotAnswered_Disconnected@132228|

 

How to detect mobile voicemail as answer?

Share this post


Link to post

Can You send sql query to insert data to calltrack table?

 

Please try using the Outbound Call Loader (or XML File etc) to have VoiceGuide load some calls, and see how the CallTrack table is populated. It's a pretty straightforward table.

 

These columns should be set when loading new entries: QueID, QueGUID, the four Contact fields, CampaignName, TimeLoaded, RetriesLeft, RetriesDelay, InReport

 

 

What is number after @ sign

 

Hours (24 hour format), minutes and seconds of when the event before the @ occurred.

 

 

How to detect mobile voicemail as answer?

 

If the 'Answering Machine' entry is not set to 'RETRY' then an answer by a voicemail/answering machine will be treated as an answered call.

 

Please see: http://www.voiceguide.com/vghelp/source/html/detectcallanswer.htm

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×