Connecting Tech Pros Worldwide Help | Site Map

Extracting names and phone numbers from web links

tharden3's Avatar
Site Addict
 
Join Date: Jul 2008
Location: Ocala, FL (United States)
Posts: 817
#1: Jul 9 '08
At work I have to spend all day punching in database entries in microsoft excel. I flip through pages and pages on this website, and on each page there are 50 links. In each link is a profile with contact information. I simply go to the page with the 50 links, click on each link, put the persons phone # and name and address in an excel spreadsheet, and then go on to the next contact. Is there anyway to automate this process? Any program I can use? If you can figure it out, it would make my life a whole bunch easier.
jhardman's Avatar
Moderator
 
Join Date: Jan 2007
Location: logan, utah
Posts: 2,690
#2: Jul 9 '08

re: Extracting names and phone numbers from web links


Most modern programming languages could handle this, the question is, with which languages are you most familiar? You will have to do the implementation.

Jared
tharden3's Avatar
Site Addict
 
Join Date: Jul 2008
Location: Ocala, FL (United States)
Posts: 817
#3: Jul 9 '08

re: Extracting names and phone numbers from web links


Quote:

Originally Posted by jhardman

Most modern programming languages could handle this, the question is, with which languages are you most familiar? You will have to do the implementation.

Jared

The truth is, I am relatively new to programming and only know simple Python and Ruby. Is there software I can purchase? Or maybe some open-source stuff i can download? i could definitely not write anything to help me with my situation. Maybe I could in ten or twelve years, but.... that's a bit long to wait if you catch my drift.
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,672
#4: Jul 14 '08

re: Extracting names and phone numbers from web links


I have to ask why you only have the information available to you via the web.

Is it even information that you have any rights to?

I suggest, if the answer to this is "yes" that you ask your bosses to provide the information in a more easily managed way.

If not, then I'm afraid we cannot (will not) help.
Atli's Avatar
Moderator
 
Join Date: Nov 2006
Location: Iceland
Posts: 3,740
#5: Jul 15 '08

re: Extracting names and phone numbers from web links


That was my thought as well. Why would you have to do this via this website?

Odds are that the data you are collecting from this website is in a database somewhere, and those who take care of this database and the website should easily be able to compile this data into a file you could open in Excel.

Could you not simply ask them to do this for you?
Reply


Similar Software Development bytes