vicidial.org

Posted: **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

Posted: **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.

Posted: **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.

Posted: **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.

Posted: **Fri Jan 28, 2011 11:57 am**

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

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:

Posted: **Fri Jan 28, 2011 12:41 pm**

vicidial_campaign_stats

vicidial_campaign_server_stats

Posted: **Sat Jan 29, 2011 12:18 pm**

SOLVED. SEE THIS THREAD: http://www.vicidial.org/VICIDIALforum/v ... 1745#61745

Posted: **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:

Posted: **Tue Aug 02, 2011 11:43 am**

you have those two tables, but do those tables have any records in them?

Posted: **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.

Posted: **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]

Posted: **Thu Aug 04, 2011 8:47 am**

Posted: **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

Posted: **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?)

Posted: **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.

Posted: **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!

Posted: **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!

Posted: **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.org

Call count not showing in real-time report

Call count not showing in real-time report

Re: Call count not showing in real-time report

Re: Call count not showing in real-time report