<div dir="ltr">Mel,<div><br></div><div>Thank you for letting me know that you go it working - copying direct message for reference on this thread:</div><div><br></div><div><p class="MsoNormal" style="font-family:arial,sans-serif;font-size:13px">
<span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><i>just to let you know I did a fresh download and the charts works fine in that, so the issue was in me carrying out the updates.<u></u><u></u></i></span></p>
</div><div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><br></span></div>Regards,<br>Prasad<div><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><br></span></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 Fri, Aug 29, 2014 at 5:47 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 Prasad,<br>
<br>
What are the login details for the demo?<br>
<div class=""><br>
Mel<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>
</div><div class="">Sent: 28 August 2014 18:28<br>
To: <a href="mailto:vtigercrm-developers@lists.vtigercrm.com">vtigercrm-developers@lists.vtigercrm.com</a><br>
</div><div class="">Subject: vtigercrm-developers Digest, Vol 103, Issue 323<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>
</div> 1. Re: highcharts - commercial license (Prasad)<br>
2. Number Of Currency Decimals - in vtiger - to be set 0 as well<br>
(Holbok Istv?n)<br>
3. Note: Festival time here - Bear with our delayed responses.<br>
(Prasad)<br>
4. Re: Reports-Charts (Prasad)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Thu, 28 Aug 2014 22:29:07 +0530<br>
From: Prasad <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>><br>
To: "<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] highcharts - commercial license<br>
Message-ID:<br>
<CAMeS7pkpJ+FcnOs0ABmuRpa==KPiZi1kiFa943yyrq5=<a href="mailto:ywF6VA@mail.gmail.com">ywF6VA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
We have purchased the license for highcharts for Ondemand service. It cannot<br>
be bundled with open-source.<br>
<br>
Chart rendering is modelled to work with highcharts if available else<br>
fallback on the default library. (this capability will be integrated post<br>
6.1.0).<br>
<br>
Regards,<br>
Prasad<br>
<br>
*Connect with us on: *Twitter <<a href="http://twitter.com/vtigercrm" target="_blank">http://twitter.com/vtigercrm</a>> *I* Facebook<br>
<<a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" target="_blank">http://www.facebook.com/pages/vtiger/226866697333578?sk=wall</a>> *I* Blog<br>
<<a href="https://blogs.vtiger.com/" target="_blank">https://blogs.vtiger.com/</a>>* I* Wiki<br>
<<a href="http://wiki.vtiger.com/index.php/Main_Page" target="_blank">http://wiki.vtiger.com/index.php/Main_Page</a>> *I *Forums<br>
<<a href="https://discussions.vtiger.com" target="_blank">https://discussions.vtiger.com</a>>*I* Website <<a href="https://www.vtiger.com/" target="_blank">https://www.vtiger.com/</a>><br>
<br>
<br>
On Thu, Aug 28, 2014 at 1:25 PM, Pabiszczak, B?a?ej <<br>
<a href="mailto:b.pabiszczak@opensaas.pl">b.pabiszczak@opensaas.pl</a>> wrote:<br>
<br>
> Why do you use a commercial library in your "on demand" version?<br>
><br>
><br>
> -<br>
><br>
<a href="https://xxxxxxx3.od1.vtiger.com/_resources6.14.16_/layouts/vlayout/modules/O
ndemand/libraries/hightcharts/js/highcharts.js" target="_blank">https://xxxxxxx3.od1.vtiger.com/_resources6.14.16_/layouts/vlayout/modules/O<br>
ndemand/libraries/hightcharts/js/highcharts.js</a><br>
> - <a href="https://shop.highsoft.com/highcharts.html" target="_blank">https://shop.highsoft.com/highcharts.html</a><br>
><br>
> Shall I understand it that you will never introduce these things that<br>
> are in "on demand" into open source version? In the "on demand"<br>
> version you replaced everything with this library.<br>
><br>
> Z powa?aniem / Regards<br>
> B?a?ej Pabiszczak<br>
> M: +48.884999123<br>
> E: <a href="mailto:b.pabiszczak@opensaas.pl">b.pabiszczak@opensaas.pl</a><br>
<div class="">><br>
> _______________________________________________<br>
> <a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:<br>
<<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140</a><br>
</div>828/d838c16b/attachment-0001.html><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Thu, 28 Aug 2014 19:13:11 +0200<br>
From: Holbok Istv?n <<a href="mailto:holbok@gmail.com">holbok@gmail.com</a>><br>
To: "<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: [Vtigercrm-developers] Number Of Currency Decimals - in<br>
vtiger - to be set 0 as well<br>
Message-ID: <<a href="mailto:53FF6327.4010607@gmail.com">53FF6327.4010607@gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
Dear vtiger Team,<br>
<br>
This thread is tracked as enhancement with ID #8198<br>
<<a href="http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8198" target="_blank">http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/8198</a>><br>
<br>
There is an important settings of Number Of Currency Decimals. In this<br>
moment (vtiger 6.1.0 EA) this settings should be 2,3,4 or 5.<br>
<br>
Unfortunately there are some country, for example Hungary, where currency<br>
decimals are not used. In this moment the smallest amount of currency that<br>
we can use: 5 HUF. The 0,10 0,20 and 0,50 HUF have been deprecated since<br>
more then 10 years, and in the last years the 1 HUF and the 2 HUF were also<br>
removed.<br>
<br>
So, it would be very useful if the Number Of Currency Decimals can be 0<br>
also.<br>
<br>
In other case I should do some core hack for the Hungarian users.<br>
<br>
Kindest regards:<br>
Istv?n<br>
<br>
--<br>
?dv?zlettel:<br>
<br>
*Holbok Istv?n*<br>
<br>
+3670-342-0900<br>
*e-mail:* <a href="mailto:holbok@gmail.com">holbok@gmail.com</a><br>
*SkyPe:* holboki<br>
<div class=""><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:<br>
<<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140</a><br>
</div>828/2c963b3d/attachment-0001.html><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Thu, 28 Aug 2014 22:55:30 +0530<br>
From: Prasad <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>><br>
To: "<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: [Vtigercrm-developers] Note: Festival time here - Bear with<br>
our delayed responses.<br>
Message-ID:<br>
<<a href="mailto:CAMeS7pk3aPQoUYpxJXnNsO2XT1QZE6j0HDE837wE6-z9u6r1oA@mail.gmail.com">CAMeS7pk3aPQoUYpxJXnNsO2XT1QZE6j0HDE837wE6-z9u6r1oA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Its festival time that makes long weekend for us here.<br>
<br>
Please bear with our delayed responses or review on 6.1.0 EA<br>
<br>
*Connect with us on: *Twitter <<a href="http://twitter.com/vtigercrm" target="_blank">http://twitter.com/vtigercrm</a>> *I* Facebook<br>
<<a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" target="_blank">http://www.facebook.com/pages/vtiger/226866697333578?sk=wall</a>> *I* Blog<br>
<<a href="https://blogs.vtiger.com/" target="_blank">https://blogs.vtiger.com/</a>>* I* Wiki<br>
<<a href="http://wiki.vtiger.com/index.php/Main_Page" target="_blank">http://wiki.vtiger.com/index.php/Main_Page</a>> *I *Forums<br>
<<a href="https://discussions.vtiger.com" target="_blank">https://discussions.vtiger.com</a>>*I* Website <<a href="https://www.vtiger.com/" target="_blank">https://www.vtiger.com/</a>><br>
<div class="">-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:<br>
<<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140</a><br>
</div>828/72bfd05e/attachment-0001.html><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Thu, 28 Aug 2014 22:57:43 +0530<br>
From: Prasad <<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>><br>
To: "<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] Reports-Charts<br>
Message-ID:<br>
<<a href="mailto:CAMeS7pmVT_J9mO1TOHtHPDs8gSifP6PX_cUgshNVjO-R-mz8Tg@mail.gmail.com">CAMeS7pmVT_J9mO1TOHtHPDs8gSifP6PX_cUgshNVjO-R-mz8Tg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<div class=""><br>
Mel,<br>
<br>
Can you repeat the steps on <a href="http://demo.vtiger.com" target="_blank">demo.vtiger.com</a> and report the same?<br>
<br>
</div>*Connect with us on: *Twitter <<a href="http://twitter.com/vtigercrm" target="_blank">http://twitter.com/vtigercrm</a>> *I* Facebook<br>
<<a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" target="_blank">http://www.facebook.com/pages/vtiger/226866697333578?sk=wall</a>> *I* Blog<br>
<<a href="https://blogs.vtiger.com/" target="_blank">https://blogs.vtiger.com/</a>>* I* Wiki<br>
<<a href="http://wiki.vtiger.com/index.php/Main_Page" target="_blank">http://wiki.vtiger.com/index.php/Main_Page</a>> *I *Forums<br>
<<a href="https://discussions.vtiger.com" target="_blank">https://discussions.vtiger.com</a>>*I* Website <<a href="https://www.vtiger.com/" target="_blank">https://www.vtiger.com/</a>><br>
<div><div class="h5"><br>
<br>
On Thu, Aug 28, 2014 at 7:45 PM, Mel <<a href="mailto:m.brummell@btinternet.com">m.brummell@btinternet.com</a>> wrote:<br>
<br>
> 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<br>
> did each change manually from svn changeset 14222) or whether its just<br>
> work in progress. When I go to Reports - Add Report - Charts I am<br>
> presented with Report Details arrow, Filters and Select Chart but<br>
> clicking on these does 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-develope" target="_blank">http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-develope</a><br>
> rs<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<br>
> 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<br>
> think is issue is this AGI-AMI hybrid thing you have going on, AGI is<br>
> notoriously more difficult to program in to begin with, you literally<br>
> have to write a proper handler for every event that might occur, plus<br>
> AGI and AMI are not inherently meant to work together<br>
><br>
> this is pretty easy with IVRs, we know we are sending caller there,<br>
> and we can except a few limited outcomes, plus you have to use AGI to<br>
> capture input, but with just a regular phone call there are to many<br>
> things that can 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<br>
> means no inbound notification and no logging and voice recording of<br>
> calls of those calls, we are going to test if this thing stays stable<br>
> for just click to call in light of that you also found issue where<br>
> inbound can be sent to endless loop<br>
><br>
> in our limited testing (just one night) we noticed AMI streaming data<br>
> in your webapp.sh on a inbound call without the agi fire, with some<br>
> error messages we think are related to it was expecting the AGI to<br>
> fire, it did not seem to effect anything and so far has not locked up<br>
> and continues to work<br>
><br>
> we know your using the AMI to originate outbound, and it seems your<br>
> using AMI for at least part of the inbound, so the question remains<br>
> why AGI at all, you guys say its to limited overhead and cut down on<br>
> data you need to phrase, yet your phrasing it anyway?? if you want to<br>
> cut down the data you get from the AMI stream, have the AMI user have<br>
> originate and read call only rights, you will only get data the<br>
> pertains to actual phone calls and cut out 95% of the data AMI would<br>
> normally stream that you dont care about 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<br>
> calls to be recorded (a function we dont think you should be doing<br>
> anyway) however the CDR in vtiger is a good idea but there is better<br>
> option<br>
><br>
> use the existing SQL CDR data Asterisk will provide, you say you want<br>
> to use a API, so write one, we think that is better idea that opening<br>
> SQL to 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<br>
> server where Apache can serve up, in that php file, you need to pass<br>
> it the extension and phone number(s) you are going to pull data for,<br>
> have the php run the sql statements and return the data you want<br>
> (date, time, callerID, source, destination, duration), we would use<br>
> XML put there are lots of 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<br>
> extension and phone numbers for that instance, you may want to drop<br>
> the extension search part so if I click on a contact then go to PBX<br>
> manger I see all calls to and from that contact and which colleges of<br>
> mine took or placed those calls<br>
><br>
> also if asterisk was told to record a call you will notice in the<br>
> user panel under call monitor there is a column "monitor" if there is<br>
> a recording there be 2 icons, one to download the sound file and one<br>
> to listen to it, you could do the same, however I would advise to have<br>
> access to recording off by default with the option for the vtiger<br>
> admin to allow access on a per 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<br>
> uses to click to call out of vtiger, If I know a phone number, Im not<br>
> going to go searching for it to click on it, as result the call will<br>
> not show in vtiger, will vtiger log call on inbound if user was not<br>
> logged into vtiger?<br>
> we have not tested, but if the vtiger PBX CDR records are incomplete<br>
> they 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<br>
> Asterisk and provide neutral interface to Vtiger. This benefit may not<br>
> be obvious and sound like a overhead but give it a thought.<br>
><br>
> We generally lean towards working with APIs than DB with other<br>
> application<br>
> - yes there would be performance benefits but would it comes against<br>
> the cost of maintenance and configurations. It would be the choice to<br>
> consider 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<br>
> 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<br>
> evolve 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<br>
> intervals at all, you pull only when data is needed, the fetch cdr by<br>
> clicking on pbx manger was example of needed the data that would cause<br>
> a pull,<br>
><br>
> if you did that it would be not be needed for vtiger to maintain its<br>
> own call logging and CDR functions, it would also give bonus that<br>
> calls make outside of scope of vtiger would show in PBX Manager in<br>
> vtiger<br>
><br>
> also pulling from asterisk vtiger would not need to force call<br>
> recording on every call, which is a waste of system resources,<br>
> especially if asterisk is already recording calls, not just a waste of<br>
> HD space but call recording uses CPU always introduces latency into a<br>
> call so you dont want both can have negative impacts on call quality<br>
><br>
> by taking call recording out of vtiger you also put the decision to<br>
> call record or not back in hands of asterisk admins and end users that<br>
> want or dont want call recording, call centers are the only business<br>
> In my experience that want every call recorded no matter what, they<br>
> typically do it out of a call queue and have an announcement to<br>
> satisfy legalities "your call may be recorded for quality and<br>
> training" most everyone else typically just wants the feature code to<br>
> 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<br>
> send the CDR event and vtiger would store these information in<br>
> "vtiger_pbxmanager" table. So whenever PBXManager is opened Vtiger<br>
> fetches 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<br>
> only 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<br>
> other extensions is burdensome, AMI proxy where each user has a proxy<br>
> user that 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<br>
> on PBXmanager (the user version where they can see the call logs, not<br>
> the one for admin to change settings), and display the data rather<br>
> than pulling it all the time and creating your own tables, if remote<br>
> access to SQL is the concern its easy to write a php XML API, thats<br>
> how our windows based call notification works for vtiger so we did not<br>
> have to open SQL to outside world, when call comes in we take<br>
> incomming phone number send it to our API, the API does all the SQL<br>
> queries, then returns XML of the results, we did this with php, all<br>
> that would be required is for you guys to say hey put this php file on<br>
> your asterisk server and modify the database name, user and secret to<br>
> 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<br>
directly.<br>
> We have recommended changes to be made in Asterisk configuration to<br>
> get the AGI request back to the App. Please make sure to track the<br>
> changes in case you need to revert back. AGI vs AMI AGI events are<br>
> listened for incoming calls as AMI event parsing had to deal with<br>
> bit-of overhead (as we did in<br>
> 5.4.0 Asterisk Integration). To origniate outgoing call AMI action is<br>
> used (borrowed from our earlier implementation). Working with AGI<br>
> events is lot-easier than processing AMI ourselves. The hard-work is<br>
> taken care by the asteriskjava library.<br>
><br>
> Polling Asterisk DB from CRM server was not a model considered as<br>
> both the applications can be setup on different machines. Also php<br>
> script used for regular polling in short-intervals (specially during<br>
> active call handling) demands server resources and impatcts CRM<br>
> performance - we had encountered this in our earlier implementation.<br>
><br>
> The approach of implementation we have taken may not be the only way<br>
> to get the integration. We are hopeful to see more such coming from<br>
> community and 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<br>
> going on we could send our own origination command to AMI for 101 to<br>
> call out and it worked just fine, that error is not produced by<br>
> asterisk at all, its not a valid asterisk error return, you are<br>
> mis-interrupting some other error and reporting it back as a asterisk<br>
> error<br>
><br>
> I think it was some error inside your java, at the time this was<br>
> happening we only saw data stream on webapp.sh on the click to call<br>
> attempts, we where also looking at data streams on your agi.sh saw<br>
> nothing, the cli with agi and verbose 10 notifications enabled saw<br>
> nothing, and we also looking at the AMI stream, nothing there as well,<br>
> so we dont even think your connector was even talking to asterisk at<br>
> all<br>
><br>
> we fixed the issue last night, stopped the webapp.sh and agi.sh files<br>
> and prevented them from start @ boot, rebooted, cleared settings in<br>
> vtiger PBX manager or rather put in a bunch of junk, saved, rebooted,<br>
> put settings back into PBX manager, rebooted then turned the .sh files<br>
> back on, not sure what steps fixed but simple stop and start of .sh<br>
> files and/or system reboots did 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<br>
> longer will ring though a call queue, we have no data on the event we<br>
> where not actively monitoring data streams, and your asterisk<br>
> connector has never written 1 log to its own log directory, everything<br>
> was working Friday, and Monday we checked on it again and found that<br>
> vtiger was stuck in endless loop of inbound notification and those<br>
> extensions would no longer sent a sip invite though call queue, even<br>
> after they where removed from vtiger and a reboot, and the asterisk<br>
> connector was completely shut down, keep in mind these are test<br>
> servers dedicated to getting vtiger to work, they are lamp + asterisk<br>
> + freepbx + vtiger only we have not moved into phase of testing with<br>
> 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<br>
> see code to try to help you we now have situation where it seems your<br>
> connector and 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<br>
> works and your not really doing anything that requires the<br>
> interactivity that AGI allows, AMI can be used to originate call as<br>
> well as be monitored for inbound, this is how tapi drivers work that<br>
> plug into on site CRMs like ACT, SAGE CRM, Lexis Nexus, ect, its also<br>
> how sugar / sweet crm are handling it<br>
><br>
> I think the tiring the call records to data in vtiger is a great<br>
> idea, but why are you generating your own CDR log's via AGI, and this<br>
> is where I think you guys are hung up on using AGI, but asterisk does<br>
> have it own MySQL tables and CDR reccords, why not during the isntall<br>
> of vtiger ask for the asterisk database name and credentials and query<br>
> them for the info, and vtiger should not be forcing all calls to<br>
> record, asterisk gives us ways to record and not record calls, if you<br>
> want to link to recordings fine but again you should be looking to see<br>
> if a call was recorded, beyond a performance issue and potential<br>
> duplication of whats already being done in the Asterisk, this ventures<br>
> into a legal issue, a lot of places all parties must be notified and<br>
> consent to call recording, with vtiger it forces the recording<br>
><br>
> the general rule of thumb here is if you need user input like your<br>
> making a IVR and logging what was entered then you need AGI, if your<br>
> just originating calls and monitoring for inbound use AMI, in either<br>
> case SQL should be used 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,<br>
> what if the call ends before my agi script finishes and a whole host<br>
> of other issues that you simply dont need to deal with for what your<br>
> 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<br>
> found by your Asterisk server when AMI originate request sent from Vtiger<br>
Connector.<br>
><br>
> In order to nail down the issue, can we have a online meeting today<br>
> or tomorrow so that it would help us know what really is causing the<br>
problem.<br>
><br>
><br>
> I will be available from 9:00 AM to 8:00 PM IST at my office. Please<br>
> tell us your convenient time within this so that I can send you meeting<br>
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 -------------- An HTML attachment was<br>
> scrubbed...<br>
> URL:<br>
> <<br>
> <a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/</a><br>
> 20140<br>
> 828/8dcaf2c1/attachment.html><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-develope" target="_blank">http://lists.vtigercrm.com/cgi-bin/mailman/listinfo/vtigercrm-develope</a><br>
> rs<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>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL:<br>
<<a href="http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140" target="_blank">http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140</a><br>
</div></div>828/b93989b8/attachment.html><br>
<div class=""><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>
</div>End of vtigercrm-developers Digest, Vol 103, Issue 323<br>
******************************************************<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>