Welcome to WebmasterWorld Guest from 54.145.144.101

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Parse Caller ID to MySQL database?

trying to get caller id info into my database

   
6:15 pm on Sep 7, 2007 (gmt 0)

5+ Year Member



The subject says it all...
I'm wondering if anyone can help me with an approach for getting caller id data into a mysql database. I'm thinking if I could somhow convert the CID data to XML I could FTP the XML data to my server on a schedule and run a script on my server to get the XML data into my db. But how can I extract CID data? Does anyone know of any tools..opensource or otherwise?

Thanks.

[edited by: eelixduppy at 9:28 pm (utc) on Sep. 7, 2007]
[edit reason] fixed spelling [/edit]

9:54 pm on Sep 7, 2007 (gmt 0)

5+ Year Member



Okay, I found a free application called PhoneTray Free 1.26 which logs phone calls and creates a CSV file. I am using the MySQL database provided by my web host and so what I would like to do is create a database from the CSV file. Is it possible to import the CVS from a directory and create a table from it using PHP?
1:39 am on Sep 8, 2007 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



definitely, shouldn't be too difficult

you could take a look at this library [webmasterworld.com] thread

Basics of extracting data from CSV files [webmasterworld.com]