need help in reports

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

need help in reports

Postby muyousif » Tue Feb 16, 2016 1:57 pm

Hello experts, can I get area and city too with the called calls? I uploaded these with the leads and now need to get with called leads / calls. is that possible?
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
muyousif
 
Posts: 119
Joined: Wed May 14, 2014 5:29 am

Re: need help in reports

Postby williamconley » Tue Feb 16, 2016 2:33 pm

1) Welcome to the Party! 8-)

2) As you are obviously new here, I have some suggestions to help us all help you:

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) I have a pet peeve about subject lines in posts that have no actual description. Perhaps you could edit the subject line to read "How do I get area and city on Reports?"

4) You should list the URL and/or Title of the report(s) to which you'd like this information added. There are a lot of reports. And different versions of Vicidial (which you neglected to list, LOL) have different reports available.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: need help in reports

Postby muyousif » Fri Feb 19, 2016 11:20 am

Yes sorry about the Subject but would try to be concise in future posts :-). I am supposing to get this from mysql query but if it is possible in any "report" that would be great. My vicidial info given below:

VERSION: 2.12-493a
BUILD: 150703-2105
© 2015 ViciDial Group
ViciBox v.6.0.3 | VERSION: 2.14-685a BUILD: 180825-2100| Asterisk 1.8.29 | Cluster: 1 DB: 16Core@2.67GHz 16RAM | 1 WEB: 8Core@2.50GHz 16RAM | 8 Tel: QuadCore@2.93GHz 8RAM
muyousif
 
Posts: 119
Joined: Wed May 14, 2014 5:29 am

Re: need help in reports

Postby williamconley » Fri Feb 19, 2016 11:29 am

In which case I strongly suggest that you check all the reports available on your server and see if any of them contain the details you require. For instance, some reports may be capable of custom field export. But mysql is easier (for some of us, LOL)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: Google [Bot] and 44 guests