problem in table vicidial_list

[gattaba]

hello,
I have a problem in the table vicidial_list the number of calls that agents receive in a day does not match what is in the table vicidial_list:
ps: whenever an agent receives a call he wrote in the comments field of the interface agent the reason for this call. and I export the content in an excel file.

Goautodial 2.0
Vicidial
VERSION: 2.2.1-237
BUILD: 100510-2015
Asterisk-1.4.27.1-1
Vtiger version 5.1.0
Centos 6.3
digium card : TE122

[Framercy]

Hello,

why do you think they have to match?

In Table vicidial_list are stored all your leads. There is no correlation to the amount of calls an Agent daily gets.
The only field in Table vicidial_list that would possibly fit is the called_count field. But there are only counted the calls/trys that each lead had. Just what the name of the field suggests.

The Number of calls an agent got per day has to be queried from the log tables!

Hope this helps...

Best regards

[gattaba]

I hurt my question, in fact here I manages a call center for a telecomunication company. So when an agent receives a call puts it in the comments field of the interface agent because of the customer's call. I must daily export the contents of the table vicidial_list more precisely the comment column to send to the telecom company to know that the reason for the call.
my problem and that when a client calls twice the old value of the field comment is erased.
I configured the In-Group Call Handle Method to CIDLOOKUP.
excuse for my english.
can u help me
thanks

[ZoVoS]

as always no guaranties...

isn't that what the option "call notes per call" on the vicidial campaign settings is for

*Call Notes Per Call* - Setting this option to ENABLED will allow agents to enter in notes for every call they handle in the agent interface. The notes entry field will appear below the Comments field in the agent interface. Also, if the Agent User Group is allowed to view Call Logs then the agent will be able to view past call notes for a lead at any time. Default is DISABLED.

[gattaba]

thanks but i dont see that option where is he

[ZoVoS]

ill have to check if 2.2.1-237 supports this option (it may not. 2.2 is very old)
If not you may have to update. It's not as scary as you think.
Its simply a case of updating your DB schema a few times and then running install.pl

[gattaba]

ok are you there a tutorial for the update

[ZoVoS]

Many i'll see if I can find you a link.

viewtopic.php?f=8&t=16326

That should be sufficient. Be careful, especially as this is a live server.

Personally I would backup the entire MySQL database first manually before even attempting the automated backup.

[williamconley]

There is an article in the Vicidial Wiki (link at the top of this page, look for SVN How To) which has a link at the bottom of the article to a forum post (quite possibly the one above) with even more information.

and don't just back up the db, back up everything and make particular note of your SVN revision level ("svn info" in the source code folder) if you are using an SVN install. Of course, if you are merely using a static installer that did not use SVN, be sure it's handy.

however: we have (so far) never had to abort an upgrade unless there were massive customizations to the code by the client. And then we always upgrade in a sandbox first!

[gattaba]

I translated the interface in French VICIDIAL I'll lose the translation after the upgrade. is it possible to re-translate the new version

thanks

[DomeDan]

When I've done a upgrade I run the build translation script after "perl ./install.pl"
/usr/share/astguiclient/build_translation_www_files.pl --client-only --language=fr
if you wrote your own translation file you need to add that one to translations/ first (if you did it the right way and created a translation file fr_language.txt)
this deserves its own thread

[gattaba]

hello,
I did the upgrade everything works, but the interface agent VICIDIAL there is a second field notes I want to know where I retrieve data in the database

thanks

[Srinivasa Rao]

hi gattaba,

You will get your each and every incoming call details in the vicidial_closer_log table along with the call date and time.

[gattaba]

thanks Srinivasa Rao
I saw the table but in the comments column I do not see what agents are inserted.
i see just "AUTO"

[williamconley]

You should use the "export calls" report. The theory is that this export will list all calls, instead of all leads or agents.

[gattaba]

thanks williamconley
but it appears when I select the columns
"There are no outbound calls during this time period for these parameters "

[williamconley]

use less parameters start with all campaigns and all lists etc.

then pare it down slowly to get what you want.

[gattaba]

i dont undestand

[williamconley]

try a search that will result in ALL calls from ALL campaigns with ALL agents for ALL dates, ALL statuses and ALL lists (and anything else that might be available to choose ALL of). When you have too many results, you can begin to limit it (for instance to a single campaign ...?)

[gattaba]

I did this but until I get the message "There are no outbound calls falling on this time period for thesis parameters"
I have only incoming calls that it is related to its

[williamconley]

then perhaps you should try an inbound report?

[gattaba]

ok Choosing the less options the regulatory problem. thanks
how I can have excel export format

[williamconley]

if you mean excel as opposed to csv, that would be accomplished by paying someone to modify your download format. if you mean csv (which is easily read by excel), then there will be a Download link on the screen if that format is available. If not ... upgrade to see if the report you are on has a download button in a later version.

[gattaba]

ok thanks what tables the database I can retrieve the data of custum fields.

[williamconley]

custom field data is stored in a table named "custom_XXXXX" where "XXXXX" is the list id.

[gattaba]

in my database there is no table custum_xxxx

[williamconley]

if your "asterisk" database has no "custom_XXXX" tables, you have no custom field data.