similar to: How to write data to astdb?

Hi All, I'm looking for a way to filter the AstDB cidname family to show only those entries with a specified area code in the Asterisk CLI. If this were a SQL database it would be something like: SELECT number, name FROM cidname WHERE number LIKE '1234%' I've tried "database show cidname 1234*" and substituted "%", "$", "-" for the wildcard

Hi All, I need to use partial matches on the CIDNAME family I have stored in AstDB. For example, an organisation might have several numbers with the same area code and the same first few digits: 1234 567890 1234 567889 1234 567824 ... I'd like to store these (e.g.) as CIDNAME/12345678* (where "*" is a wildcard) so that I can retrieve the organisation name from

Hello, In case there are other users of the AsteriskWin32 port... I haven't really used the AGI feature of Asterisk to run an application from extensions.conf. *Win32 supports Perl, which I don't know. Apparently, it's also possible to write AGI applications as EXE's (there's a eagi-test.exe file installed by default). => When a call comes in, I'd like an AGI

Hello When using LookupCIDName, Asterisk 1.4 says that it's deprecated, and we should use "${DB(cidname/${CALLERID(num)})}" instead, but I don't know how to use it: ;DEPRECATED exten => s,1,LookupCIDName ;ERROR exten => s,1,${DB(cidname/${CALLERID(num)})} I guess I should use this as a parameter to a function, but which one? Thank you.

Admittedly this is probably pretty stupid of me, but there are just some things I can't understand by reading documentation. Any suggestions or recommendations about how to handle my problem are greatly appreciated. I'm trying to achieve the same functionality as my Nortel PBX, without rewriting much 'C' code. In my dialplan I'd like to compare two variables as a means of

Hi all, I tried to set the calleridname of an incoming call to get different incoming labels displayed for different incoming numbers. This does work for hidden number-calls so I can set the displayed CIDName on my cisco7960 from "CID withheld" to "abc CID withheld" If the incoming CID isn't hidden it works to use SetCallerID but not to change only the CIDName with

Hi Most of our customers have generic names like "Hospital", so I need to rewrite their caller ID name by looking up the number in a database on the Asterisk server, and rewriting the name such as "Reading Hospital" so that we know who's calling. Any idea if this can be done with Asterisk, and how to do it? Thank you.

I am using Sipura 841 phones and Asterisk CVS-v1-0-06/14/05. Whenever a call comes in with blank CIDName or CIDNum the phone reports the respective variable as "asterisk". I can manually set the variables to whatever I want: CIDName (alpha-numeric) & CIDNum (Numeric). But if I try to make them blank, or null, or maybe throw some alpha characters into CIDNum, they get reported

Hello, Sometimes, when a call comes in from the PSTN through our VoIP gateway, the information that is sent to our web page that logs calls includes the original CID name instead of the one that is we expect to be rewritten on the fly using Asterisk's LookupCIDName: ================= ;extensions.conf [internal] exten => group,1,LookupCIDName exten =>

hi. currently i am running the phonebook in astdb with *database put cidname 0123456789 "name_surname"* and i retrive it with *exten =>9876543210,1,Set(CALLERID(name)=${DB(cidname/${CALLERID(num)})})* Now, my system has mysql and i got all my contacts in there in a database is called *asterisk *and a table called *addressbook**. *password of the mysql is *whateverpasswd* how do i

Hi List I've a CID lookup hooked onto an inbound route (i m using trixbox) ...it runs well but it returns the value as "CIDNAME<CIDNUMBER>" ... if i just want to display the CIDNAME [leaving the quotes and <CIDNUMBER>] .. how can i do it ? do i have to edit some macro in extensions.conf ? rgds Sriram -------------- next part -------------- An HTML attachment was

I'm having a problem with the callerID that the polycom IP600 phones are displaying. I would like to modify the CIDName and leave CIDNumber as exactly what the phone call came in as(provided they aren't hiding callerID). Most of the calls will be going to the queue, but a few will go directly to the SIP phones. I've done a various combinations of using SetCallerID(),

Hi, I am setting up a hylafax server. From what I've read so far, hylafax supports CID numbers and names but currently does not support DID. I assume I can do something like this... [40faxDIDs] exten => _87[5-8]X,1,SetVar(CALLERIDNAME=${EXTEN}) exten => _87[5-8]X,2,Dial(Zap/g${hylafaxMODEMGROUP}) ...and use the CIDName variable in hylafax to route the faxes to the appropriate

I am trying to use the simple CID name management script on the wiki. http://www.voip-info.org/wiki-Asterisk+tips+managing+CID+names I can not see what is wrong. The values never get entered in the database. Here are the files: I have asterisk running as the user asterisk also. ---cid-store.php---- <HTML> <HEAD> <TITLE>Storing Asterisk CID data</TITLE> </HEAD>

Hello When a call comes in, I'd like to fork a Python script that broadcasts a message so that users see the CID name + number pop up on their computer screen, and simultaneously ring their phones. The following script doesn't work as planned: It waits until the script ends before moving on to the next step, which is Dial(): =========== exten =>

Ok, I've been trying to figure out why my A@H won't answer the lines when I can call out and the panel shows the call coming in - well something bizarre has happened. I set up inbound routing to ring my extension if a call comes in - and my extension rings but when I pick it up I get a dial tone. The whole time after I answer I hear the phone I originated the call on just ring and ring

Is there a protocol I'm supposed to use here? It seems that people are asking 100 questions a day and SOMEONE is helping them, and I've posted this three times and not even an "I Don't Know". My third repost: Ok, I've been trying to figure out why my A@H won't answer the lines when I can call out and the panel shows the call coming in - well something bizarre has

Hello everybody. Is there a way how to setup asterisk to notify caller's phone? Example: I have some numbers and names in asterisk database ( cidname, cidnum), and I want to display the name of person on my phone ( which has no addressbook, but can display chars ) which I am calling to be sure that I have dialed the right number. Thank you for any answer. Andrej

I am trying to get data out of a database to my rhtml file. The files look like this: Model ------- mystuff.rb class Mystuff < ActiveRecord::Base set_table_name "mytable" set_primary_key "id" end Controllers -------------- mystuff_controller.rb require ''Mystuff'' class MystuffController < ApplicationController def read @me =

On my linux workstation I have a nice, very little project in a directory called "mystuff" I installed "mystuff" into site-library with R CMD build, R CMD check and R CMD install. This was all with the file mystuff.tar.gz. Now I want to install "mystuff" on my windows workstation. Can I use the same file mystuff.tar.gz. Do I need to do something different with R