Page 1 of 1

I need to know things about the call_log table

PostPosted: Fri Mar 08, 2013 8:28 am
by legin
Hi eveyone, I am getting started with GoAutoDial and I see in the Data Base the table called "call_log" it does record data in ir, but I need to know where are they coming from.

The thing is that I do see every kind of data there, the "channel" field is getting so much different data, also the "channel_group" field, the "type" field also, the "extension" field too, and the last one is the "caller_code" field. I really need to know where do I configure these data.

I attach an image for you to have an idea of what I am toalking about, thanx for everything!

http://goautodial.org/attachments/1163/goautodial.png

Re: I need to know things about the call_log table

PostPosted: Fri Mar 08, 2013 10:26 am
by williamconley
1) Welcome to the Party! 8-)

2) You're a newbie and did not post your specs, so you are entitled to the Newbie Suggestions:

when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) There are many reports available in the reports page. These reports probably have all the data you seek, and pull from various log tables in the system. But you do not "configure" them they are already configured and already have the data needed for the reports. Since you did not state the data you seek ... nor your software version ... it's difficult to help you. Advice: go through the reports to find the data you seek and ask where the data for that report comes from (and if you add "&DB=1" to the URL when looking at the report, you will often see the SQL commands needed to generate the report ... thus the names of the fields and tables used to create it!).

4) Happy hunting! 8-)

Re: I need to know things about the call_log table

PostPosted: Fri Mar 08, 2013 11:50 am
by legin
Hi, I always forgot to put the software version, sorry about that

GoAutoDial CE 2.1 | Asterisk 1.4.39.1-vici | Single Server | No Digium Hardware | No Extra Software After Installation | Intel(R) Core(TM)2 Quad CPU Q8200 @ 2.33GHz

I am not trying to seek for any data specifically, I just want to understand the "call_log" table, from where are the data on that table come from that is all, tahnx!

Re: I need to know things about the call_log table

PostPosted: Fri Mar 08, 2013 1:12 pm
by williamconley
Run a report. Compare the report data to the table. Find your matches and you have your answer.

Re: I need to know things about the call_log table

PostPosted: Tue Mar 12, 2013 7:34 am
by legin
Ok thanx williamconley... I'll try that