473,385 Members | 1,606 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

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
2 809
zmbd
5,501 Expert Mod 4TB
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
32,556 Expert Mod 16PB
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

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

Similar topics

1
by: Steve Chen | last post by:
We just released a wireless search service. The wireless search service takes the results returned by Google and gives key points of the resulting web sites. The short key points are suitable for...
3
by: cjh999777 | last post by:
Hi, I am new to using databases in vb.net and i have created a accessdatabase called employee it has a key field called employeeID. Ihave gotton as far as creating the dataconnection,...
0
by: Peter Wang | last post by:
I have a function and am using cursor. All the columns I select in the cursor clause are BYTEA datatype. I need to compare the after-fetch-value for two BYTEA columns which is temp2 and temp3...
2
by: Bob Sanderson | last post by:
I have a search form from which I hope to be able to select a record by field JobNumber and display it with an output form titled test.php <html> <head> <title>Job Database Search</title>...
2
by: lifeshortlivitup | last post by:
I had to create a program that allows the user to input a temp and then click on either the convert to fahrenheit or convert to celsius button and then display that result within the textbox that...
3
by: chungiemo | last post by:
Hi I have a project with access it has 2 non-related tables in access, which should have been related by ID, due to the poor data entry standards I am trying to match records from table 1 to...
3
by: getajaysharma | last post by:
Hi All I am having problem. i want to compare the results of Stored Procedure & SQL Query. Can any one tell me how can i achive this. Please expalin with example. Regards Ajay Sharma
5
by: th1982 | last post by:
HI All I have a search page' s result which view 3results/per page,but my "next" link to view next page is not working. Here is my code : <?php // Get the search variable from URL ...
2
by: rajsrmc | last post by:
Hello experts Let's say I have a gridview with some columns like, title, name, funding agency. Here's an example of what I want to do: I want to display all the records in the gridview to start....
5
by: irslan rafique | last post by:
Hi, I have three tables: Table A, Table B and Table C Fields of Table A: Truck No, Capacity Fields of Table B: Consignee ID, Capacity A, Capacity B and Capacity C Fields of...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
Oralloy
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.