table custom field incomplete

[intrepid]

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

[intrepid]

help please

[santhuarnold]

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

[intrepid]

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

[intrepid]

help please

[santhuarnold]

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

[intrepid]

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

[omarrodriguezt]

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

[santhuarnold]

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

[intrepid]

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

[Iz3k34l]

can you post the query you are trying to run