Page 1 of 1

what is the purpose for these columns?

PostPosted: Fri Feb 24, 2012 3:56 pm
by bobbymc
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?

PostPosted: Sun Feb 26, 2012 2:40 pm
by Trying
This question should be in general, not development.

PostPosted: Fri Mar 02, 2012 3:16 pm
by Acidshock
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.

Re: what is the purpose for these columns?

PostPosted: Sun Jul 15, 2012 3:21 am
by bobbymc
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.

Re: what is the purpose for these columns?

PostPosted: Sun Jul 15, 2012 10:26 pm
by williamconley
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).

Re: what is the purpose for these columns?

PostPosted: Mon Jul 16, 2012 4:16 am
by bobbymc
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

Re: what is the purpose for these columns?

PostPosted: Mon Jul 16, 2012 3:26 pm
by mflorell
admin.php version and build?

Re: what is the purpose for these columns?

PostPosted: Mon Jul 16, 2012 4:37 pm
by bobbymc
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

Re: what is the purpose for these columns?

PostPosted: Mon Jul 16, 2012 7:10 pm
by williamconley
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.

Re: what is the purpose for these columns?

PostPosted: Mon Jul 16, 2012 7:12 pm
by bobbymc
sorry here it is :

VERSION: 2.0.5-174
BUILD: 90522-0506

Re: what is the purpose for these columns?

PostPosted: Mon Jul 16, 2012 7:15 pm
by williamconley
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. :)

Re: what is the purpose for these columns?

PostPosted: Mon Jul 16, 2012 7:21 pm
by bobbymc
haha i will make sure to do so in the future.. =) matt any input would be greatly appreciated =)