Jump to content


< Back to Forum


 

Dialout History


  • Please log in to reply

#1 Maciej 04 April 2017 - 09:50 PM

Hi,

 

tasks inserted to callque table.

 

Where or how can we know retries history?

 

 



#2 SupportTeam 04 April 2017 - 10:04 PM

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.



#3 Maciej 05 April 2017 - 12:04 AM

Sorry in calltrack table no data. How to activate inserting attmpts?



#4 SupportTeam 05 April 2017 - 12:18 AM

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



#5 Maciej 16 June 2017 - 06:33 PM

today's test

  • Attached File  log.zip   357.15KB   15 downloads


#6 Maciej 16 June 2017 - 06:37 PM

now only today's log

  • Attached File  log.zip   79.37KB   14 downloads


#7 SupportTeam 16 June 2017 - 08:10 PM

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.



#8 SupportTeam 16 June 2017 - 08:29 PM

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.



#9 Maciej 16 June 2017 - 09:12 PM

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



#10 Maciej 16 June 2017 - 09:31 PM

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?



#11 SupportTeam 16 June 2017 - 11:34 PM

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.voiceguid...tcallanswer.htm