vicidial.org

VICIDIAL astGUIclient discussion forum

Skip to content

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


Call count not showing in real-time report

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Post a reply

Call count not showing in real-time report

Postby Trying » Fri Jan 28, 2011 2:57 am

Hi

Our "calls today" and "dropped-answered" counts do not show in the real-time report for both outbound and inbound although the agent made 65 calls:


DIAL LEVEL: 2.000 TRUNK SHORT/FILL: 0 / 0 FILTER: NONE TIME: 2011-01-28 09:48:45
DIALABLE LEADS: 91168 CALLS TODAY: 0 AVG AGENTS: 0.90 DIAL METHOD: RATIO
HOPPER ( min/auto ): 10 / 6 DROPPED / ANSWERED: 0 / 0 DL DIFF: 0.12 STATUSES: NEW
LEADS IN HOPPER: 12 DROPPED PERCENT: 0% DIFF: 13.89% ORDER: DOWN

Please help because I really don't want to re-install again
:)
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa
Top

Postby williamconley » Fri Jan 28, 2011 10:28 am

Please help because I really don't want to re-install again
Lazy bum. LOL

How long did you wait before deciding it wasn't going to show up? that process runs "occasionally". Also there is a switch in the campaign to "force" it to run at the next opportunity. Campaign Stats Refresh.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)
Top

Postby Trying » Fri Jan 28, 2011 11:35 am

Thanks for responding Bill. The agent has been dialing all day now and still no call counts. Campaign stats refresh has been set to Y all along. His amount of calls show in all other reports.
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa
Top

Postby williamconley » Fri Jan 28, 2011 11:48 am

it's not supposed to be set to Y all day long. it should reset itself to "n" after the refresh occurs if i recall correctly.

This is generally an indication of overload or inability to complete the task.

Changed server ip without fully changing throughout the entire system?

Missing stats table entry?

Weirdness ensues.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)
Top

Postby Trying » Fri Jan 28, 2011 11:57 am

Only one agent dialing on the server so it is not even idling :D

Missing stats table entry - Where would I look for this?

All the servers' ip addresses I've set up during the initial installation and nothing changed after that.

Weirdness ensues..... INDEED!! I must change my forum ID to WEIRDNESS! :lol:
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa
Top

Postby williamconley » Fri Jan 28, 2011 12:41 pm

vicidial_campaign_stats

vicidial_campaign_server_stats
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)
Top

Postby Trying » Sat Jan 29, 2011 12:18 pm

SOLVED. SEE THIS THREAD: http://www.vicidial.org/VICIDIALforum/v ... 1745#61745
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa
Top

Postby xhunnn » Tue Aug 02, 2011 9:11 am

i have this 2 tables in my database
and also i changed it the localhost to 127.0.0.1

vicidial_campaign_stats
vicidial_campaign_server_stats


still "0" value when the agents are incall
calls today:
dropped/aswered:
dropped percent:

do u have any idea to solve this bug?
i do appreciate your help

Thanks!





Vicibox Redux 3.1.9 | Admin VERSION: 2.4-322a BUILD: 110703-1400 | Agent VERSION: 2.4-333c BUILD: 110626-2234
Linux 2.6.34.8-0.2-pae #1 SMP | Perl v5.12.1 | Asterisk 1.4.39.1-vici | Mysql 14.14 Distrib 5.1.46 | PHP 5.3. :lol:
xhunnn
 
Posts: 42
Joined: Fri May 20, 2011 8:54 pm
Top

Postby williamconley » Tue Aug 02, 2011 11:43 am

you have those two tables, but do those tables have any records in them?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)
Top

Postby xhunnn » Tue Aug 02, 2011 12:15 pm

i had checked it but still there is no data those two tables.

most of the #'s that i can see is "0"

do i miss some configuration or settings?


Vicibox Redux 3.1.9 | Admin VERSION: 2.4-322a BUILD: 110703-1400 | Agent VERSION: 2.4-333c BUILD: 110626-2234
Linux 2.6.34.8-0.2-pae #1 SMP | Perl v5.12.1 | Asterisk 1.4.39.1-vici | Mysql 14.14 Distrib 5.1.46 | PHP 5.3.
xhunnn
 
Posts: 42
Joined: Fri May 20, 2011 8:54 pm
Top

Postby xhunnn » Tue Aug 02, 2011 12:23 pm

just take a look at the image



vicidial_campaign_stats : http://tinypic.com/r/dz8p42/7

vicidial_campaign_server_stats : http://tinypic.com/r/69oxt0/7


Vicibox Redux 3.1.9 | Admin VERSION: 2.4-322a BUILD: 110703-1400 | Agent VERSION: 2.4-333c BUILD: 110626-2234
Linux 2.6.34.8-0.2-pae #1 SMP | Perl v5.12.1 | Asterisk 1.4.39.1-vici | Mysql 14.14 Distrib 5.1.46 | PHP 5.3. [/img]
xhunnn
 
Posts: 42
Joined: Fri May 20, 2011 8:54 pm
Top

Postby xhunnn » Thu Aug 04, 2011 8:47 am

any idea?

Vicibox Redux 3.1.9 | Admin VERSION: 2.4-322a BUILD: 110703-1400 | Agent VERSION: 2.4-333c BUILD: 110626-2234
Linux 2.6.34.8-0.2-pae #1 SMP | Perl v5.12.1 | Asterisk 1.4.39.1-vici | Mysql 14.14 Distrib 5.1.46 | PHP 5.3. [/img]
xhunnn
 
Posts: 42
Joined: Fri May 20, 2011 8:54 pm
Top

Postby suneyo21 » Tue Sep 13, 2011 6:42 pm

Since a statistic of # of drop calls is showing on the real time monitoring, where can i extract those dropped calls so that i can gave it to agents and they can dial it manually

Thanks in Advance
Linux User 499634 (http://counter.li.org)
suneyo21
 
Posts: 35
Joined: Fri Sep 12, 2008 11:27 am
Top

Postby williamconley » Tue Sep 13, 2011 7:29 pm

xhunnn wrote:any idea?

Vicibox Redux 3.1.9 | Admin VERSION: 2.4-322a BUILD: 110703-1400 | Agent VERSION: 2.4-333c BUILD: 110626-2234
Linux 2.6.34.8-0.2-pae #1 SMP | Perl v5.12.1 | Asterisk 1.4.39.1-vici | Mysql 14.14 Distrib 5.1.46 | PHP 5.3. [/img]

1) did you look here:
Trying wrote:SOLVED. SEE THIS THREAD: http://www.vicidial.org/VICIDIALforum/v ... 1745#61745

2) you DO have server stats active in the server settings/system settings? (And you have the manual, right?)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)
Top

Postby williamconley » Tue Sep 13, 2011 7:31 pm

suneyo21 wrote:Since a statistic of # of drop calls is showing on the real time monitoring, where can i extract those dropped calls so that i can gave it to agents and they can dial it manually

Thanks in Advance
those records will be in the original list and will have a status of DROP or PDROP. You can generally just wait until the opportune moment and change the campaign to deal with those two statuses ONLY (in manual dial mode) and then go back to regular business OR you can create a script to move them to a special campaign OR you can "search" for them in the "Find Leads" item in the leads menu (search for DROP in that list_id) and manually change them to CALLBK with a date/time/agent specified.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)
Top

Postby suneyo21 » Tue Sep 13, 2011 7:45 pm

Got it! Thanks! Manually search it from the list, this is what i'm looking for a VDCL triggered or disposed call.

A more convenient way is to search or preview stat from the VDCL user similar to this http://<dialer.IP>/vicidial/user_stats.php?user=VDCL so that you can specify a date range compared to search for a lead wherein all is displayed and no date on a snap shot.

Thanks William!
Linux User 499634 (http://counter.li.org)
suneyo21
 
Posts: 35
Joined: Fri Sep 12, 2008 11:27 am
Top

Re: Call count not showing in real-time report

Postby necival » Fri Apr 18, 2014 5:48 pm

Hi William, how are you?

ViciBox Redux v.3.1.15 release
VERSION: 2.8-408a
BUILD: 130711-2208

I have the same issue with realtime stats all 0. I tried both localhost and 127.0.0.1... Everything else is working, but my vicidial_campaign_stats is all 0's.

Code: Select all
+-------------+---------------------+----------------+-------------+---------------+-------------+-----------------+-------------------------+------------+--------------+------------+----------------+----------------+------------------+----------------+--------------------+---------------+-----------------+---------------+-------------------+--------------+----------------+--------------+------------------+---------------------+-----------------------+--------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------+---------------------+-----------------------+---------------------+----------------------+-------------------+------------------+----------------------+-----------------+-------------------+
| campaign_id | update_time         | dialable_leads | calls_today | answers_today | drops_today | drops_today_pct | drops_answers_today_pct | calls_hour | answers_hour | drops_hour | drops_hour_pct | calls_halfhour | answers_halfhour | drops_halfhour | drops_halfhour_pct | calls_fivemin | answers_fivemin | drops_fivemin | drops_fivemin_pct | calls_onemin | answers_onemin | drops_onemin | drops_onemin_pct | differential_onemin | agents_average_onemin | balance_trunk_fill | status_category_1 | status_category_count_1 | status_category_2 | status_category_count_2 | status_category_3 | status_category_count_3 | status_category_4 | status_category_count_4 | hold_sec_stat_one | hold_sec_stat_two | agent_non_pause_sec | hold_sec_answer_calls | hold_sec_drop_calls | hold_sec_queue_calls | agent_calls_today | agent_wait_today | agent_custtalk_today | agent_acw_today | agent_pause_today |
+-------------+---------------------+----------------+-------------+---------------+-------------+-----------------+-------------------------+------------+--------------+------------+----------------+----------------+------------------+----------------+--------------------+---------------+-----------------+---------------+-------------------+--------------+----------------+--------------+------------------+---------------------+-----------------------+--------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------+---------------------+-----------------------+---------------------+----------------------+-------------------+------------------+----------------------+-----------------+-------------------+
| TESTCAMP    | 2014-04-10 20:01:21 |              0 |           0 |             0 |           0 | 0               | 0                       |          0 |            0 |          0 | 0              |              0 |                0 |              0 | 0                  |             0 |               0 |             0 | 0                 |            0 |              0 |            0 | 0                | 0                   | 0                     |                  0 | NULL              |                       0 | NULL              |                       0 | NULL              |                       0 | NULL              |                       0 |                 0 |                 0 |                   0 |                     0 |                   0 |                    0 |                 0 |                0 |                    0 |               0 |                 0 |
| COMPRO      | 2014-04-18 11:00:01 |          18605 |           0 |             0 |           0 | 0               | 0                       |          0 |            0 |          0 | 0              |              0 |                0 |              0 | 0                  |             0 |               0 |             0 | 0                 |            0 |              0 |            0 | 0                | 0                   | 0                     |                  0 | NULL              |                       0 | NULL              |                       0 | NULL              |                       0 | NULL              |                       0 |                 0 |                 0 |                   0 |                     0 |                   0 |                    0 |                 0 |                0 |                    0 |               0 |                 0 |
+-------------+---------------------+----------------+-------------+---------------+-------------+-----------------+-------------------------+------------+--------------+------------+----------------+----------------+------------------+----------------+--------------------+---------------+-----------------+---------------+-------------------+--------------+----------------+--------------+------------------+---------------------+-----------------------+--------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------------+-------------------+-------------------+---------------------+-----------------------+---------------------+----------------------+-------------------+------------------+----------------------+-----------------+-------------------+



Code: Select all
+-------------+---------------+---------------------+----------------------+
| campaign_id | server_ip     | update_time         | local_trunk_shortage |
+-------------+---------------+---------------------+----------------------+
|             | 192.228.99.87 | 2014-04-18 18:46:59 |                    0 |
+-------------+---------------+---------------------+----------------------+



Thanks in advance!
necival
 
Posts: 23
Joined: Tue Jul 31, 2012 4:35 pm
Top

Re: Call count not showing in real-time report

Postby williamconley » Wed Apr 23, 2014 11:55 pm

Recent problem? Just happened today? Brand new server or 3 year old server?

Checked for crashed tables yet?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20019
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)
Top
Post a reply

Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 69 guests

Powered by phpBB® Forum Software © phpBB Group