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.
-
-
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.Originally posted by jhardmanComment
-
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.Comment
-
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?Comment
Comment