jj20051 Posted January 25, 2009 Share Posted January 25, 2009 I have an API full of phone calls made to my 1-800 number last year. What I would like to do is strip off all of the calls that: were duplicates, were calls made by one of my 3 phones to test, lasted less than 15 seconds or calls made out side 1 of 4 area codes. I realize no one person has the awnswer to all of this. So I would love some pointers and advice. ( If you want to write something to help me, that would be awsome! ) The API URL: http://www.tollfreeforwarding.com/api/?u=schuldr&p=kingdom&format=html&rangeStart=20080101&rangeEnd=20081231&timezone=-6 Quote Link to comment Share on other sites More sharing options...
Prismatic Posted January 25, 2009 Share Posted January 25, 2009 Can you list out the column names so we know what we're looking at? Quote Link to comment Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 ID,Number Dialed,Calling From,Forwarded To,Start Call,End Call,Duration,Code Quote Link to comment Share on other sites More sharing options...
redarrow Posted January 25, 2009 Share Posted January 25, 2009 no print the core database so we no what there for or tell us give a database example... Quote Link to comment Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 Two Words: I'm lost! Quote Link to comment Share on other sites More sharing options...
redarrow Posted January 25, 2009 Share Posted January 25, 2009 example like this mate <<<<< means database format example. ID <<<<<< Number <<<<<<< Dialed <<<<<<< Calling From <<<<<< Forwarded To <<<<< Start Call <<<<< End Call <<<<< Duration <<<<< Code <<<<< Quote Link to comment Share on other sites More sharing options...
rubing Posted January 25, 2009 Share Posted January 25, 2009 If you want me to write it, you should post this in the freelance section and let me know how much moola you will pay me. Now if you want help writing it we will give that to you free. Why don't you just ask us how to do a single thing? or try doing something yourself and tell us how it failed. Quote Link to comment Share on other sites More sharing options...
trq Posted January 25, 2009 Share Posted January 25, 2009 example like this mate <<<<< means database format example. ID <<<<<< Number <<<<<<< Dialed <<<<<<< Calling From <<<<<< Forwarded To <<<<< Start Call <<<<< End Call <<<<< Duration <<<<< Code <<<<< There is no database involved redarror. Read the post. Personally I wouldn't use php for this. Sounds more like a job for bash, grep and awk. I can point you to a few awk tutorials but other than that, I don't have much. Quote Link to comment Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 That's not exactly what I wanted to hear. I thought almost anything is possible with php Quote Link to comment Share on other sites More sharing options...
corbin Posted January 25, 2009 Share Posted January 25, 2009 Just because something is possible one way does not mean that said way is the best way ;p. Anyway, don't take this the wrong way, but uhh... do you know any PHP at all? This isn't very hard unless there's something I'm missing. Do you have a specific question, or do you not know where to start? Quote Link to comment Share on other sites More sharing options...
jj20051 Posted January 25, 2009 Author Share Posted January 25, 2009 I don't know where to start is the main problem. If i could get the data to seperate into "virtual tables" I would be fine from there. Even a script to convert it from the api into a database would make my life easier by 5x Quote Link to comment Share on other sites More sharing options...
corbin Posted January 25, 2009 Share Posted January 25, 2009 http://php.net/explode would be the first step of separating the data. Quote Link to comment Share on other sites More sharing options...
trq Posted January 25, 2009 Share Posted January 25, 2009 That's not exactly what I wanted to hear. I thought almost anything is possible with php I didn't say it wasn't possible with php. Its just IMO there are better tools for this job. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.