Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
2
Hi,
I was hoping someone would help me write a program to interrogate a website and dump the data in a spreadsheet. The website I'm trying to interrogate is
whitepages.com.au - Search for an Australian Business, Government or Person
Which is an online phone directory. Basically I want to create a reverse phone book in excel. Before you get overly concerned with my motives, I can assure you that my intentions are not malicious. I recently sold a car and the new owner hasn't handed in the paperwork and now (6 months later) I'm still getting speeding tickets, etc.
It may seem a little excessive; however I also thought it might be a good way to learn how to ccreate programs that interact with the web (up till now, I've only written simple programs that are standalone and have no interaction with other programs or information outside what's in the code).
Anyway, I'm using a Macbook and so thought Applescript might be a suitable language; however I'm open to suggestions.
Any help, tips or pointers would be greatly appreciated. I've left my question fairly open because I really have no idea where to start.
Regards,
Dorian
2 replies to this topic
Back to top|
|
|
#2
Posted 30 July 2011 - 05:55 PM
Calgon
-
- Members
-
- 56 posts
Learning Programmer
I'm a fan of PHP and as far as I remember, Apache and PHP are natively installed on Mac computers, so it'd presumably be OK to opt for using PHP.
What exact information do you want to pull?
What exact information do you want to pull?
#3
Posted 30 July 2011 - 09:01 PM
Dorian-81
-
- Members
-
- 2 posts
Newbie
Hi Calgon,
It's an online phone directory, so i wanted to (unless there's a simpler method) progressively search for names starting at "A" through to "ZZZZZ" (i.e. A, AA, AB, etc) and extract the results of each into a spreadsheet. Then remove the duplicate results.
Incidentally, I found my paperwork and the details for the person I was trying to find (I only had their phone number and first name) so I don't really need this anymore; however would still like to give it a go, even if it's just getting the results from searches "A" through to "Z".
Also, what's PHP (please excuse my ignorance)? And is there an editor for it pre-installed on MacBooks?
Regards.
Dorian
It's an online phone directory, so i wanted to (unless there's a simpler method) progressively search for names starting at "A" through to "ZZZZZ" (i.e. A, AA, AB, etc) and extract the results of each into a spreadsheet. Then remove the duplicate results.
Incidentally, I found my paperwork and the details for the person I was trying to find (I only had their phone number and first name) so I don't really need this anymore; however would still like to give it a go, even if it's just getting the results from searches "A" through to "Z".
Also, what's PHP (please excuse my ignorance)? And is there an editor for it pre-installed on MacBooks?
Regards.
Dorian
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
