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.
4  1844  jhardman 3,406
Recognized Expert Specialist
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
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 32,566
Recognized Expert Moderator MVP
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 5,058
Recognized Expert Expert
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?
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: lecichy |
last post by:
Hello
Heres the situation:
I got a file with lines like:
name:second_name:somenumber:otherinfo
etc with different values between colons ( just like passwd file)
What I want is to extract some part of it like all names or numbers from
each line, simply text fom between e.g. second and third colon. And turn it
|
by: joemono |
last post by:
Hello everyone!
First, I appologize if this posting isn't proper "netiquette" for this
group.
I've been working with perl for almost 2 years now. However, my regular
expression knowledge is pretty limited. I wrote the following expression to
take (hopefully) any _reasonable_ phone number input, and format it as
(999) 999-9999 x 9999.
|
by: Eych |
last post by:
I have several functions that retrieve information from databases based
on the fieldname passed in (e.g. GetValue(dbUsers, userID, "Fax"))
what is the best way to not hard-code field names?
Something like this would be nice:
Enum UserTable
Fax = "Fax"
Phone = "Phone"
|
by: Brian Henry |
last post by:
I have phone numbers like this in a data table
123-435-1234
1231231234
432.234.2321
they all have different formatting, what I want to do is get them all
formatted like this
(123) 123-1234
|
by: laredotornado |
last post by:
Hi,
Does anyone have a cross-browser JS function that validates a US phone
number? I consider the following to be valid phone number formats:
var p = "5558675309";
var p = "(312) 123-4567";
var p = "512-234-5678";
Thanks, - Dave
| | |
by: sebzzz |
last post by:
Hi,
I work at this company and we are re-building our website: http://caslt.org/.
The new website will be built by an external firm (I could do it
myself, but since I'm just the summer student worker...). Anyways, to
help them, they first asked me to copy all the text from all the pages
of the site (and there is a lot!) to word documents. I found the idea
pretty stupid since style would have to be applied from scratch anyway
since we...
|
by: lim4801 |
last post by:
I am currently in doing a program which is given by my tutor:
Contemplate that you are working for the phone company and want to sell "special" phone numbers to companies. These phone numbers are "special" because they are easily translated into words. You've been asked to create a list of phone numbers that are directly mappable to words by searching a dictionary for every 7 or 10 letter word that maps on to the phone lettering scheme:
...
|
by: brad |
last post by:
Crazy question, but has anyone attempted this or seen Python code that
does? For example, if a text file contained 'Guido' and or 'Robert' and
or 'Susan', then we should return True, otherwise return False.
|
by: Propoflady |
last post by:
My contacts can have as many as five or six phone numbers - is it
possible to make a query that puts the name, and each phone number
after it on the same line - for this reason I have two tables - client
and phone linked by client id
right now I get
contact a - phone number 1
contact a - phone number 2
I would like
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
