similar to: queue log in mysql

hi i am integrating asterisk whit an open source CRM or maybe i am integrating an open source crm whit asterisk any way the CRM is vtiger, (www.vtiger.com) i need an opensource queue log parser to put inside the crm agent statics. i need any parser i can port it to php or to java if you don't know any parser maybe you can send me a link or a pdf whit info on how to parse the log. Thanks David

Hello; I need two scenarios: 1) If someone sent SMS message, then we need to query information from the database based on information sent by the SMS (like the name or the mobile number), after querying from the database, we need to reply by the SMS. Can asterisk do this? To which level? 2) I have vtiger CRM, and it is possible to send SMS (there is a button: send SMS), the question is: what is

Hi, How hard is it to integrate asterisk with Microsoft CRM? Thanks for any suggestions, pointers, etc.

Sorry to post a C compile error on this mailing list but this is Asterisk related. Basically, I was following http://www.plack.net/index.php/2007/01/07/asterisk_modification_for_queu e_logging to patch logger.c and Makefile in Asterisk 1.4.* in order to write queue_log to mySQL database. When I ran make, it complained: In function `write_mysql_logger': [...]

Hi All, I've just upgraded our CRM and it has an Asterisk Integration Module that I would like to test out. The CRM is running on one of our hosted servers in the cloud. The Asterisk server is running in my office. I am running Asterisk 1.4.21.2~dfsg-1ubuntu3. Reading the page http://www.voip-info.org/tiki-index.php?page=Asterisk%20config%20manager.conf got me a little concerned

Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000

hi, is it possible log cel/queue_log to sqlite? via odbc? any experience? marek

On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com> wrote: > i tested this > > # cat /etc/asterisk/extconfig.conf > [settings] > queue_log => sqlite3,cdrDb > > # cat /etc/asterisk/res_config_sqlite3.conf > [cdrDb] > dbfile = /var/lib/asterisk/realtime.sqlite3 > > sqlite3 /var/lib/asterisk/realtime.sqlite3 > > CREATE TABLE

Hello List, Question: Has anyone been able to create multiple queue_log files in /var/log/asterisk for multiple queues? We are designing a multi-tenant system and separating the log files would be useful, instead of dropping all queue actions into one file. Is it possible this is a user configurable option I am missing? Cheers, -- ------ Christopher T Aloi ------

Does anyone know of a Rails based Price Quote system? Something where a company could keep track of price quotes they''ve sent out to potential customers? -- Posted via http://www.ruby-forum.com/.

Hello, Iam using queues and agents, thats OK. I have interesting information form Asterisk in txt file format var/log/asterisk/queue_log Today Iam reading these txt files and wrote them in an mySQL databases. I would need this information more realtime. Some information I do writing in the dialplan direct in an mySQL database. Is there any way that Asterisk write this information direct in

I am searching for a crm solution for small business and private use. Can't find anything within the CentOS 4.2. Most important for me are: address book, comments and document organization. Any comments or recommendations appreciated. kai

Hi We're using 1.8.23.1 on CentOS 5 and are trying to get accurate stats for queues. For a particular customer, when I run queue show <queue_name> I get the following numbers: <queue_name> has 0 calls (max unlimited) in 'ringall' strategy (17s holdtime, 94s talktime), W:0, C:175, A:44, SL:48.6% within 45s So from that data we look at 17s holdtime And assume that is the

Hello, Is there a way to either store login/logout agent information in a database or at least send an email when an agent logs in or out of a queue? Thanks, Michael -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110812/84130e1a/attachment.htm>

hi wich soft phone do you recomend but i need this feature it must ask for user name and password when it start. i know xline and zoipper but they dont have that i can acomplish this whit twinkle but i need it for Windows :-( any ideas? thanks -- (\__/) (='.'=)This is Bunny. Copy and paste bunny into your (")_(")signature to help him gain world domination. -------------- next

hi i am using asterisk 1.4.22 ubuntu 8.4 i have two Ethernet one for ssh and other one only for voip calls when i start a call using originate in the manager or the cli in the voip Ethernet i get something like 4Mbits/sec of traffic only 1 G711 call. if i start the call using a soft phone everything is normal. any idea? thanks -- (\__/) (='.'=)This is Bunny. Copy and paste bunny

hi i need a link or something about asterisk load balancing i cant find any, i only found a paragraf in an email anything wiil be wolcome thanks! David -- (\__/) (='.'=)This is Bunny. Copy and paste bunny into your (")_(")signature to help him gain world domination. -------------- next part -------------- An HTML attachment was scrubbed... URL:

hi wich predicitive dialer are you using and wich one do you recomend? a link to the project/product and a link to a how to will be VERY apreciated. Thanks David -- (\__/) (='.'=)This is Bunny. Copy and paste bunny into your (")_(")signature to help him gain world domination. -------------- next part -------------- An HTML attachment was scrubbed... URL:

hi this is mi first email and just for say hello. David -- (\__/) (='.'=)This is Bunny. Copy and paste bunny into your (")_(")signature to help him gain world domination. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20081202/375a91e5/attachment.htm

hi i am reading about new codecs and new stuff to be added to asterisk. (and i say thanks to all the guys who are working to add all the new features). will be R2 added to the main core of asterisk like ISDN? Thanks David -- (\__/) (='.'=)This is Bunny. Copy and paste bunny into your (")_(")signature to help him gain world domination. -------------- next part --------------