<div dir="ltr">Mel,<div><br></div><div>Can you repeat the steps on <a href="http://demo.vtiger.com">demo.vtiger.com</a> and report the same?</div></div><div class="gmail_extra"><br clear="all"><div><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><b>Connect with us on: </b><a href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)" target="_blank">Twitter</a> <b>I</b> <a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" style="color:rgb(0,0,204)" target="_blank">Facebook</a> <b>I</b> <a href="https://blogs.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Blog</a><b> I</b> <a href="http://wiki.vtiger.com/index.php/Main_Page" style="color:rgb(0,0,204)" target="_blank">Wiki</a> <b>I </b><a href="https://discussions.vtiger.com" style="color:rgb(0,0,204)" target="_blank">Forums </a><b>I</b> <a href="https://www.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Website</a></span></div>
<br><br><div class="gmail_quote">On Thu, Aug 28, 2014 at 7:45 PM, Mel <span dir="ltr"><<a href="mailto:m.brummell@btinternet.com" target="_blank">m.brummell@btinternet.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
I have just updated to 6.1ea.<br>
<br>
Just checking to see if it's a problem with me doing the updates (as did<br>
each change manually from svn changeset 14222) or whether its just work in<br>
progress. When I go to Reports - Add Report - Charts I am presented with<br>
Report Details arrow, Filters and Select Chart but clicking on these does<br>
nothing. I have an empty screen.<br>
<br>
Regards<br>
<br>
<br>
Mel<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com">vtigercrm-developers-bounces@lists.vtigercrm.com</a><br>
[mailto:<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com">vtigercrm-developers-bounces@lists.vtigercrm.com</a>] On Behalf Of<br>
<a href="mailto:vtigercrm-developers-request@lists.vtigercrm.com">vtigercrm-developers-request@lists.vtigercrm.com</a><br>
Sent: 28 August 2014 14:17<br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: vtigercrm-developers Digest, Vol 103, Issue 320<br>
<br>
Send vtigercrm-developers mailing list submissions to<br>
<a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<br>
<a href="http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers" target="_blank">http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers</a><br>
<br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:vtigercrm-developers-request@lists.vtigercrm.com">vtigercrm-developers-request@lists.vtigercrm.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:vtigercrm-developers-owner@lists.vtigercrm.com">vtigercrm-developers-owner@lists.vtigercrm.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific than<br>
"Re: Contents of vtigercrm-developers digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: Asterisk Good News (<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 28 Aug 2014 09:16:39 -0400<br>
From: "<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>" <<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>><br>
To: "Prasad" <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>>,<br>
"<a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a>"<br>
<<a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a>><br>
Subject: Re: [Vtigercrm-developers] Asterisk Good News<br>
Message-ID: <<a href="mailto:36b5e32778e44acda2bacb054ef48c13@camden.net">36b5e32778e44acda2bacb054ef48c13@camden.net</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
I dont think there is "issue" with the java proxy approach, what I think is<br>
issue is this AGI-AMI hybrid thing you have going on, AGI is notoriously<br>
more difficult to program in to begin with, you literally have to write a<br>
proper handler for every event that might occur, plus AGI and AMI are not<br>
inherently meant to work together<br>
<br>
this is pretty easy with IVRs, we know we are sending caller there, and we<br>
can except a few limited outcomes, plus you have to use AGI to capture<br>
input, but with just a regular phone call there are to many things that can<br>
happen and we are not expecting input to capture<br>
<br>
last night we fixed up our test servers but removed the agi fire for<br>
inbound context, so we are only running the [vtiger_outbound] this means no<br>
inbound notification and no logging and voice recording of calls of those<br>
calls, we are going to test if this thing stays stable for just click to<br>
call in light of that you also found issue where inbound can be sent to<br>
endless loop<br>
<br>
in our limited testing (just one night) we noticed AMI streaming data in<br>
your webapp.sh on a inbound call without the agi fire, with some error<br>
messages we think are related to it was expecting the AGI to fire, it did<br>
not seem to effect anything and so far has not locked up and continues to<br>
work<br>
<br>
we know your using the AMI to originate outbound, and it seems your using<br>
AMI for at least part of the inbound, so the question remains why AGI at<br>
all, you guys say its to limited overhead and cut down on data you need to<br>
phrase, yet your phrasing it anyway?? if you want to cut down the data you<br>
get from the AMI stream, have the AMI user have originate and read call only<br>
rights, you will only get data the pertains to actual phone calls and cut<br>
out 95% of the data AMI would normally stream that you dont care about<br>
anyway<br>
<br>
now with AGI gone, your problems will be gone, you wont be able to as<br>
easily do your own CDR logging, and you wont be able to force all calls to<br>
be recorded (a function we dont think you should be doing anyway) however<br>
the CDR in vtiger is a good idea but there is better option<br>
<br>
use the existing SQL CDR data Asterisk will provide, you say you want to<br>
use a API, so write one, we think that is better idea that opening SQL to<br>
world if vtiger and Asterisk are not on same computer anyway<br>
<br>
<br>
write a php file that you would have asterisk admin put on asterisk server<br>
where Apache can serve up, in that php file, you need to pass it the<br>
extension and phone number(s) you are going to pull data for, have the php<br>
run the sql statements and return the data you want (date, time, callerID,<br>
source, destination, duration), we would use XML put there are lots of<br>
choices<br>
<br>
if you have free PBX check out the user panel, specifically the call<br>
monitor, what you want to do is reconstruct that but only the extension and<br>
phone numbers for that instance, you may want to drop the extension search<br>
part so if I click on a contact then go to PBX manger I see all calls to and<br>
from that contact and which colleges of mine took or placed those calls<br>
<br>
also if asterisk was told to record a call you will notice in the user<br>
panel under call monitor there is a column "monitor" if there is a recording<br>
there be 2 icons, one to download the sound file and one to listen to it,<br>
you could do the same, however I would advise to have access to recording<br>
off by default with the option for the vtiger admin to allow access on a per<br>
user basis<br>
<br>
the above would allow vtiger to tie all calls in asterisk to vtiger<br>
records, something AGI can never do, you have no control over forcing uses<br>
to click to call out of vtiger, If I know a phone number, Im not going to go<br>
searching for it to click on it, as result the call will not show in vtiger,<br>
will vtiger log call on inbound if user was not logged into vtiger?<br>
we have not tested, but if the vtiger PBX CDR records are incomplete they<br>
are no good<br>
<br>
<br>
<br>
----------------------------------------<br>
From: "Prasad" <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>><br>
Sent: Thursday, August 28, 2014 12:21 AM<br>
To: "<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>" <<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>>,<br>
"<a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a>"<br>
<<a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a>><br>
Cc: "Akshath T.A" <<a href="mailto:akshath.t@vtiger.com">akshath.t@vtiger.com</a>><br>
Subject: Re: [Vtigercrm-developers] Asterisk Good News<br>
The proxy approach taken would help us stay loose coupled with Asterisk<br>
and provide neutral interface to Vtiger. This benefit may not be obvious and<br>
sound like a overhead but give it a thought.<br>
<br>
We generally lean towards working with APIs than DB with other application<br>
- yes there would be performance benefits but would it comes against the<br>
cost of maintenance and configurations. It would be the choice to consider<br>
when you pursuing CRM and Asterisk to be on the same server.<br>
<br>
As said earlier, there are many approaches possible to get the integration<br>
- we have taken one of them that can retain loose coupling. We are<br>
interested to learn other approaches experts from our community would evolve<br>
with.<br>
<br>
Regards,<br>
Prasad<br>
<br>
<br>
Connect with us on: Twitter I Facebook I Blog I Wiki I Forums I Website<br>
On Thu, Aug 28, 2014 at 2:01 AM, <a href="mailto:vtiger@camden.net">vtiger@camden.net</a> <<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>><br>
wrote: I know it does not pull from asterisk DB at all<br>
<br>
I was saying if you did it would not be necessary to pull in intervals at<br>
all, you pull only when data is needed, the fetch cdr by clicking on pbx<br>
manger was example of needed the data that would cause a pull,<br>
<br>
if you did that it would be not be needed for vtiger to maintain its own<br>
call logging and CDR functions, it would also give bonus that calls make<br>
outside of scope of vtiger would show in PBX Manager in vtiger<br>
<br>
also pulling from asterisk vtiger would not need to force call recording on<br>
every call, which is a waste of system resources, especially if asterisk is<br>
already recording calls, not just a waste of HD space but call recording<br>
uses CPU always introduces latency into a call so you dont want both can<br>
have negative impacts on call quality<br>
<br>
by taking call recording out of vtiger you also put the decision to call<br>
record or not back in hands of asterisk admins and end users that want or<br>
dont want call recording, call centers are the only business In my<br>
experience that want every call recorded no matter what, they typically do<br>
it out of a call queue and have an announcement to satisfy legalities "your<br>
call may be recorded for quality and training" most everyone else typically<br>
just wants the feature code to turn it on and off on the fly<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
----------------------------------------<br>
From: "Akshath T.A" <<a href="mailto:akshath.t@vtiger.com">akshath.t@vtiger.com</a>><br>
Sent: Wednesday, August 27, 2014 3:45 PM<br>
To: <a href="mailto:vtiger@camden.net">vtiger@camden.net</a><br>
Cc: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: Re: [Vtigercrm-developers] Asterisk Good News<br>
<br>
?Vtiger will not poll asterisk DB every time when user clicks on<br>
PBXManager to fetch CDR. Once the call is disconnected connector would send<br>
the CDR event and vtiger would store these information in<br>
"vtiger_pbxmanager" table. So whenever PBXManager is opened Vtiger fetches<br>
information from this table and displays it for the user.<br>
<br>
<br>
regards,<br>
AKshath<br>
<br>
On Wed, Aug 27, 2014 at 9:42 PM, <a href="mailto:vtiger@camden.net">vtiger@camden.net</a><br>
<<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>> wrote: yes the overhead for AMI listen can be issue<br>
<br>
normally dealt with by giving the AMI user Origination and Read Call only<br>
rights, that cuts down on 99% of what you need to parse<br>
<br>
in larger deployments where even the overhead of incoming calls to other<br>
extensions is burdensome, AMI proxy where each user has a proxy user that<br>
only listens to AMI data relevant to there own channel(s)<br>
<br>
<br>
I would think you would only pull SQL data when user in vtiger clicks on<br>
PBXmanager (the user version where they can see the call logs, not the one<br>
for admin to change settings), and display the data rather than pulling it<br>
all the time and creating your own tables, if remote access to SQL is the<br>
concern its easy to write a php XML API, thats how our windows based call<br>
notification works for vtiger so we did not have to open SQL to outside<br>
world, when call comes in we take incomming phone number send it to our API,<br>
the API does all the SQL queries, then returns XML of the results, we did<br>
this with php, all that would be required is for you guys to say hey put<br>
this php file on your asterisk server and modify the database name, user and<br>
secret to match<br>
<br>
<br>
<br>
<br>
<br>
<br>
----------------------------------------<br>
From: "Akshath T.A" <<a href="mailto:akshath.t@vtiger.com">akshath.t@vtiger.com</a>><br>
Sent: Wednesday, August 27, 2014 11:09 AM<br>
To: <a href="mailto:vtiger@camden.net">vtiger@camden.net</a><br>
Cc: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
Subject: Re: [Vtigercrm-developers] Asterisk Good News<br>
<br>
<br>
VtigerAsteriskApp does not modify any configuration of Asterisk directly.<br>
We have recommended changes to be made in Asterisk configuration to get the<br>
AGI request back to the App. Please make sure to track the changes in case<br>
you need to revert back. AGI vs AMI AGI events are listened for incoming<br>
calls as AMI event parsing had to deal with bit-of overhead (as we did in<br>
5.4.0 Asterisk Integration). To origniate outgoing call AMI action is used<br>
(borrowed from our earlier implementation). Working with AGI events is<br>
lot-easier than processing AMI ourselves. The hard-work is taken care by the<br>
asteriskjava library.<br>
<br>
Polling Asterisk DB from CRM server was not a model considered as both the<br>
applications can be setup on different machines. Also php script used for<br>
regular polling in short-intervals (specially during active call handling)<br>
demands server resources and impatcts CRM performance - we had encountered<br>
this in our earlier implementation.<br>
<br>
The approach of implementation we have taken may not be the only way to get<br>
the integration. We are hopeful to see more such coming from community and<br>
take away the learning from the same.<br>
<br>
<br>
regards,<br>
AKshath<br>
<br>
<br>
<br>
<br>
On Wed, Aug 27, 2014 at 7:39 PM, <a href="mailto:vtiger@camden.net">vtiger@camden.net</a><br>
<<a href="mailto:vtiger@camden.net">vtiger@camden.net</a>> wrote: yes I am aware of what it was saying... but<br>
101 was most certainly a valid extension, at the same time this was going on<br>
we could send our own origination command to AMI for 101 to call out and it<br>
worked just fine, that error is not produced by asterisk at all, its not a<br>
valid asterisk error return, you are mis-interrupting some other error and<br>
reporting it back as a asterisk error<br>
<br>
I think it was some error inside your java, at the time this was happening<br>
we only saw data stream on webapp.sh on the click to call attempts, we where<br>
also looking at data streams on your agi.sh saw nothing, the cli with agi<br>
and verbose 10 notifications enabled saw nothing, and we also looking at the<br>
AMI stream, nothing there as well, so we dont even think your connector was<br>
even talking to asterisk at all<br>
<br>
we fixed the issue last night, stopped the webapp.sh and agi.sh files and<br>
prevented them from start @ boot, rebooted, cleared settings in vtiger PBX<br>
manager or rather put in a bunch of junk, saved, rebooted, put settings back<br>
into PBX manager, rebooted then turned the .sh files back on, not sure what<br>
steps fixed but simple stop and start of .sh files and/or system reboots did<br>
not fix<br>
<br>
<br>
we still have issue on on test server where it seems vtiger altered<br>
something in asterisk where all the extensions we had in vtiger no longer<br>
will ring though a call queue, we have no data on the event we where not<br>
actively monitoring data streams, and your asterisk connector has never<br>
written 1 log to its own log directory, everything was working Friday, and<br>
Monday we checked on it again and found that vtiger was stuck in endless<br>
loop of inbound notification and those extensions would no longer sent a sip<br>
invite though call queue, even after they where removed from vtiger and a<br>
reboot, and the asterisk connector was completely shut down, keep in mind<br>
these are test servers dedicated to getting vtiger to work, they are lamp +<br>
asterisk + freepbx + vtiger only we have not moved into phase of testing<br>
with other packages so the problems we are having can only be vtiger, this<br>
is what concerns us about closed source java+agi, beyond we can not see code<br>
to try to help you we now have situation where it seems your connector and<br>
AGI have altered asterisk, we dont know whats it doing.<br>
<br>
the whole reason we advocate for just use the AMI is its simple and works<br>
and your not really doing anything that requires the interactivity that AGI<br>
allows, AMI can be used to originate call as well as be monitored for<br>
inbound, this is how tapi drivers work that plug into on site CRMs like ACT,<br>
SAGE CRM, Lexis Nexus, ect, its also how sugar / sweet crm are handling it<br>
<br>
I think the tiring the call records to data in vtiger is a great idea, but<br>
why are you generating your own CDR log's via AGI, and this is where I think<br>
you guys are hung up on using AGI, but asterisk does have it own MySQL<br>
tables and CDR reccords, why not during the isntall of vtiger ask for the<br>
asterisk database name and credentials and query them for the info, and<br>
vtiger should not be forcing all calls to record, asterisk gives us ways to<br>
record and not record calls, if you want to link to recordings fine but<br>
again you should be looking to see if a call was recorded, beyond a<br>
performance issue and potential duplication of whats already being done in<br>
the Asterisk, this ventures into a legal issue, a lot of places all parties<br>
must be notified and consent to call recording, with vtiger it forces the<br>
recording<br>
<br>
the general rule of thumb here is if you need user input like your making a<br>
IVR and logging what was entered then you need AGI, if your just originating<br>
calls and monitoring for inbound use AMI, in either case SQL should be used<br>
to get call record data<br>
<br>
AGI has it problems that you are unnecessarily dealing with, they are<br>
common for AGI, what if my agi script finishes before the call ends, what if<br>
the call ends before my agi script finishes and a whole host of other<br>
issues that you simply dont need to deal with for what your trying to do<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
----------------------------------------<br>
From: "Akshath T.A" <<a href="mailto:akshath.t@vtiger.com">akshath.t@vtiger.com</a>><br>
Sent: Wednesday, August 27, 2014 3:19 AM<br>
To: <a href="mailto:vtiger@camden.net">vtiger@camden.net</a><br>
Subject: Re: [Vtigercrm-developers] Asterisk Good News<br>
Hi,<br>
<br>
From the logs, it clearly states that the extension - 101 was not found by<br>
your Asterisk server when AMI originate request sent from Vtiger Connector.<br>
<br>
In order to nail down the issue, can we have a online meeting today or<br>
tomorrow so that it would help us know what really is causing the problem.<br>
<br>
<br>
I will be available from 9:00 AM to 8:00 PM IST at my office. Please tell<br>
us your convenient time within this so that I can send you meeting link.<br>
<br>
Thank you.<br>
<br>
<br>
regards,<br>
Akshath<br>
Vtiger<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:<br>
<<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140
828/8dcaf2c1/attachment.html" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140<br>
828/8dcaf2c1/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
vtigercrm-developers mailing list<br>
<a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
<a href="http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers" target="_blank">http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-developers</a><br>
<br>
<br>
End of vtigercrm-developers Digest, Vol 103, Issue 320<br>
******************************************************<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>