vicidial.org

Hello,
I created custom field that appears automatically at each call, the information that agents write in this custom field are stored in the table custom_112.
My problem is that every day I use a sql query to retrieve data from this table but the result I get does not match the total number of calls I get.
I think the custom field does not save all data entered after each call.
Can someone help me solve this problem you.
thank you


Goautodial 2.0
Vicidial
VERSION: 2.6-392a svn
BUILD: 130102-1135
Asterisk-1.4.27.1-1
Vtiger version 5.1.0
Centos 6.3
digium card : TE122

help please

To retrieve data why you go to SQL.?

Go to Reports-->Select Export Calls Report/ Export Lead Report Report ->Select Custom Fields:Yes ---> Export Fields:EXTENDED.
and select your option like campaign,list,status etc and Give submit..

Thanks
santhuarnold

thanks santhuarnold
i have this message when i submit "There are no outbound calls during this time period for these parameters"
thanks for help

help please

i guess you are not selecting proper option in report, please select the all campaigns, list,user-group and check.

or if any database problem (common issue)
Run this in server

mysqlcheck -u cron -p --auto-repair --all-databases

password- 1234

thanks
santhuarnold

thank you
I come now to export but it is txt format.
how can I export to exel format.
thank you

When you are saving the file, just add .xls at the end (remove .txt), and you will be able to open it on excel.

txt format is default option for report. download it and copy to EXCEL.
or open with excel.

thank you
but I must group the results and it's easier for me to run the sql query.
is that I can have sql query that generates this file.
Thank you

can you post the query you are trying to run