By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,775 Members | 2,658 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,775 IT Pros & Developers. It's quick & easy.

automation help to search contact in web and compare result and give output

P: 1
I need help and suggestions: I had a list of contacts and their details its a bulk. I need to verify those names and contact details are matching with my database site or not. In detail my database site user interface have search option if I give name of person with id of that person have if it matches it shows else throws error. so I needs help & suggestion do I can make a macro using excel that can run bulk contacts validation and give output as true if matches or if not as false. in this way I am thinking or please suggest me is der any other way or script that helps me to do this bulk validation check.

I need to validate person contact with database where I cannot extract details list from db in any format that is constraint so only option I need to type and search contacts and validate so help me how can I automate this validation process. Thanks in advance,........for help and support/
example:
company name id city
tata Group 52 india

if i enter this data in excel sheet in column a,b,c the when i run macro it need to search in Google and compare data that tata group and person in that city or not and result in excel saying if matches data in excel and website as yes if not it should give no.
Jun 23 '17 #1
Share this Question
Share on Google+
2 Replies


zmbd
Expert Mod 5K+
P: 5,397
kalyan19
This is a very complex task, entering data from excel into a webpage isn't as straight forward as you would think and requires a lot of very esoteric code.

+ What is your programing experience/background?

+ What have you tried so far?

+ You have not provided enough detail about the database you want to validate nor where you are getting the data to use for the validation; therefore, there's really nothing at this point that we can do to help.
Jun 24 '17 #2

NeoPa
Expert Mod 15k+
P: 31,417
Hi Kalyan.

As Zmbd says, this is not a valid question, but rather a project specification.

I have no problem with anyone helping you as far as they can, but be clear this is not what we're about. There is no expectation on any of our experts or members to help, but you may get lucky.

If you were to break it down into constituent technical questions, on the other hand, then we may be able to help a lot more.

-Adrian (Administrator).
Jun 24 '17 #3

Post your reply

Sign in to post your reply or Sign up for a free account.