vicidial.org

VICIDIAL astGUIclient discussion forum

Skip to content

Vicidial.org Home      Vicidial Forum      Vicidial Wiki      Vicidial Issue Tracker      astGUIclient Project Page


Inbound campaign behavior

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Post a reply

Inbound campaign behavior

Postby skiv » Thu Nov 30, 2006 3:55 pm

Hi All,
I'm investigating the Vicidial behavior on inbound campaigns,
What can I see is that when the call arrives the agi-inbound scripts automatically creates the new lead with the current incoming call information and this lead is furhter dispatched to the agent within the call.

As I see from now the agent can change the call disposition field of this lead using the hotkeys, and this disposition is propagated to the database, but I can't see that any other information entered in the forms in the vicidial CLOSER campaigns during the inbound call is propagated, the lead fealds remain NULL despite of my input.
I wonder if I missed something (e.g missed some setupm step), why I can't see any update actions in the code?

I'm going to proceed the code investigation and change the code enabling the lead in case if other fields were entered during the inbound call.
If this lead is really remains blank the other question is - what is the purpose of this empty inbound lead?

The third one is if the lead info upfateis propagated to the database and the second call is made by the same customer, does the script looks up the lead or not?

Thanks in advance,
Alex
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby mflorell » Thu Nov 30, 2006 4:56 pm

vicidial.php should be sending the information you type in the customer information fields and putting it in the vicidial_list table for that lead.

If you want to search the lead database first when a call comes in and you do receive callerID then you can use the lookupCID inbound AGI script.
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida
Top

Postby skiv » Fri Dec 01, 2006 8:15 am

Hi Matt, As I undersood from your post below, my vicidial dehaves incorrect, leaving the fields changed blank, so what could be the reason for this?
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby skiv » Fri Dec 01, 2006 8:38 am

BTW, my inbound connections are sip-based
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby mflorell » Fri Dec 01, 2006 2:22 pm

Which inbound script are you using?

Can you post agiout.2006-XX-XX output from when this script is called?
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida
Top

Logs

Postby skiv » Sun Dec 03, 2006 7:32 am

Hi Matt, I've tried several ones, here is one, let me know if you need more:

2006-12-03 13:52:08|call_log.agi|AGI Environment Dump:
2006-12-03 13:52:08|call_log.agi| -- accountcode =
2006-12-03 13:52:08|call_log.agi| -- callerid = unknown
2006-12-03 13:52:08|call_log.agi| -- calleridname = S0612011013158600051
2006-12-03 13:52:08|call_log.agi| -- callingani2 = 0
2006-12-03 13:52:08|call_log.agi| -- callingpres = 0
2006-12-03 13:52:08|call_log.agi| -- callingtns = 0
2006-12-03 13:52:08|call_log.agi| -- callington = 0
2006-12-03 13:52:08|call_log.agi| -- channel = SIP/skiv-091a14b8
2006-12-03 13:52:08|call_log.agi| -- context = default
2006-12-03 13:52:08|call_log.agi| -- dnid = unknown
2006-12-03 13:52:08|call_log.agi| -- enhanced = 0.0
2006-12-03 13:52:08|call_log.agi| -- extension = h
2006-12-03 13:52:08|call_log.agi| -- language = en
2006-12-03 13:52:08|call_log.agi| -- priority = 1
2006-12-03 13:52:08|call_log.agi| -- rdnis = unknown
2006-12-03 13:52:08|call_log.agi| -- request = call_log.agi
2006-12-03 13:52:08|call_log.agi| -- type = SIP
2006-12-03 13:52:08|call_log.agi| -- uniqueid = 1164957196.31
2006-12-03 13:52:08|call_log.agi|AGI Variables: |1164957196.31|SIP/skiv-091a14b8|h|SIP|S0612011013158600051|
2006-12-03 13:52:08|call_log.agi||CALL HUNG UP|
2006-12-03 13:52:08|call_log.agi||DELETE from live_inbound where uniqueid='1164957196.31' and server_ip='192.168.17.69'|
2006-12-03 13:52:08|call_log.agi|+++++ CALL LOG HUNGUP: |1164957196.31|SIP/skiv-091a14b8|h|2006-12-03 13:52:08|min: |
2006-12-03 13:52:09|VD_hangup.agi|Perl Environment Dump:
2006-12-03 13:52:09|VD_hangup.agi|0|PRI-----NODEBUG-----16---------------
2006-12-03 13:52:09|VD_hangup.agi|AGI Environment Dump:
2006-12-03 13:52:09|VD_hangup.agi| -- accountcode =
2006-12-03 13:52:09|VD_hangup.agi| -- callerid = unknown
2006-12-03 13:52:09|VD_hangup.agi| -- calleridname = S0612011013158600051
2006-12-03 13:52:09|VD_hangup.agi| -- callingani2 = 0
2006-12-03 13:52:09|VD_hangup.agi| -- callingpres = 0
2006-12-03 13:52:09|VD_hangup.agi| -- callingtns = 0
2006-12-03 13:52:09|VD_hangup.agi| -- callington = 0
2006-12-03 13:52:09|VD_hangup.agi| -- channel = SIP/skiv-091a14b8
2006-12-03 13:52:09|VD_hangup.agi| -- context = default
2006-12-03 13:52:09|VD_hangup.agi| -- dnid = unknown
2006-12-03 13:52:09|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 13:52:09|VD_hangup.agi| -- extension = h
2006-12-03 13:52:09|VD_hangup.agi| -- language = en
2006-12-03 13:52:09|VD_hangup.agi| -- priority = 2
2006-12-03 13:52:09|VD_hangup.agi| -- rdnis = unknown
2006-12-03 13:52:09|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 13:52:09|VD_hangup.agi| -- type = SIP
2006-12-03 13:52:09|VD_hangup.agi| -- uniqueid = 1164957196.31
2006-12-03 13:52:09|VD_hangup.agi|AGI Variables: |1164957196.31|SIP/skiv-091a14b8|h|SIP|S0612011013158600051|
2006-12-03 13:52:09|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 13:52:09|VD_hangup.agi|VD_hangup : S0612011013158600051 SIP/skiv-091a14b8 2 158600051
2006-12-03 13:52:09|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1164957196.31' limit 1;|
2006-12-03 13:52:09|VD_hangup.agi|VD hangup: no VDAC record found: 1164957196.31 S0612011013158600051
2006-12-03 15:07:09|call_log.agi|AGI Environment Dump:
2006-12-03 15:07:09|call_log.agi| -- accountcode =
2006-12-03 15:07:09|call_log.agi| -- callerid = unknown
2006-12-03 15:07:09|call_log.agi| -- calleridname = S0612031506458600051
2006-12-03 15:07:09|call_log.agi| -- callingani2 = 0
2006-12-03 15:07:09|call_log.agi| -- callingpres = 0
2006-12-03 15:07:09|call_log.agi| -- callingtns = 0
2006-12-03 15:07:09|call_log.agi| -- callington = 0
2006-12-03 15:07:09|call_log.agi| -- channel = SIP/skiv-091a14b8
2006-12-03 15:07:09|call_log.agi| -- context = default
2006-12-03 15:07:09|call_log.agi| -- dnid = unknown
2006-12-03 15:07:09|call_log.agi| -- enhanced = 0.0
2006-12-03 15:07:09|call_log.agi| -- extension = h
2006-12-03 15:07:09|call_log.agi| -- language = en
2006-12-03 15:07:09|call_log.agi| -- priority = 1
2006-12-03 15:07:09|call_log.agi| -- rdnis = unknown
2006-12-03 15:07:09|call_log.agi| -- request = call_log.agi
2006-12-03 15:07:09|call_log.agi| -- type = SIP
2006-12-03 15:07:09|call_log.agi| -- uniqueid = 1165147607.37
2006-12-03 15:07:09|call_log.agi|AGI Variables: |1165147607.37|SIP/skiv-091a14b8|h|SIP|S0612031506458600051|
2006-12-03 15:07:09|call_log.agi||CALL HUNG UP|
2006-12-03 15:07:09|call_log.agi||DELETE from live_inbound where uniqueid='1165147607.37' and server_ip='192.168.17.69'|
2006-12-03 15:07:09|call_log.agi|+++++ CALL LOG HUNGUP: |1165147607.37|SIP/skiv-091a14b8|h|2006-12-03 15:07:09|min: |
2006-12-03 15:07:10|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:07:10|VD_hangup.agi|0|PRI-----NODEBUG-----16---------------
2006-12-03 15:07:10|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:07:10|VD_hangup.agi| -- accountcode =
2006-12-03 15:07:10|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:07:10|VD_hangup.agi| -- calleridname = S0612031506458600051
2006-12-03 15:07:10|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:07:10|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:07:10|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:07:10|VD_hangup.agi| -- callington = 0
2006-12-03 15:07:10|VD_hangup.agi| -- channel = SIP/skiv-091a14b8
2006-12-03 15:07:10|VD_hangup.agi| -- context = default
2006-12-03 15:07:10|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:07:10|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:07:10|VD_hangup.agi| -- extension = h
2006-12-03 15:07:10|VD_hangup.agi| -- language = en
2006-12-03 15:07:10|VD_hangup.agi| -- priority = 2
2006-12-03 15:07:10|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:07:10|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:07:10|VD_hangup.agi| -- type = SIP
2006-12-03 15:07:10|VD_hangup.agi| -- uniqueid = 1165147607.37
2006-12-03 15:07:10|VD_hangup.agi|AGI Variables: |1165147607.37|SIP/skiv-091a14b8|h|SIP|S0612031506458600051|
2006-12-03 15:07:10|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:07:10|VD_hangup.agi|VD_hangup : S0612031506458600051 SIP/skiv-091a14b8 2 458600051
2006-12-03 15:07:10|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1165147607.37' limit 1;|
2006-12-03 15:07:10|VD_hangup.agi|VD hangup: no VDAC record found: 1165147607.37 S0612031506458600051
2006-12-03 15:07:10|call_log.agi|AGI Environment Dump:
2006-12-03 15:07:10|call_log.agi| -- accountcode =
2006-12-03 15:07:10|call_log.agi| -- callerid = unknown
2006-12-03 15:07:10|call_log.agi| -- calleridname = S0612011010138600051
2006-12-03 15:07:10|call_log.agi| -- callingani2 = 0
2006-12-03 15:07:10|call_log.agi| -- callingpres = 0
2006-12-03 15:07:10|call_log.agi| -- callingtns = 0
2006-12-03 15:07:10|call_log.agi| -- callington = 0
2006-12-03 15:07:10|call_log.agi| -- channel = SIP/skiv-09187a18
2006-12-03 15:07:10|call_log.agi| -- context = default
2006-12-03 15:07:10|call_log.agi| -- dnid = unknown
2006-12-03 15:07:10|call_log.agi| -- enhanced = 0.0
2006-12-03 15:07:10|call_log.agi| -- extension = h
2006-12-03 15:07:10|call_log.agi| -- language = en
2006-12-03 15:07:10|call_log.agi| -- priority = 1
2006-12-03 15:07:10|call_log.agi| -- rdnis = unknown
2006-12-03 15:07:10|call_log.agi| -- request = call_log.agi
2006-12-03 15:07:10|call_log.agi| -- type = SIP
2006-12-03 15:07:10|call_log.agi| -- uniqueid = 1164957014.28
2006-12-03 15:07:10|call_log.agi|AGI Variables: |1164957014.28|SIP/skiv-09187a18|h|SIP|S0612011010138600051|
2006-12-03 15:07:10|call_log.agi||CALL HUNG UP|
2006-12-03 15:07:10|call_log.agi||DELETE from live_inbound where uniqueid='1164957014.28' and server_ip='192.168.17.69'|
2006-12-03 15:07:10|call_log.agi|+++++ CALL LOG HUNGUP: |1164957014.28|SIP/skiv-09187a18|h|2006-12-03 15:07:10|min: |
2006-12-03 15:07:11|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:07:11|VD_hangup.agi|0|PRI-----NODEBUG-----16---------------
2006-12-03 15:07:11|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:07:11|VD_hangup.agi| -- accountcode =
2006-12-03 15:07:11|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:07:11|VD_hangup.agi| -- calleridname = S0612011010138600051
2006-12-03 15:07:11|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:07:11|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:07:11|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:07:11|VD_hangup.agi| -- callington = 0
2006-12-03 15:07:11|VD_hangup.agi| -- channel = SIP/skiv-09187a18
2006-12-03 15:07:11|VD_hangup.agi| -- context = default
2006-12-03 15:07:11|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:07:11|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:07:11|VD_hangup.agi| -- extension = h
2006-12-03 15:07:11|VD_hangup.agi| -- language = en
2006-12-03 15:07:11|VD_hangup.agi| -- priority = 2
2006-12-03 15:07:11|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:07:11|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:07:11|VD_hangup.agi| -- type = SIP
2006-12-03 15:07:11|VD_hangup.agi| -- uniqueid = 1164957014.28
2006-12-03 15:07:11|VD_hangup.agi|AGI Variables: |1164957014.28|SIP/skiv-09187a18|h|SIP|S0612011010138600051|
2006-12-03 15:07:11|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:07:11|VD_hangup.agi|VD_hangup : S0612011010138600051 SIP/skiv-09187a18 2 138600051
2006-12-03 15:07:11|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1164957014.28' limit 1;|
2006-12-03 15:07:11|VD_hangup.agi|VD hangup: no VDAC record found: 1164957014.28 S0612011010138600051
2006-12-03 15:07:32|call_log.agi|AGI Environment Dump:
2006-12-03 15:07:32|call_log.agi| -- accountcode =
2006-12-03 15:07:32|call_log.agi| -- callerid = unknown
2006-12-03 15:07:32|call_log.agi| -- calleridname = skiv
2006-12-03 15:07:32|call_log.agi| -- callingani2 = 0
2006-12-03 15:07:32|call_log.agi| -- callingpres = 0
2006-12-03 15:07:32|call_log.agi| -- callingtns = 0
2006-12-03 15:07:32|call_log.agi| -- callington = 0
2006-12-03 15:07:32|call_log.agi| -- channel = SIP/192.168.17.151-09197038
2006-12-03 15:07:32|call_log.agi| -- context = default
2006-12-03 15:07:32|call_log.agi| -- dnid = unknown
2006-12-03 15:07:32|call_log.agi| -- enhanced = 0.0
2006-12-03 15:07:32|call_log.agi| -- extension = s
2006-12-03 15:07:32|call_log.agi| -- language = en
2006-12-03 15:07:32|call_log.agi| -- priority = 2
2006-12-03 15:07:32|call_log.agi| -- rdnis = unknown
2006-12-03 15:07:32|call_log.agi| -- request = call_log.agi
2006-12-03 15:07:32|call_log.agi| -- type = SIP
2006-12-03 15:07:32|call_log.agi| -- uniqueid = 1165147652.40
2006-12-03 15:07:32|call_log.agi|AGI Variables: |1165147652.40|SIP/192.168.17.151-09197038|s|SIP|unknown|
2006-12-03 15:07:32|call_log.agi|+++++ CALL LOG START : 2006-12-03 15:07:32
2006-12-03 15:07:32|call_log.agi||INSERT INTO call_log (uniqueid,channel,channel_group,type,server_ip,extension,number_dialed,start_time,start_epoch,end_time,end_epoch,length_in_sec,length_in_min,caller_code) values('1165147652.40','SIP/192.168.17.151','','SIP','192.168.17.69','192.168.17.151','s','2006-12-03 15:07:32','1165147652','','','','','unknown')|
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi|Perl Environment Dump:
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi|0|SALESLINE-----8002277655-----Closer-----park----------101-----1
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- accountcode =
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- callerid = unknown
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- calleridname = skiv
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- callingani2 = 0
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- callingpres = 0
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- callingtns = 0
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- callington = 0
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- channel = SIP/192.168.17.151-09197038
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- context = default
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- dnid = unknown
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- enhanced = 0.0
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- extension = 8002277655
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- language = en
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- priority = 4
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- rdnis = unknown
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- request = agi-VDADcloser_inbound.agi
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- type = SIP
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi| -- uniqueid = 1165147652.40
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi|AGI Variables: |1165147652.40|SIP/192.168.17.151-09197038|8002277655|SIP|Closer|
2006-12-03 15:07:38|agi-VDADcloser_inbound.agi|interrupt_digit |0|
2006-12-03 15:07:43|call_log.agi|AGI Environment Dump:
2006-12-03 15:07:43|call_log.agi| -- accountcode =
2006-12-03 15:07:43|call_log.agi| -- callerid = unknown
2006-12-03 15:07:43|call_log.agi| -- calleridname = skiv
2006-12-03 15:07:43|call_log.agi| -- callingani2 = 0
2006-12-03 15:07:43|call_log.agi| -- callingpres = 0
2006-12-03 15:07:43|call_log.agi| -- callingtns = 0
2006-12-03 15:07:43|call_log.agi| -- callington = 0
2006-12-03 15:07:43|call_log.agi| -- channel = SIP/192.168.17.151-09197038
2006-12-03 15:07:43|call_log.agi| -- context = default
2006-12-03 15:07:43|call_log.agi| -- dnid = unknown
2006-12-03 15:07:43|call_log.agi| -- enhanced = 0.0
2006-12-03 15:07:43|call_log.agi| -- extension = h
2006-12-03 15:07:43|call_log.agi| -- language = en
2006-12-03 15:07:43|call_log.agi| -- priority = 1
2006-12-03 15:07:43|call_log.agi| -- rdnis = unknown
2006-12-03 15:07:43|call_log.agi| -- request = call_log.agi
2006-12-03 15:07:43|call_log.agi| -- type = SIP
2006-12-03 15:07:43|call_log.agi| -- uniqueid = 1165147652.40
2006-12-03 15:07:43|call_log.agi|AGI Variables: |1165147652.40|SIP/192.168.17.151-09197038|h|SIP|unknown|
2006-12-03 15:07:43|call_log.agi||CALL HUNG UP|
2006-12-03 15:07:43|call_log.agi||1165147652.4000001|1165147652|
2006-12-03 15:07:43|call_log.agi|QUERY done: start time = 1165147652 | sec: 11 | min: 0.18 |
2006-12-03 15:07:43|call_log.agi||UPDATE call_log set end_time='2006-12-03 15:07:43',end_epoch='1165147663',length_in_sec=11,length_in_min=' 0.18' where uniqueid='1165147652.40'|
2006-12-03 15:07:43|call_log.agi||DELETE from live_inbound where uniqueid='1165147652.40' and server_ip='192.168.17.69'|
2006-12-03 15:07:43|call_log.agi|+++++ CALL LOG HUNGUP: |1165147652.40|SIP/192.168.17.151-09197038|h|2006-12-03 15:07:43|min: 0.18|
2006-12-03 15:07:43|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:07:43|VD_hangup.agi|0|PRI-----NODEBUG-----0---------------
2006-12-03 15:07:43|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:07:43|VD_hangup.agi| -- accountcode =
2006-12-03 15:07:43|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:07:43|VD_hangup.agi| -- calleridname = skiv
2006-12-03 15:07:43|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:07:43|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:07:43|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:07:43|VD_hangup.agi| -- callington = 0
2006-12-03 15:07:43|VD_hangup.agi| -- channel = SIP/192.168.17.151-09197038
2006-12-03 15:07:43|VD_hangup.agi| -- context = default
2006-12-03 15:07:43|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:07:43|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:07:43|VD_hangup.agi| -- extension = h
2006-12-03 15:07:43|VD_hangup.agi| -- language = en
2006-12-03 15:07:43|VD_hangup.agi| -- priority = 2
2006-12-03 15:07:43|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:07:43|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:07:43|VD_hangup.agi| -- type = SIP
2006-12-03 15:07:43|VD_hangup.agi| -- uniqueid = 1165147652.40
2006-12-03 15:07:43|VD_hangup.agi|AGI Variables: |1165147652.40|SIP/192.168.17.151-09197038|h|SIP|unknown|
2006-12-03 15:07:43|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:07:43|VD_hangup.agi|VD_hangup : unknown SIP/192.168.17.151-09197038 2 0
2006-12-03 15:07:43|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1165147652.40' limit 1;|
2006-12-03 15:07:43|VD_hangup.agi|VD hangup: no VDAC record found: 1165147652.40 skiv
2006-12-03 15:30:10|call_log.agi|AGI Environment Dump:
2006-12-03 15:30:10|call_log.agi| -- accountcode =
2006-12-03 15:30:10|call_log.agi| -- callerid = unknown
2006-12-03 15:30:10|call_log.agi| -- calleridname = S0612031507158600051
2006-12-03 15:30:10|call_log.agi| -- callingani2 = 0
2006-12-03 15:30:10|call_log.agi| -- callingpres = 0
2006-12-03 15:30:10|call_log.agi| -- callingtns = 0
2006-12-03 15:30:10|call_log.agi| -- callington = 0
2006-12-03 15:30:10|call_log.agi| -- channel = SIP/skiv-09187a18
2006-12-03 15:30:10|call_log.agi| -- context = default
2006-12-03 15:30:10|call_log.agi| -- dnid = unknown
2006-12-03 15:30:10|call_log.agi| -- enhanced = 0.0
2006-12-03 15:30:10|call_log.agi| -- extension = h
2006-12-03 15:30:10|call_log.agi| -- language = en
2006-12-03 15:30:10|call_log.agi| -- priority = 1
2006-12-03 15:30:10|call_log.agi| -- rdnis = unknown
2006-12-03 15:30:10|call_log.agi| -- request = call_log.agi
2006-12-03 15:30:10|call_log.agi| -- type = SIP
2006-12-03 15:30:10|call_log.agi| -- uniqueid = 1165147636.38
2006-12-03 15:30:10|call_log.agi|AGI Variables: |1165147636.38|SIP/skiv-09187a18|h|SIP|S0612031507158600051|
2006-12-03 15:30:10|call_log.agi||CALL HUNG UP|
2006-12-03 15:30:10|call_log.agi||DELETE from live_inbound where uniqueid='1165147636.38' and server_ip='192.168.17.69'|
2006-12-03 15:30:10|call_log.agi|+++++ CALL LOG HUNGUP: |1165147636.38|SIP/skiv-09187a18|h|2006-12-03 15:30:10|min: |
2006-12-03 15:30:11|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:30:11|VD_hangup.agi|0|PRI-----NODEBUG-----16---------------
2006-12-03 15:30:11|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:30:11|VD_hangup.agi| -- accountcode =
2006-12-03 15:30:11|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:30:11|VD_hangup.agi| -- calleridname = S0612031507158600051
2006-12-03 15:30:11|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:30:11|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:30:11|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:30:11|VD_hangup.agi| -- callington = 0
2006-12-03 15:30:11|VD_hangup.agi| -- channel = SIP/skiv-09187a18
2006-12-03 15:30:11|VD_hangup.agi| -- context = default
2006-12-03 15:30:11|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:30:11|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:30:11|VD_hangup.agi| -- extension = h
2006-12-03 15:30:11|VD_hangup.agi| -- language = en
2006-12-03 15:30:11|VD_hangup.agi| -- priority = 2
2006-12-03 15:30:11|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:30:11|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:30:11|VD_hangup.agi| -- type = SIP
2006-12-03 15:30:11|VD_hangup.agi| -- uniqueid = 1165147636.38
2006-12-03 15:30:11|VD_hangup.agi|AGI Variables: |1165147636.38|SIP/skiv-09187a18|h|SIP|S0612031507158600051|
2006-12-03 15:30:11|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:30:11|VD_hangup.agi|VD_hangup : S0612031507158600051 SIP/skiv-09187a18 2 158600051
2006-12-03 15:30:11|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1165147636.38' limit 1;|
2006-12-03 15:30:11|VD_hangup.agi|VD hangup: no VDAC record found: 1165147636.38 S0612031507158600051
2006-12-03 15:30:20|call_log.agi|AGI Environment Dump:
2006-12-03 15:30:20|call_log.agi| -- accountcode =
2006-12-03 15:30:20|call_log.agi| -- callerid = unknown
2006-12-03 15:30:20|call_log.agi| -- calleridname = S0612031530108600051
2006-12-03 15:30:20|call_log.agi| -- callingani2 = 0
2006-12-03 15:30:20|call_log.agi| -- callingpres = 0
2006-12-03 15:30:20|call_log.agi| -- callingtns = 0
2006-12-03 15:30:20|call_log.agi| -- callington = 0
2006-12-03 15:30:20|call_log.agi| -- channel = SIP/skiv-09197820
2006-12-03 15:30:20|call_log.agi| -- context = default
2006-12-03 15:30:20|call_log.agi| -- dnid = unknown
2006-12-03 15:30:20|call_log.agi| -- enhanced = 0.0
2006-12-03 15:30:20|call_log.agi| -- extension = h
2006-12-03 15:30:20|call_log.agi| -- language = en
2006-12-03 15:30:20|call_log.agi| -- priority = 1
2006-12-03 15:30:20|call_log.agi| -- rdnis = unknown
2006-12-03 15:30:20|call_log.agi| -- request = call_log.agi
2006-12-03 15:30:20|call_log.agi| -- type = SIP
2006-12-03 15:30:20|call_log.agi| -- uniqueid = 1165149011.41
2006-12-03 15:30:20|call_log.agi|AGI Variables: |1165149011.41|SIP/skiv-09197820|h|SIP|S0612031530108600051|
2006-12-03 15:30:20|call_log.agi||CALL HUNG UP|
2006-12-03 15:30:20|call_log.agi||DELETE from live_inbound where uniqueid='1165149011.41' and server_ip='192.168.17.69'|
2006-12-03 15:30:20|call_log.agi|+++++ CALL LOG HUNGUP: |1165149011.41|SIP/skiv-09197820|h|2006-12-03 15:30:20|min: |
2006-12-03 15:30:20|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:30:20|VD_hangup.agi|0|PRI-----NODEBUG-----16---------------
2006-12-03 15:30:20|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:30:20|VD_hangup.agi| -- accountcode =
2006-12-03 15:30:20|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:30:20|VD_hangup.agi| -- calleridname = S0612031530108600051
2006-12-03 15:30:20|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:30:20|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:30:20|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:30:20|VD_hangup.agi| -- callington = 0
2006-12-03 15:30:20|VD_hangup.agi| -- channel = SIP/skiv-09197820
2006-12-03 15:30:20|VD_hangup.agi| -- context = default
2006-12-03 15:30:20|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:30:20|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:30:20|VD_hangup.agi| -- extension = h
2006-12-03 15:30:20|VD_hangup.agi| -- language = en
2006-12-03 15:30:20|VD_hangup.agi| -- priority = 2
2006-12-03 15:30:20|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:30:20|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:30:20|VD_hangup.agi| -- type = SIP
2006-12-03 15:30:20|VD_hangup.agi| -- uniqueid = 1165149011.41
2006-12-03 15:30:20|VD_hangup.agi|AGI Variables: |1165149011.41|SIP/skiv-09197820|h|SIP|S0612031530108600051|
2006-12-03 15:30:20|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:30:20|VD_hangup.agi|VD_hangup : S0612031530108600051 SIP/skiv-09197820 2 108600051
2006-12-03 15:30:20|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1165149011.41' limit 1;|
2006-12-03 15:30:20|VD_hangup.agi|VD hangup: no VDAC record found: 1165149011.41 S0612031530108600051
2006-12-03 15:30:51|call_log.agi|AGI Environment Dump:
2006-12-03 15:30:51|call_log.agi| -- accountcode =
2006-12-03 15:30:51|call_log.agi| -- callerid = unknown
2006-12-03 15:30:51|call_log.agi| -- calleridname = skiv
2006-12-03 15:30:51|call_log.agi| -- callingani2 = 0
2006-12-03 15:30:51|call_log.agi| -- callingpres = 0
2006-12-03 15:30:51|call_log.agi| -- callingtns = 0
2006-12-03 15:30:51|call_log.agi| -- callington = 0
2006-12-03 15:30:51|call_log.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:30:51|call_log.agi| -- context = default
2006-12-03 15:30:51|call_log.agi| -- dnid = unknown
2006-12-03 15:30:51|call_log.agi| -- enhanced = 0.0
2006-12-03 15:30:51|call_log.agi| -- extension = s
2006-12-03 15:30:51|call_log.agi| -- language = en
2006-12-03 15:30:51|call_log.agi| -- priority = 2
2006-12-03 15:30:51|call_log.agi| -- rdnis = unknown
2006-12-03 15:30:51|call_log.agi| -- request = call_log.agi
2006-12-03 15:30:51|call_log.agi| -- type = SIP
2006-12-03 15:30:51|call_log.agi| -- uniqueid = 1165149050.46
2006-12-03 15:30:51|call_log.agi|AGI Variables: |1165149050.46|SIP/192.168.17.151-091a14b8|s|SIP|unknown|
2006-12-03 15:30:51|call_log.agi|+++++ CALL LOG START : 2006-12-03 15:30:51
2006-12-03 15:30:51|call_log.agi||INSERT INTO call_log (uniqueid,channel,channel_group,type,server_ip,extension,number_dialed,start_time,start_epoch,end_time,end_epoch,length_in_sec,length_in_min,caller_code) values('1165149050.46','SIP/192.168.17.151','','SIP','192.168.17.69','192.168.17.151','s','2006-12-03 15:30:51','1165149051','','','','','unknown')|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|Perl Environment Dump:
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|0|SALESLINE-----8002277655-----Closer-----park----------101-----9
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- accountcode =
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- callerid = unknown
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- calleridname = skiv
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- callingani2 = 0
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- callingpres = 0
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- callingtns = 0
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- callington = 0
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- context = default
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- dnid = unknown
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- enhanced = 0.0
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- extension = 8002277655
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- language = en
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- priority = 4
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- rdnis = unknown
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- request = agi-VDADcloser_inbound_NOCID.agi
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- type = SIP
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi| -- uniqueid = 1165149050.46
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|AGI Variables: |1165149050.46|SIP/192.168.17.151-091a14b8|8002277655|SIP|Closer|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|+++++ INBOUND CALL VDCL STARTED : |SALESLINE|Closer-123456|2006-12-03 15:30:57
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||select LAST_INSERT_ID() LIMIT 1;|8|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|callerID changed: Y1203153057000000008
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||INSERT INTO vicidial_auto_calls values('','192.168.17.69','SALESLINE','LIVE','8','1165149050.46','Y1203153057000000008','SIP/192.168.17.151-091a14b8','9','','2006-12-03 15:30:57','IN')|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||INSERT INTO vicidial_log (uniqueid,lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('1165149050.46','8','SALESLINE','2006-12-03 15:30:57','1165149057','XFER','9','','123456','N')|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD : |8|123456|insert to vicidial_log: 1165149050.46
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('8','SALESLINE','2006-12-03 15:30:57','1165149057','QUEUE','9','','VDCL','N')|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDCL : |8|insert to vicidial_closer_log
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||INSERT INTO vicidial_xfer_log (lead_id,campaign_id,call_date,phone_code,phone_number,user,closer) values('8','SALESLINE','2006-12-03 15:30:57','9','','123456','VDXL')|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDXL : |8|insert to vicidial_xfer_log
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |0E0|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|NNNNN No available agent found
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |0E0|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|NNNNN No available agent found
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |0E0|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|NNNNN No available agent found
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |0E0|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|NNNNN No available agent found
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |0E0|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|NNNNN No available agent found
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |0E0|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|NNNNN No available agent found
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |0E0|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|NNNNN No available agent found
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:30:57" and lead_id != '8';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDAD get agent: |1|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='8',uniqueid='1165149050.46', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203153057000000008' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi||SELECT conf_exten,user,extension FROM vicidial_live_agents where status = 'QUEUE' and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and callerid='Y1203153057000000008' and channel='SIP/192.168.17.151-091a14b8' order by last_call_time limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDCL XFER : |1|Y1203153057000000008
|UPDATE vicidial_auto_calls set status='CLOSER' where callerid='Y1203153057000000008';|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDXL XFER vicidial_xfer_log update: |1|8|7777
|UPDATE vicidial_xfer_log set closer='7777' where lead_id = '8' order by call_date desc limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- closer log : |1|8
|UPDATE vicidial_closer_log set user='7777' where lead_id='8' order by call_date desc limit 1;|
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|exiting VDAD app, transferring call to 8600051
2006-12-03 15:30:57|agi-VDADcloser_inbound_NOCID.agi|-- VDCL vcl update: |1|8|
|UPDATE vicidial_closer_log set queue_seconds='1.75' where lead_id = '8' and call_date='2006-12-03 15:30:57';|
2006-12-03 15:31:05|agi-VDADcloser_inbound_NOCID.agi|XXXXX VDAD transferred: start|stop 2006-12-03 15:30:57|2006-12-03 15:31:05
2006-12-03 15:31:41|call_log.agi|AGI Environment Dump:
2006-12-03 15:31:41|call_log.agi| -- accountcode =
2006-12-03 15:31:41|call_log.agi| -- callerid = unknown
2006-12-03 15:31:41|call_log.agi| -- calleridname = Y1203153057000000008
2006-12-03 15:31:41|call_log.agi| -- callingani2 = 0
2006-12-03 15:31:41|call_log.agi| -- callingpres = 0
2006-12-03 15:31:41|call_log.agi| -- callingtns = 0
2006-12-03 15:31:41|call_log.agi| -- callington = 0
2006-12-03 15:31:41|call_log.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:31:41|call_log.agi| -- context = default
2006-12-03 15:31:41|call_log.agi| -- dnid = unknown
2006-12-03 15:31:41|call_log.agi| -- enhanced = 0.0
2006-12-03 15:31:41|call_log.agi| -- extension = h
2006-12-03 15:31:41|call_log.agi| -- language = en
2006-12-03 15:31:41|call_log.agi| -- priority = 1
2006-12-03 15:31:41|call_log.agi| -- rdnis = unknown
2006-12-03 15:31:41|call_log.agi| -- request = call_log.agi
2006-12-03 15:31:41|call_log.agi| -- type = SIP
2006-12-03 15:31:41|call_log.agi| -- uniqueid = 1165149050.46
2006-12-03 15:31:41|call_log.agi|AGI Variables: |1165149050.46|SIP/192.168.17.151-091a14b8|h|SIP|Y1203153057000000008|
2006-12-03 15:31:41|call_log.agi||CALL HUNG UP|
2006-12-03 15:31:41|call_log.agi||1165149050.4600000|1165149051|
2006-12-03 15:31:41|call_log.agi|QUERY done: start time = 1165149051 | sec: 50 | min: 0.83 |
2006-12-03 15:31:41|call_log.agi||UPDATE call_log set end_time='2006-12-03 15:31:41',end_epoch='1165149101',length_in_sec=50,length_in_min=' 0.83' where uniqueid='1165149050.46'|
2006-12-03 15:31:41|call_log.agi||DELETE from live_inbound where uniqueid='1165149050.46' and server_ip='192.168.17.69'|
2006-12-03 15:31:41|call_log.agi|+++++ CALL LOG HUNGUP: |1165149050.46|SIP/192.168.17.151-091a14b8|h|2006-12-03 15:31:41|min: 0.83|
2006-12-03 15:31:41|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:31:41|VD_hangup.agi|0|PRI-----NODEBUG-----0---------------
2006-12-03 15:31:41|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:31:41|VD_hangup.agi| -- accountcode =
2006-12-03 15:31:41|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:31:41|VD_hangup.agi| -- calleridname = Y1203153057000000008
2006-12-03 15:31:41|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:31:41|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:31:41|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:31:41|VD_hangup.agi| -- callington = 0
2006-12-03 15:31:41|VD_hangup.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:31:41|VD_hangup.agi| -- context = default
2006-12-03 15:31:41|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:31:41|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:31:41|VD_hangup.agi| -- extension = h
2006-12-03 15:31:41|VD_hangup.agi| -- language = en
2006-12-03 15:31:41|VD_hangup.agi| -- priority = 2
2006-12-03 15:31:41|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:31:41|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:31:41|VD_hangup.agi| -- type = SIP
2006-12-03 15:31:41|VD_hangup.agi| -- uniqueid = 1165149050.46
2006-12-03 15:31:41|VD_hangup.agi|AGI Variables: |1165149050.46|SIP/192.168.17.151-091a14b8|h|SIP|Y1203153057000000008|
2006-12-03 15:31:41|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:31:41|VD_hangup.agi|VD_hangup : Y1203153057000000008 SIP/192.168.17.151-091a14b8 2 8
2006-12-03 15:31:41|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1165149050.46' limit 1;|
2006-12-03 15:31:41|VD_hangup.agi|VD hangup: no VDAC record found: 1165149050.46 Y1203153057000000008
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Inbound campaign behavior

Postby skiv » Sun Dec 03, 2006 8:19 am

Hi Matt, Moreover I've tried to use the inbound CIDlookup, still no success, here are the results:
2006-12-03 15:40:53|call_log.agi|AGI Environment Dump:
2006-12-03 15:40:53|call_log.agi| -- accountcode =
2006-12-03 15:40:53|call_log.agi| -- callerid = unknown
2006-12-03 15:40:53|call_log.agi| -- calleridname = skiv
2006-12-03 15:40:53|call_log.agi| -- callingani2 = 0
2006-12-03 15:40:53|call_log.agi| -- callingpres = 0
2006-12-03 15:40:53|call_log.agi| -- callingtns = 0
2006-12-03 15:40:53|call_log.agi| -- callington = 0
2006-12-03 15:40:53|call_log.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:40:53|call_log.agi| -- context = default
2006-12-03 15:40:53|call_log.agi| -- dnid = unknown
2006-12-03 15:40:53|call_log.agi| -- enhanced = 0.0
2006-12-03 15:40:53|call_log.agi| -- extension = s
2006-12-03 15:40:53|call_log.agi| -- language = en
2006-12-03 15:40:53|call_log.agi| -- priority = 2
2006-12-03 15:40:53|call_log.agi| -- rdnis = unknown
2006-12-03 15:40:53|call_log.agi| -- request = call_log.agi
2006-12-03 15:40:53|call_log.agi| -- type = SIP
2006-12-03 15:40:53|call_log.agi| -- uniqueid = 1165149652.47
2006-12-03 15:40:53|call_log.agi|AGI Variables: |1165149652.47|SIP/192.168.17.151-091a14b8|s|SIP|unknown|
2006-12-03 15:40:53|call_log.agi|+++++ CALL LOG START : 2006-12-03 15:40:53
2006-12-03 15:40:53|call_log.agi||INSERT INTO call_log (uniqueid,channel,channel_group,type,server_ip,extension,number_dialed,start_time,start_epoch,end_time,end_epoch,length_in_sec,length_in_min,caller_code) values('1165149652.47','SIP/192.168.17.151','','SIP','192.168.17.69','192.168.17.151','s','2006-12-03 15:40:53','1165149653','','','','','unknown')|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|Perl Environment Dump:
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|0|SALESLINE-----8002277655-----Closer-----park----------101-----9
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- accountcode =
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- callerid = unknown
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- calleridname = skiv
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- callingani2 = 0
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- callingpres = 0
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- callingtns = 0
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- callington = 0
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- context = default
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- dnid = unknown
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- enhanced = 0.0
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- extension = 8002277655
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- language = en
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- priority = 4
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- rdnis = unknown
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- request = agi-VDADcloser_inboundCIDlookup.agi
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- type = SIP
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi| -- uniqueid = 1165149652.47
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|AGI Variables: |1165149652.47|SIP/192.168.17.151-091a14b8|8002277655|SIP|Closer|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|+++++ INBOUND CALL VDCL STARTED : |SALESLINE|Closer-8002277655|2006-12-03 15:41:01
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi||select LAST_INSERT_ID() LIMIT 1;|9|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|callerID changed: Y1203154101000000009
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi||INSERT INTO vicidial_auto_calls values('','192.168.17.69','SALESLINE','LIVE','9','1165149652.47','Y1203154101000000009','SIP/192.168.17.151-091a14b8','9','skiv','2006-12-03 15:41:01','IN')|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('9','SALESLINE','2006-12-03 15:41:01','1165149661','QUEUE','9','skiv','VDCL','N')|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|-- VDCL : |9|insert to vicidial_closer_log
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:41:01" and lead_id != '9';|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|-- VDAD get agent: |1|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1165149652.47', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203154101000000009' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi||SELECT conf_exten,user,extension FROM vicidial_live_agents where status = 'QUEUE' and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and callerid='Y1203154101000000009' and channel='SIP/192.168.17.151-091a14b8' order by last_call_time limit 1;|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|-- VDCL XFER : |1|Y1203154101000000009
|UPDATE vicidial_auto_calls set status='CLOSER' where callerid='Y1203154101000000009';|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|-- closer log : |1|9
|UPDATE vicidial_closer_log set user='7777' where lead_id='9' order by call_date desc limit 1;|
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|exiting VDAD app, transferring call to 8600051
2006-12-03 15:41:01|agi-VDADcloser_inboundCIDlookup.agi|-- VDCL vcl update: |1|9|
|UPDATE vicidial_closer_log set queue_seconds='0' where lead_id = '9' and call_date='2006-12-03 15:41:01';|
2006-12-03 15:41:02|agi-VDADcloser_inboundCIDlookup.agi|XXXXX VDAD transferred: start|stop 2006-12-03 15:41:01|2006-12-03 15:41:02
2006-12-03 15:41:26|call_log.agi|AGI Environment Dump:
2006-12-03 15:41:26|call_log.agi| -- accountcode =
2006-12-03 15:41:26|call_log.agi| -- callerid = unknown
2006-12-03 15:41:26|call_log.agi| -- calleridname = Y1203154101000000009
2006-12-03 15:41:26|call_log.agi| -- callingani2 = 0
2006-12-03 15:41:26|call_log.agi| -- callingpres = 0
2006-12-03 15:41:26|call_log.agi| -- callingtns = 0
2006-12-03 15:41:26|call_log.agi| -- callington = 0
2006-12-03 15:41:26|call_log.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:41:26|call_log.agi| -- context = default
2006-12-03 15:41:26|call_log.agi| -- dnid = unknown
2006-12-03 15:41:26|call_log.agi| -- enhanced = 0.0
2006-12-03 15:41:26|call_log.agi| -- extension = h
2006-12-03 15:41:26|call_log.agi| -- language = en
2006-12-03 15:41:26|call_log.agi| -- priority = 1
2006-12-03 15:41:26|call_log.agi| -- rdnis = unknown
2006-12-03 15:41:26|call_log.agi| -- request = call_log.agi
2006-12-03 15:41:26|call_log.agi| -- type = SIP
2006-12-03 15:41:26|call_log.agi| -- uniqueid = 1165149652.47
2006-12-03 15:41:26|call_log.agi|AGI Variables: |1165149652.47|SIP/192.168.17.151-091a14b8|h|SIP|Y1203154101000000009|
2006-12-03 15:41:26|call_log.agi||CALL HUNG UP|
2006-12-03 15:41:26|call_log.agi||1165149652.4700000|1165149653|
2006-12-03 15:41:26|call_log.agi|QUERY done: start time = 1165149653 | sec: 33 | min: 0.55 |
2006-12-03 15:41:26|call_log.agi||UPDATE call_log set end_time='2006-12-03 15:41:26',end_epoch='1165149686',length_in_sec=33,length_in_min=' 0.55' where uniqueid='1165149652.47'|
2006-12-03 15:41:26|call_log.agi||DELETE from live_inbound where uniqueid='1165149652.47' and server_ip='192.168.17.69'|
2006-12-03 15:41:26|call_log.agi|+++++ CALL LOG HUNGUP: |1165149652.47|SIP/192.168.17.151-091a14b8|h|2006-12-03 15:41:26|min: 0.55|
2006-12-03 15:41:26|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:41:26|VD_hangup.agi|0|PRI-----NODEBUG-----0---------------
2006-12-03 15:41:26|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:41:26|VD_hangup.agi| -- accountcode =
2006-12-03 15:41:26|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:41:26|VD_hangup.agi| -- calleridname = Y1203154101000000009
2006-12-03 15:41:26|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:41:26|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:41:26|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:41:26|VD_hangup.agi| -- callington = 0
2006-12-03 15:41:26|VD_hangup.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:41:26|VD_hangup.agi| -- context = default
2006-12-03 15:41:26|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:41:26|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:41:26|VD_hangup.agi| -- extension = h
2006-12-03 15:41:26|VD_hangup.agi| -- language = en
2006-12-03 15:41:26|VD_hangup.agi| -- priority = 2
2006-12-03 15:41:26|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:41:26|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:41:26|VD_hangup.agi| -- type = SIP
2006-12-03 15:41:26|VD_hangup.agi| -- uniqueid = 1165149652.47
2006-12-03 15:41:26|VD_hangup.agi|AGI Variables: |1165149652.47|SIP/192.168.17.151-091a14b8|h|SIP|Y1203154101000000009|
2006-12-03 15:41:26|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:41:26|VD_hangup.agi|VD_hangup : Y1203154101000000009 SIP/192.168.17.151-091a14b8 2 9
2006-12-03 15:41:26|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1165149652.47' limit 1;|
2006-12-03 15:41:26|VD_hangup.agi|-- VDAC record deleted: |1| |9|1165149652.47|Y1203154101000000009|192.168.17.69
2006-12-03 15:41:26|VD_hangup.agi||SELECT start_epoch,status FROM vicidial_log where uniqueid='1165149652.47' and lead_id='9' limit 1;|
2006-12-03 15:41:26|VD_hangup.agi|no VDL record found: 1165149652.47 Y1203154101000000009 9 1165149652.47
2006-12-03 15:41:26|VD_hangup.agi||SELECT start_epoch,status,closecallid FROM vicidial_closer_log where lead_id = '9' and call_date > "2006-12-03 09:41:26" order by call_date desc limit 1;|
2006-12-03 15:41:26|VD_hangup.agi||UPDATE vicidial_log set end_epoch='1165149686',length_in_sec='25' where uniqueid = '1165149652.47';|
2006-12-03 15:41:26|VD_hangup.agi|-- VDAD vicidial_log update: |0E0|1165149652.47|INCALL|
2006-12-03 15:41:26|VD_hangup.agi|||INCALL|
|UPDATE vicidial_closer_log set end_epoch='1165149686',length_in_sec='25' where closecallid = '48';|
2006-12-03 15:41:26|VD_hangup.agi|-- VDCL update: |1|1165149652.47|48|
2006-12-03 15:42:14|call_log.agi|AGI Environment Dump:
2006-12-03 15:42:14|call_log.agi| -- accountcode =
2006-12-03 15:42:14|call_log.agi| -- callerid = unknown
2006-12-03 15:42:14|call_log.agi| -- calleridname = skiv
2006-12-03 15:42:14|call_log.agi| -- callingani2 = 0
2006-12-03 15:42:14|call_log.agi| -- callingpres = 0
2006-12-03 15:42:14|call_log.agi| -- callingtns = 0
2006-12-03 15:42:14|call_log.agi| -- callington = 0
2006-12-03 15:42:14|call_log.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:42:14|call_log.agi| -- context = default
2006-12-03 15:42:14|call_log.agi| -- dnid = unknown
2006-12-03 15:42:14|call_log.agi| -- enhanced = 0.0
2006-12-03 15:42:14|call_log.agi| -- extension = s
2006-12-03 15:42:14|call_log.agi| -- language = en
2006-12-03 15:42:14|call_log.agi| -- priority = 2
2006-12-03 15:42:14|call_log.agi| -- rdnis = unknown
2006-12-03 15:42:14|call_log.agi| -- request = call_log.agi
2006-12-03 15:42:14|call_log.agi| -- type = SIP
2006-12-03 15:42:14|call_log.agi| -- uniqueid = 1165149733.48
2006-12-03 15:42:14|call_log.agi|AGI Variables: |1165149733.48|SIP/192.168.17.151-091a14b8|s|SIP|unknown|
2006-12-03 15:42:14|call_log.agi|+++++ CALL LOG START : 2006-12-03 15:42:14
2006-12-03 15:42:14|call_log.agi||INSERT INTO call_log (uniqueid,channel,channel_group,type,server_ip,extension,number_dialed,start_time,start_epoch,end_time,end_epoch,length_in_sec,length_in_min,caller_code) values('1165149733.48','SIP/192.168.17.151','','SIP','192.168.17.69','192.168.17.151','s','2006-12-03 15:42:14','1165149734','','','','','unknown')|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|Perl Environment Dump:
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|0|SALESLINE-----8002277655-----Closer-----park----------101-----9
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- accountcode =
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- callerid = unknown
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- calleridname = skiv
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- callingani2 = 0
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- callingpres = 0
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- callingtns = 0
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- callington = 0
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- context = default
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- dnid = unknown
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- enhanced = 0.0
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- extension = 8002277655
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- language = en
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- priority = 4
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- rdnis = unknown
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- request = agi-VDADcloser_inboundCIDlookup.agi
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- type = SIP
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi| -- uniqueid = 1165149733.48
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|AGI Variables: |1165149733.48|SIP/192.168.17.151-091a14b8|8002277655|SIP|Closer|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|+++++ INBOUND CALL VDCL STARTED : |SALESLINE|Closer-8002277655|2006-12-03 15:42:21
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi||SELECT lead_id from vicidial_list where list_id='101' and phone_number='skiv' order by modify_date limit 1;|9|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|callerID changed: Y1203154221000000009
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi||INSERT INTO vicidial_auto_calls values('','192.168.17.69','SALESLINE','LIVE','9','1165149733.48','Y1203154221000000009','SIP/192.168.17.151-091a14b8','9','skiv','2006-12-03 15:42:21','IN')|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi||INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('9','SALESLINE','2006-12-03 15:42:21','1165149741','QUEUE','9','skiv','VDCL','N')|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|-- VDCL : |9|insert to vicidial_closer_log
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='192.168.17.69' and campaign_id = 'SALESLINE' and call_time < "2006-12-03 15:42:21" and lead_id != '9';|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|-- VDAD get agent: |1|SALESLINE|UPDATE vicidial_live_agents set status='QUEUE',lead_id='9',uniqueid='1165149733.48', channel='SIP/192.168.17.151-091a14b8', callerid='Y1203154221000000009' where status IN('CLOSER','READY') and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19700101025955' order by random_id limit 1;|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi||SELECT conf_exten,user,extension FROM vicidial_live_agents where status = 'QUEUE' and server_ip='192.168.17.69' and campaign_id LIKE "%CLOSER%" and callerid='Y1203154221000000009' and channel='SIP/192.168.17.151-091a14b8' order by last_call_time limit 1;|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|-- VDCL XFER : |1|Y1203154221000000009
|UPDATE vicidial_auto_calls set status='CLOSER' where callerid='Y1203154221000000009';|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|-- closer log : |1|9
|UPDATE vicidial_closer_log set user='7777' where lead_id='9' order by call_date desc limit 1;|
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|exiting VDAD app, transferring call to 8600051
2006-12-03 15:42:21|agi-VDADcloser_inboundCIDlookup.agi|-- VDCL vcl update: |1|9|
|UPDATE vicidial_closer_log set queue_seconds='0' where lead_id = '9' and call_date='2006-12-03 15:42:21';|
2006-12-03 15:42:22|agi-VDADcloser_inboundCIDlookup.agi|XXXXX VDAD transferred: start|stop 2006-12-03 15:42:21|2006-12-03 15:42:22
2006-12-03 15:42:50|call_log.agi|AGI Environment Dump:
2006-12-03 15:42:50|call_log.agi| -- accountcode =
2006-12-03 15:42:50|call_log.agi| -- callerid = unknown
2006-12-03 15:42:50|call_log.agi| -- calleridname = Y1203154221000000009
2006-12-03 15:42:50|call_log.agi| -- callingani2 = 0
2006-12-03 15:42:50|call_log.agi| -- callingpres = 0
2006-12-03 15:42:50|call_log.agi| -- callingtns = 0
2006-12-03 15:42:50|call_log.agi| -- callington = 0
2006-12-03 15:42:50|call_log.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:42:50|call_log.agi| -- context = default
2006-12-03 15:42:50|call_log.agi| -- dnid = unknown
2006-12-03 15:42:50|call_log.agi| -- enhanced = 0.0
2006-12-03 15:42:50|call_log.agi| -- extension = h
2006-12-03 15:42:50|call_log.agi| -- language = en
2006-12-03 15:42:50|call_log.agi| -- priority = 1
2006-12-03 15:42:50|call_log.agi| -- rdnis = unknown
2006-12-03 15:42:50|call_log.agi| -- request = call_log.agi
2006-12-03 15:42:50|call_log.agi| -- type = SIP
2006-12-03 15:42:50|call_log.agi| -- uniqueid = 1165149733.48
2006-12-03 15:42:50|call_log.agi|AGI Variables: |1165149733.48|SIP/192.168.17.151-091a14b8|h|SIP|Y1203154221000000009|
2006-12-03 15:42:50|call_log.agi||CALL HUNG UP|
2006-12-03 15:42:50|call_log.agi||1165149733.4800000|1165149734|
2006-12-03 15:42:50|call_log.agi|QUERY done: start time = 1165149734 | sec: 36 | min: 0.60 |
2006-12-03 15:42:50|call_log.agi||UPDATE call_log set end_time='2006-12-03 15:42:50',end_epoch='1165149770',length_in_sec=36,length_in_min=' 0.60' where uniqueid='1165149733.48'|
2006-12-03 15:42:50|call_log.agi||DELETE from live_inbound where uniqueid='1165149733.48' and server_ip='192.168.17.69'|
2006-12-03 15:42:50|call_log.agi|+++++ CALL LOG HUNGUP: |1165149733.48|SIP/192.168.17.151-091a14b8|h|2006-12-03 15:42:50|min: 0.60|
2006-12-03 15:42:50|VD_hangup.agi|Perl Environment Dump:
2006-12-03 15:42:50|VD_hangup.agi|0|PRI-----NODEBUG-----0---------------
2006-12-03 15:42:50|VD_hangup.agi|AGI Environment Dump:
2006-12-03 15:42:50|VD_hangup.agi| -- accountcode =
2006-12-03 15:42:50|VD_hangup.agi| -- callerid = unknown
2006-12-03 15:42:50|VD_hangup.agi| -- calleridname = Y1203154221000000009
2006-12-03 15:42:50|VD_hangup.agi| -- callingani2 = 0
2006-12-03 15:42:50|VD_hangup.agi| -- callingpres = 0
2006-12-03 15:42:50|VD_hangup.agi| -- callingtns = 0
2006-12-03 15:42:50|VD_hangup.agi| -- callington = 0
2006-12-03 15:42:50|VD_hangup.agi| -- channel = SIP/192.168.17.151-091a14b8
2006-12-03 15:42:50|VD_hangup.agi| -- context = default
2006-12-03 15:42:50|VD_hangup.agi| -- dnid = unknown
2006-12-03 15:42:50|VD_hangup.agi| -- enhanced = 0.0
2006-12-03 15:42:50|VD_hangup.agi| -- extension = h
2006-12-03 15:42:50|VD_hangup.agi| -- language = en
2006-12-03 15:42:50|VD_hangup.agi| -- priority = 2
2006-12-03 15:42:50|VD_hangup.agi| -- rdnis = unknown
2006-12-03 15:42:50|VD_hangup.agi| -- request = VD_hangup.agi
2006-12-03 15:42:50|VD_hangup.agi| -- type = SIP
2006-12-03 15:42:50|VD_hangup.agi| -- uniqueid = 1165149733.48
2006-12-03 15:42:50|VD_hangup.agi|AGI Variables: |1165149733.48|SIP/192.168.17.151-091a14b8|h|SIP|Y1203154221000000009|
2006-12-03 15:42:50|VD_hangup.agi|DEBUG: NODEBUG
2006-12-03 15:42:50|VD_hangup.agi|VD_hangup : Y1203154221000000009 SIP/192.168.17.151-091a14b8 2 9
2006-12-03 15:42:50|VD_hangup.agi||SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1165149733.48' limit 1;|
2006-12-03 15:42:50|VD_hangup.agi|VD hangup: no VDAC record found: 1165149733.48 Y1203154221000000009
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby skiv » Sun Dec 03, 2006 8:49 am

Hi Matt, Moreover I've traced CustomerData_update function and found that all the information passed to it is filled properly, however, vdc_db_query.php returns :
phone number or lead_id = 9 is not correct
so, the query fails here:

if ( (strlen($phone_number)<1) || (strlen($lead_id)<1) )
{
echo "phone_number $phone_number or lead_id $lead_id is not valid\n";
exit;
}
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby skiv » Sun Dec 03, 2006 8:52 am

So, the phone number for my incoming sip call is skiv - not a numeric value, probably this causes the confusion
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby skiv » Sun Dec 03, 2006 8:56 am

Moreover, I've got a little question: what if I receive anonimous SIP calls, or calls from different phones, adrressing the same inbound lead?
Probably we should give the agent possibilty to select or find the incoming lead manually during the inbound call, what do you think?
Your comments are highly appreciated!

Regards,
Alex
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby mflorell » Sun Dec 03, 2006 10:07 pm

There is currently no way of doing that in VICIDIAL.

If there is enough interest in it we would probably start by allowing the manual dial feature of searching for a lead in the inbound calls.
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida
Top

Postby skiv » Mon Dec 04, 2006 8:39 am

Hi Matt,
Let me know your opinion on the first issue regarding the incorrect number behavior - scripts just silently scips the query containging the number that is less than <1 saying nothing to the end user. My SIP phone number seemed to be correct - it was "skiv", probably there is a reason to warn user in case if the query won't be accepted,
What do you think?
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top

Postby mflorell » Tue Dec 05, 2006 8:28 am

Who is your provider for SIP trunks that is only sending you letters for inbound calls?
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida
Top

Postby skiv » Tue Dec 26, 2006 8:50 am

OOps, that was my fault - thanks!
Alex K
skiv
 
Posts: 22
Joined: Tue Nov 28, 2006 9:00 am
Top
Post a reply

Return to Support

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 118 guests

Powered by phpBB® Forum Software © phpBB Group
cron