At 13:13 21/01/2008 -0600, Darrick Hartman (lists) wrote:
>This is not an Astlinux specific case.  It's how mini_httpd works.

Fine with me. I'll add this to my tutorial on AstLinux.

>I would be interested in seeing how you're using sqlite to store call data.

For a couple of reasons:
1. Since we sell softwares for a niche market, pretty much all our 
customers are listed in the phonebook with a generic name, eg. "Garage"... 
which isn't very helpful as far as CID is concerned. Thankfully, Asterisk 
(apparently, no other PBX software can do this) is able to rewrite the CID 
name on the fly before resuming the script when a call comes in.

So what I do, is check if the call has a CID number -> if not, prompt for a 
number -> look up the number in the database -> if available, fetch the 
customer's name, or rewrite the CID name as "Not found in DB" -> ring the 
phones -> if no one answers, let callers record a message, and hang up -> 
move the WAV file into the www's data directory -> send an e-mail to the 
support team telling me who called, and a link to the www's list of calls 
so they can just click on the file to listen to it -> save the call into a 
table -> have poor man's CRM read this to keep track of calls (who called, 
for what, who handled the call, etc.)

So... Asterisk's key/value BerkeleyDB just doesn't cut it. Hence my quest 
for a Linux/FreeBSD distribution that supports Asterisk + PHP + SQLite, and 
ideally, can run off a CF card because there's no room for a 3.5" HD.


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Astlinux-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/astlinux-users

Donations to support AstLinux are graciously accepted via PayPal to [EMAIL 
PROTECTED]

Reply via email to