exporting call records with dispositions

[MJ]

Hello!

I'm new to asterisk and vicidial. I've been able to configure vicidial to dial a campaign without any agents logging in, but i'm having trouble exporting the results of the calls from the sql database. I can't seem to find what table contains the disposition of the call. What i'm trying to export from the campaign is the phone number, call time and date, and the disposition. Can someone let me know where i'm supposed to look?

[kchung]

Have you installed phpMyAdmin? It makes it a whole lot easier to explore your db.

vicidial_list contains all your calls. the field 'status' is the disposition.

[MJ]

I just checked that table and all of the records have "NEW" as the status. All these records were just called yesterday.

[kchung]

Check also vicidial_log.

[MJ]

That table is blank.
I hope i don't have something configured incorrectly.

[mflorell]

Please explain in detail how you have your campaign set up and how you are playing a message to the people you are calling.

[MJ]

I followed tutorial E. in the Manager manual on page 59 to set this campaign up.


Campaign ID: NoAgents
Campaign Name: Agentless Campaign
Active: Y
Park Extension: 8301
Park Filename: park
Web Form:
Allow Closers: Y
Dial status 1: NEW
Dial status 2: NEW
Dial status 3: NEW
Dial status 4: NEw
Dial status 5: NEw
List Order: DOWN
Lead Filter: NONE
Hopper Level: 50
Auto Dial Level: 1.1
Next Agent Call: oldest_call_start
Local Call Time: 8am to 9pm
Dial Timeout: 60sec
Dial Prefix: 9
Campaign VDAD exten: 85100001
Campaign Rec exten: 8309
Campaign Recording: ondemand
Campaign Rec Filename: fulldate_custphone
Get Call Launch: none
AMD Send to VM exten: N
Alt Number Dialing: N
Scheduled Callbacks: N
Drop Call Seconds: 5
Voicemail:
Use Safe Harbor Message: N
Safe Harbor Exten: 8307
Wrapup Seconds: 0
Wrapup Message: Wrapup Call
Use Internal DNC List: Y


List id = wednesday
Campaign = NoAgents

STATUSES WITHIN THIS LIST:
STATUS STATUS NAME CALLED NOT CALLED
NEW New Lead 2032 6
SUBTOTALS 2032 6
TOTAL 2038


TIME ZONES WITHIN THIS LIST:
GMT OFFSET NOW (local time) CALLED NOT CALLED
-7.00 (Thu Sep 2006 11:43) 2004 6
-6.00 (Thu Sep 2006 12:43) 2 0
-5.00 (Thu Sep 2006 13:43) 4 0
-4.00 (Thu Sep 2006 14:43) 22 0
SUBTOTALS 2032 6
TOTAL 2038


CALLED COUNTS WITHIN THIS LIST:
STATUS STATUS NAME 0 1 SUBTOTAL
NEW New Lead 6 2032 2038
TOTAL 6 2032 2038


Remote Agent
UserId Start: 6969
Number of lines: 15
server ip: 192.168.0.3
Campaign: NoAgents

[mflorell]

For no-agent campaigns you should actually use a regular VDAD exten(8365) and use the "external extension" of the remote agent as the exten with the message on it (85100001) if you want full logging of calls and statuses on them.

This was an omission by me in the manager manual and when the 2.0.1 manager manual comes out(hopefully tomorrow) it will be fixed in there explaining more how no-agent campaigns work.

Thanks for mentioning this. Let me know how it works when you make these changes.

When the new Manager Manual is released you can go to the re-download page that was emailed to you and use your email address and passcode to download the updated manual.

[MJ]

I'll try that out.

[mflorell]

I just updated the Manager Manual and it is available for download.