what is the purpose for these columns?

Discussions about development of VICIDIAL and astGUIclient

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

what is the purpose for these columns?

Postby bobbymc » Fri Feb 24, 2012 3:56 pm

i see the columns campaign_rank in vicidial_campaign_agents

and group_rank in vicidial_inbound_group_agents but for the life of me cant figure out the purpose of these columns?!

Matt can you shed any light on this please?
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am

Postby Trying » Sun Feb 26, 2012 2:40 pm

This question should be in general, not development.
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

Postby Acidshock » Fri Mar 02, 2012 3:16 pm

Sounds like a development question to me. He wants to know the inner workings for something hes writing.

I think they are for ranking agents when routing calls based on the agents rank in the campaign. IE agents with better rank get preference on the calls.

From the help file when setting those fields under the user details:
You will also be able to set the rank, or skill level, in this section for each of the inbound groups as well as being able to see the number of calls received from each inbound group for this specific agent. Also in this section is the ability to give the agent a rank for each inbound group. These ranks can be used for preferred call routing when that option is selected in the in-group screen.
Acidshock
 
Posts: 430
Joined: Wed Mar 03, 2010 3:19 pm

Re: what is the purpose for these columns?

Postby bobbymc » Sun Jul 15, 2012 3:21 am

sorry let me ask this better.. i dont see any code such as the perl deamon scritps or agi scritps that make use of it and i was wondering where its being accessed.
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am

Re: what is the purpose for these columns?

Postby williamconley » Sun Jul 15, 2012 10:26 pm

one would assume it is used in routing of calls to agents at the moment this becomes necessary (such as an Answer being routed to an agent in 8368 ...). This should result in the routing exten being sent to the appropriate agi script which should take these settings into account when choosing an agent. Perhaps they are loaded during the sql call but not referred to by name inside the script (most of the sql in vicidial, if not all, uses field indexes instead of field names).
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: what is the purpose for these columns?

Postby bobbymc » Mon Jul 16, 2012 4:16 am

can matt verfiy this? if its used in sql i would assume it be a trigger or some type of sql function, but as far as im aware no sql functions or triggers exsist
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am

Re: what is the purpose for these columns?

Postby mflorell » Mon Jul 16, 2012 3:26 pm

admin.php version and build?
mflorell
Site Admin
 
Posts: 18386
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: what is the purpose for these columns?

Postby bobbymc » Mon Jul 16, 2012 4:37 pm

2.0.5rc5.. i cant update it autoamticly like others because i customized it so much.. i have no issues backporting it i just wanted to see if those clumns have any logic at this point? and if so what scritps are they implemented in
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am

Re: what is the purpose for these columns?

Postby williamconley » Mon Jul 16, 2012 7:10 pm

Version accounted for, but you did not post the build. It is in the admin screens under the Version (on almost all the pages). Required for support on this site.
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: what is the purpose for these columns?

Postby bobbymc » Mon Jul 16, 2012 7:12 pm

sorry here it is :

VERSION: 2.0.5-174
BUILD: 90522-0506
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am

Re: what is the purpose for these columns?

Postby williamconley » Mon Jul 16, 2012 7:15 pm

Of course it is entirely possible that this version (being very old) has no use for these, but then again at least you now have the "minimum" requirement for getting an answer. Too bad you didn't have it before ... Matt would probably have answered the question if he'd had the version (so he could tell you, since features are all version based!). But maybe he'll be back. :)
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: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: what is the purpose for these columns?

Postby bobbymc » Mon Jul 16, 2012 7:21 pm

haha i will make sure to do so in the future.. =) matt any input would be greatly appreciated =)
bobbymc
 
Posts: 425
Joined: Fri Jan 05, 2007 12:26 am


Return to Development

Who is online

Users browsing this forum: No registered users and 19 guests