vicidial.org

I follw your "create an inbound-group,point an external number at it and take calls" step,try it,the first time,i can dial in,the asterisk mesage is below"
--------------
Executing Ringing("SIP/1000-6d9f", "") in new stack
-- Executing Wait("SIP/1000-6d9f", "1") in new stack
-- Executing Answer("SIP/1000-6d9f", "") in new stack
-- Executing AGI("SIP/1000-6d9f", "agi-VDADcloser_inboundCID.agi|SALESLINE-----1000-----Closer-----park----999-----1") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCID.agi
Perl Environment Dump:
0|SALESLINE-----1000-----Closer-----park----999-----1|
AGI Environment Dump:
-- accountcode =
-- callerid = "1000"
-- channel = SIP/1000-6d9f
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = 8000
-- language = en
-- priority = 4
-- rdnis = unknown
-- request = agi-VDADcloser_inboundCID.agi
-- type = SIP
-- uniqueid = 1157810258.20

INBOUND CALL VDCL STARTED
+++++ INBOUND CALL VDCL STARTED : |1157810258.20|SALESLINE|SIP/1000-6d9f|8000|SIP|Closer-1000|2006-09-09 5:57:40
AGI Environment Dump: |1157810258.20|SIP/1000-6d9f|8000|SIP|Closer|

INBOUND CALL RECEIVED IN FROM VDCL: Closer SIP/1000-6d9f
+++++ INBOUND VDCL START : |1157810258.20|SIP/1000-6d9f|8000|SIP|2006-09-09 5:57:40

|INSERT INTO vicidial_list (entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,called_since_last_reset,phone_code,phone_number,security_phrase,called_count,gmt_offset_now,comments) values('2006-09-09 5:57:40','2006090955740','INBND','1000','SALESLINE','VDCL','','Y','','1000','SALESLINE','1','-5.00','1000');|52|
FAIL (unexpected result '')
callerID changed: Y090955740000000052

|INSERT INTO vicidial_auto_calls values('','132.238.97.70','SALESLINE','LIVE','52','1157810258.20','Y090955740000000052','SIP/1000-6d9f','','1000','2006-09-09 5:57:40','IN')|

|INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('52','SALESLINE','2006-09-09 5:57:40','1157810260','QUEUE','','1000','VDCL','N')|
-- VDCL : |52|insert to vicidial_closer_log


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='132.238.97.70' and campaign_id = 'SALESLINE' and call_time < "2006-09-09 5:57:40" and lead_id != '52';|
-- VDAD get agent: |360|0|1|update of vla table: SALESLINE|132.238.97.70
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='52',uniqueid='1157810258.20', channel='SIP/1000-6d9f', callerid='Y090955740000000052' where status IN('CLOSER','READY') and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19691231135955' order by last_call_finish limit 1;|


|SELECT conf_exten,user,extension FROM vicidial_live_agents where status = 'QUEUE' and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and callerid='Y090955740000000052' and channel='SIP/1000-6d9f' order by last_call_time limit 1;|
-- VDCL XFER : |1|update of vac table: Y090955740000000052
|UPDATE vicidial_auto_calls set status='CLOSER' where callerid='Y090955740000000052';|
-- closer log : |1|update of vcl table: 52
|UPDATE vicidial_closer_log set user='7777' where lead_id='52' order by call_date desc limit 1;|

exiting the VDAD app, transferring call to 8600051
FAIL (unexpected result '')
FAIL (unexpected result '')
FAIL (unexpected result '')

XXXXXXXXXX VDAD transferred: start|stop 2006-09-09 5:57:40|2006-09-09 5:57:40
-- AGI Script agi-VDADcloser_inboundCID.agi completed, returning 0
-- Executing MeetMe("SIP/1000-6d9f", "8600051") in new stack

-------------------------------------
and in the vicidial windows,STATUS display"
Incoming: 1000 Group- Primary Sales Line Fronter: - 1000
------------------------
Vendor ID: SALESLINE
Phone: 1000
Show: SALESLINE
Comments: 1000


---------------------------
1)one question:why ohters information about this caller dont display?

----------------------------------

when i hangup,message below
--------------------------------
== Spawn extension (default, 8600051, 1) exited non-zero on 'SIP/1000-6d9f'
-- Executing DeadAGI("SIP/1000-6d9f", "call_log.agi|h") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi
+++++ CALL LOG HUNGUP: |1157810258.20|SIP/1000-6d9f|h|2006-09-09 6:02:34|min: |
-- AGI Script call_log.agi completed, returning 0
-- Executing DeadAGI("SIP/1000-6d9f", "VD_hangup.agi|PRI-----NODEBUG-----0---------------") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi
Perl Environment Dump:
0|PRI-----NODEBUG-----0---------------|
AGI Environment Dump:
-- accountcode =
-- callerid = Y090955740000000052
-- channel = SIP/1000-6d9f
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = h
-- language = en
-- priority = 2
-- rdnis = unknown
-- request = VD_hangup.agi
-- type = SIP
-- uniqueid = 1157810258.20
AGI Environment Dump: |1157810258.20|SIP/1000-6d9f|h|SIP|Y090955740000000052||2|

DEBUG: NODEBUG

VD_hangup : Y090955740000000052 SIP/1000-6d9f 2
+++++ VD hangup START : |1157810258.20|SIP/1000-6d9f|h|SIP|Y090955740000000052|52|2006-09-09 6:02:34||2||


|SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1157810258.20' limit 1;|
-- VDAC record deleted: |1| |52|1157810258.20|Y090955740000000052|132.238.97.70


|SELECT start_epoch,status FROM vicidial_log where uniqueid='1157810258.20' and lead_id='52' limit 1;|

VD hangup: no VDL record found: 1157810258.20 52 1157810258.20


|SELECT start_epoch,status,closecallid FROM vicidial_closer_log where lead_id = '52' and call_date > "2006-09-09 00:02:34" order by call_date desc limit 1;|


|UPDATE vicidial_log set end_epoch='1157810554',length_in_sec='294' where uniqueid = '1157810258.20';|
-- VDAD vicidial_log update: |0|1157810258.20|


|UPDATE vicidial_closer_log set status='DROP',end_epoch='1157810554',length_in_sec='294' where closecallid = '48';|
-- VDCL update: |1|1157810258.20|48|
-------------------------------------------------------------------------------

WHEN use the same phone call again, get gs102 is unavailable
message is below:
----------------------------------------------
-- Executing Ringing("SIP/1000-7c7c", "") in new stack
-- Executing Wait("SIP/1000-7c7c", "1") in new stack
-- Executing Answer("SIP/1000-7c7c", "") in new stack
-- Executing AGI("SIP/1000-7c7c", "agi-VDADcloser_inboundCID.agi|SALESLINE-----1000-----Closer-----park----999-----1") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCID.agi
Perl Environment Dump:
0|SALESLINE-----1000-----Closer-----park----999-----1|
AGI Environment Dump:
-- accountcode =
-- callerid = "1000"
-- channel = SIP/1000-7c7c
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = 8000
-- language = en
-- priority = 4
-- rdnis = unknown
-- request = agi-VDADcloser_inboundCID.agi
-- type = SIP
-- uniqueid = 1157810768.21

INBOUND CALL VDCL STARTED
+++++ INBOUND CALL VDCL STARTED : |1157810768.21|SALESLINE|SIP/1000-7c7c|8000|SIP|Closer-1000|2006-09-09 6:06:09
AGI Environment Dump: |1157810768.21|SIP/1000-7c7c|8000|SIP|Closer|

INBOUND CALL RECEIVED IN FROM VDCL: Closer SIP/1000-7c7c
+++++ INBOUND VDCL START : |1157810768.21|SIP/1000-7c7c|8000|SIP|2006-09-09 6:06:09

|INSERT INTO vicidial_list (entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,called_since_last_reset,phone_code,phone_number,security_phrase,called_count,gmt_offset_now,comments) values('2006-09-09 6:06:09','2006090960609','INBND','1000','SALESLINE','VDCL','','Y','','1000','SALESLINE','1','-5.00','1000');|53|
FAIL (unexpected result '')
callerID changed: Y090960609000000053

|INSERT INTO vicidial_auto_calls values('','132.238.97.70','SALESLINE','LIVE','53','1157810768.21','Y090960609000000053','SIP/1000-7c7c','','1000','2006-09-09 6:06:09','IN')|

|INSERT INTO vicidial_closer_log (lead_id,campaign_id,call_date,start_epoch,status,phone_code,phone_number,user,processed) values('53','SALESLINE','2006-09-09 6:06:09','1157810769','QUEUE','','1000','VDCL','N')|
-- VDCL : |53|insert to vicidial_closer_log


|SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='132.238.97.70' and campaign_id = 'SALESLINE' and call_time < "2006-09-09 6:06:09" and lead_id != '53';|
-- VDAD get agent: |360|0|1|update of vla table: SALESLINE|132.238.97.70
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='53',uniqueid='1157810768.21', channel='SIP/1000-7c7c', callerid='Y090960609000000053' where status IN('CLOSER','READY') and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and closer_campaigns LIKE "% SALESLINE %" and last_update_time > '19691231135955' order by last_call_finish limit 1;|


|SELECT conf_exten,user,extension FROM vicidial_live_agents where status = 'QUEUE' and server_ip='132.238.97.70' and campaign_id LIKE "%CLOSER%" and callerid='Y090960609000000053' and channel='SIP/1000-7c7c' order by last_call_time limit 1;|
-- VDCL XFER : |1|update of vac table: Y090960609000000053
|UPDATE vicidial_auto_calls set status='CLOSER' where callerid='Y090960609000000053';|
-- closer log : |1|update of vcl table: 53
|UPDATE vicidial_closer_log set user='6666' where lead_id='53' order by call_date desc limit 1;|

exiting the VDAD app, transferring call to 102
FAIL (unexpected result '')
FAIL (unexpected result '')
FAIL (unexpected result '')

XXXXXXXXXX VDAD transferred: start|stop 2006-09-09 6:06:09|2006-09-09 6:06:09
-- AGI Script agi-VDADcloser_inboundCID.agi completed, returning 0
-- Executing Playback("SIP/1000-7c7c", "transfer|skip") in new stack
-- Playing 'transfer' (language 'en')
-- Executing Dial("SIP/1000-7c7c", "sip/gs102|20|to") in new stack
-- Called gs102
-- Got SIP response 486 "Busy Here" back from 132.238.97.97
-- SIP/gs102-bdda is busy
== Everyone is busy/congested at this time
-- Executing VoiceMail("SIP/1000-7c7c", "u102") in new stack
-- Playing 'vm-theperson' (language 'en')
Sep 9 06:06:12 WARNING[3612]: channel.c:472 ast_channel_walk_locked: Avoided initial deadlock for 'SIP/1000-7c7c', 10 retries!
-- Playing 'digits/1' (language 'en')
== Spawn extension (default, 102, 3) exited non-zero on 'SIP/1000-7c7c'
-- Executing DeadAGI("SIP/1000-7c7c", "call_log.agi|h") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/call_log.agi
+++++ CALL LOG HUNGUP: |1157810768.21|SIP/1000-7c7c|h|2006-09-09 6:06:14|min: |
-- AGI Script call_log.agi completed, returning 0
-- Executing DeadAGI("SIP/1000-7c7c", "VD_hangup.agi|PRI-----NODEBUG-----17-----BUSY----------") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/VD_hangup.agi
Perl Environment Dump:
0|PRI-----NODEBUG-----17-----BUSY----------|
AGI Environment Dump:
-- accountcode =
-- callerid = Y090960609000000053
-- channel = SIP/1000-7c7c
-- context = default
-- dnid = 8000
-- enhanced = 0.0
-- extension = h
-- language = en
-- priority = 2
-- rdnis = unknown
-- request = VD_hangup.agi
-- type = SIP
-- uniqueid = 1157810768.21
AGI Environment Dump: |1157810768.21|SIP/1000-7c7c|h|SIP|Y090960609000000053||2|

DEBUG: NODEBUG

VD_hangup : Y090960609000000053 SIP/1000-7c7c 2
+++++ VD hangup START : |1157810768.21|SIP/1000-7c7c|h|SIP|Y090960609000000053|53|2006-09-09 6:06:14||2||


|SELECT lead_id,callerid FROM vicidial_auto_calls where uniqueid = '1157810768.21' limit 1;|
-- VDAC record deleted: |1| |53|1157810768.21|Y090960609000000053|132.238.97.70


|SELECT start_epoch,status FROM vicidial_log where uniqueid='1157810768.21' and lead_id='53' limit 1;|

VD hangup: no VDL record found: 1157810768.21 53 1157810768.21


|SELECT start_epoch,status,closecallid FROM vicidial_closer_log where lead_id = '53' and call_date > "2006-09-09 00:06:14" order by call_date desc limit 1;|


|UPDATE vicidial_list set status='DROP' where lead_id = '53';|
-- VDAD vicidial_list update: |1|53


|UPDATE vicidial_log set status='DROP', end_epoch='1157810774',length_in_sec='5' where uniqueid = '1157810768.21';|
-- VDAD vicidial_log update: |0|1157810768.21|


|UPDATE vicidial_closer_log set status='DROP',end_epoch='1157810774',length_in_sec='5' where closecallid = '49';|

-------------------------------------------------------------
I FOUND BOTH CALL create two records in vicidial_list,
when i delete this two records from vicidial_list,I CAN CALL IN AGAIN!
---------------------

53 2006-09-09 06:06:09 20060909060614 DROP 1000 SALESLINE VDCL 0 -5.00 Y 1000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL SALESLINE 1000 1
52 2006-09-09 05:57:40 20060909060547 DEC 7777 SALESLINE VDCL 0 -5.00 Y 1000 0000-00-00 SALESLINE 1000 1
===============================================
my system is slackware 10.2,asterisk1.010

pls help,thanks!

What information do you want to appear when an inbound call comes in?

to do a lookup against the existing database you need to use the CIDlookup AGI script for inbound.

when a call come into vicidial,vicidial can display the caller 's information?
if the caller's dn in the vicidial_list,will it do it?
but now,my vicidial just display below information
Vendor ID: SALESLINE
Phone: 1000
Show: SALESLINE
Comments: 1000

You should really do a test with the agi-VDADcloser_inboundCIDlookup.agi script instead and do it over live lines with real callerID delivery.

Scalar found where operator expected at /var/lib/asterisk/agi-bin/agi-VDADcloser _inboundCIDlookup.agi line 271, near "$dbhA"
(Missing semicolon on previous line?)
syntax error at /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCIDlookup.agi li ne 271, near "$dbhA"
Execution of /var/lib/asterisk/agi-bin/agi-VDADcloser_inboundCIDlookup.agi abort ed due to compilation errors.




IS THIS A BUG?

yes,a smaill error,SLOVED.

ANOTHER PROBLEM,below 1.....7,total seven option,but "CL_GALLERIA-----7275555134-----Closer-----park----------999-----1)
"
just SIX argument???????
why???




# ; 1. the full name of the IN GROUP to be used in vicidial for the inbound call
# ; 2. the phone number that was called, for the log entry
# ; 3. the callerID or lead_id of the person that called(usually overridden)
# ; 4. the park extension audio file name if used
# ; 5. the status of the call initially(usually not used)
# ; 6. the list_id to insert the new lead under if it is new (and callerID available)
# ; 7. the phone dialing code to insert with the new lead if new (and callerID available)
#
# ;inbound VICIDIAL calls:
#exten => 1234,1,Ringing ; call ringing
#exten => 1234,2,Wait(1) ; Wait 1 second for CID delivery from PRI
#exten => 1234,3,Answer ; Answer the line
#exten => 1234,4,AGI(agi-VDADcloser_inboundCID.agi,CL_GALLERIA-----7275555134-----Closer-----park----------999-----1)
#exten => 1234,5,Hangup

between park and 999 are 10 dashes, the delimiter is five dashes so the field is empty.

7275555134，HOW to use it?
like below?

; Extension 7275551212 - Inbound local number from PRI with 10 digit delivery
exten => 7275551212,1,Ringing
exten => 7275551212,2,Wait(1)
exten => 7275551212,3,AGI(call_logCID.agi,${EXTEN}-----${CALLERID}-----${CALLERIDNUM}-----${CALLERIDNAME})
exten => 7275551212,4,Answer
exten => 7275551212,5,Dial,sip/spa2000&sip/spa2001|30|to
exten => 7275551212,6,Voicemail,u2000


what the meaning of " 2. the phone number that was called, for the log entry"?????if no here,what will happen?

The 2 priority to Wait for one second is so that CallerID information can be received on the call. This is necessary on most PRI circuits.

exten => 1234,4,AGI(agi-VDADcloser_inboundCID.agi,CL_GALLERIA-----7275555134-----Closer-----park----------999-----1)

what does usement of "7275555134"?

"the phone number that was called, for the log entry",what's meaning????
it just log sth in the mysql??dont matter with vicidial????

pls help me

It is actually placed in the "user" field when the call is placed into the vicidial_list table as a new lead, Other than that it is unused.