[Asterisk-Users] CallerID

[Colin Anderson]

I do the same as well. From my SQL server, I have my Asterisk box query my
customer and B2B contacts using ODBCSock and compose them as as CSV on the
Asterisk box; a script then parses the CSV and DBPut's them into Asterisk
itself. The nice thing about it is you can modify the CallerID with rich
data, for example, when a customer calls, I prepend the customer ID number
for our CRM into the CallerID so the staff member can type in the customer
ID in to the CRM before they pick up. 

I have an .awk that parses the CSV and DBPut's it into Asterisk, if you are
interested email me offlist. 

-----Original Message-----
From: Alejandro Vargas [mailto:alejandro.anv at gmail.com]
Sent: Friday, April 07, 2006 2:07 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] CallerID


2006/4/7, Miles Scruggs <asterisk at garnetweb.com>:
> Could you give me an example code of how this would work, and how to
> setup the database, I'm pretty new and while what you have written makes
> sense, and sounds like a good plan I'm not sure I can implement it.

I'm using my own agi-bin for "patching" callerid and adding the name
if the number is found in a table (a csv that is mantained with a
spreadsheet), it adds the name taken from this table. Then you can see
the name in the display of the phones.

--
Alejandro Vargas
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --

Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users