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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>: > 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 _______________________________________________ --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