Using External Input Data in Off-the-shelf Web Scrapers

There is a question I’ve wanted to shed some light upon for a long time already: “What if I need to scrape several URL’s based on data in some external database?“.

For example, recently one of our visitors asked a very good question (thanks, Ed):

    “I have a large list of amazon.com asin. I would like to scrape 10 or so fields for each asin. Is there any web scraping software available that can read each asin from a database and form the destination url to be scraped like http://www.amazon.com/gp/product/{asin} and scrape the data?”

This question impelled me to investigate this matter. I contacted several web scraper developers, and they kindly provided me with detailed answers that allowed me to bring the following summary to your attention:
Visual Web Ripper

An input data source can be used to provide a list of input values to a data extraction project. A data extraction project will be run once for each row of input values. You can find the additional information here.
Web Content Extractor

You can use the -at”filename” command line option to add new URLs from TXT or CSV file:

    WCExtractor.exe projectfile -at”filename” -s

projectfile: the file name of the project (*.wcepr) to open.
filename – the file name of the CSV or TXT file that contains URLs separated by newlines.
-s – starts the extraction process

You can find some options and examples here.
Mozenda

Since Mozenda is cloud-based, the external data needs to be loaded up into the user’s Mozenda account. That data can then be easily used as part of the data extracting process. You can construct URLs, search for strings that match your inputs, or carry through several data fields from an input collection and add data to it as part of your output. The easiest way to get input data from an external source is to use the API to populate data into a Mozenda collection (in the user’s account). You can also input data in the Mozenda web console by importing a .csv file or importing one through our agent building tool.

Once the data is loaded into the cloud, you simply initiate building a Mozenda web agent and refer to that Data list. By using the Load page action and the variable from the inputs, you can construct a URL like http://www.amazon.com/gp/product/%asin%.
Helium Scraper

Here is a video showing how to do this with Helium Scraper:

The video shows how to use the input data as URLs and as search terms. There are many other ways you could use this data, way too many to fit in a video. Also, if you know SQL, you could run a query to get the data directly from an external MS Access database like
SELECT * FROM [MyTable] IN "C:\MyDatabase.mdb"

Note that the database needs to be a “.mdb” file.
WebSundew Data Extractor
Basically this allows using input data from external data sources. This may be CSV, Excel file or a Database (MySQL, MSSQL, etc). Here you can see how to do this in the case of an external file, but you can do it with a database in a similar way (you just need to write an SQL script that returns the necessary data).
In addition to passing URLs from the external sources you can pass other input parameters as well (input fields, for example).
Screen Scraper

Screen Scraper is really designed to be interoperable with all sorts of databases. We have composed a separate article where you can find a tutorial and a sample project about scraping Amazon products based on a list of their ASINs.

Source: http://extract-web-data.com/using-external-input-data-in-off-the-shelf-web-scrapers/

A simple way to turn a website into JSON

Recently, while surfing the web I stumbled upon an simple web scraping service named Web Scrape Master. It is a kind of RESTful web service that extracts data from a specified web site and returns it to you in JSON format.
How it works

Though I don’t know what this service may be useful for, I still like its simplicity: all you need to do is to make an HTTP GET request, passing all necessary parameters in the query string:
http://webscrapemaster.com/api/?url={url}&xpath={xpath}&attr={attr}&callback={callback}

    url  - the URL of the website you want to scrape
    xpath – xpath determining the data you need to extract
    attr - attribute the name you need to get the value of (optional)
    callback - JSON callback function (optional)

For example, for the following request to our testing ground:

http://webscrapemaster.com/api/?url=http://testing-ground.extract-web-data.com/blocks&xpath=//div[@id=case1]/div[1]/span[1]/div

You will get the following response:

[{"text":"<div class='name'>Dell Latitude D610-1.73 Laptop Wireless Computer</div>","attrs":{"class":"name"}}]
Visual Web Scraper

Also, this service offers a special visual tool for building such requests. All you need to do is to enter the URL of the website and click to the element you need to scrape:
Visual Web Scraper
Conclusion

Though I understand that the developer of this service is attempting to create a simple web scraping service, it is still hard to imagine where it can be useful. The task that the service does can be easily accomplished by means of any language.

Probably if you already have software receiving JSON from the web, and you want to feed it with data from some website, then you may find this service useful. The other possible application is to hide your IP when you do web scraping. If you have other ideas, it would be great if you shared them with us.



Source: http://extract-web-data.com/a-simple-way-to-turn-a-website-into-json/

How Your Online Information is Stolen - The Art of Web Scraping and Data Harvesting

Web scraping, also known as web/internet harvesting involves the use of a computer program which is able to extract data from another program's display output. The main difference between standard parsing and web scraping is that in it, the output being scraped is meant for display to its human viewers instead of simply input to another program.

Therefore, it isn't generally document or structured for practical parsing. Generally web scraping will require that binary data be ignored - this usually means multimedia data or images - and then formatting the pieces that will confuse the desired goal - the text data. This means that in actually, optical character recognition software is a form of visual web scraper.

Usually a transfer of data occurring between two programs would utilize data structures designed to be processed automatically by computers, saving people from having to do this tedious job themselves. This usually involves formats and protocols with rigid structures that are therefore easy to parse, well documented, compact, and function to minimize duplication and ambiguity. In fact, they are so "computer-based" that they are generally not even readable by humans.

If human readability is desired, then the only automated way to accomplish this kind of a data transfer is by way of web scraping. At first, this was practiced in order to read the text data from the display screen of a computer. It was usually accomplished by reading the memory of the terminal via its auxiliary port, or through a connection between one computer's output port and another computer's input port.

It has therefore become a kind of way to parse the HTML text of web pages. The web scraping program is designed to process the text data that is of interest to the human reader, while identifying and removing any unwanted data, images, and formatting for the web design.

Though web scraping is often done for ethical reasons, it is frequently performed in order to swipe the data of "value" from another person or organization's website in order to apply it to someone else's - or to sabotage the original text altogether. Many efforts are now being put into place by webmasters in order to prevent this form of theft and vandalism.




Source: http://ezinearticles.com/?How-Your-Online-Information-is-Stolen---The-Art-of-Web-Scraping-and-Data-Harvesting&id=923976

Offline Data Entry - 3 Ways of Offline Data Entry Solution

Your company can get out of critical situation only if you have right information on hand. This is one of the most common problems in most of the organizations. They do not understand the preciousness of the information. There is another barrier that companies are facing such as cost of storing and managing the information.

Offline data entry is the solution for organizing the information. By offline data typing, you can generate digital copy of important paper document. The digital format is very easy to manage. It also requires less storage space. So, offline data typing can solve your problem of storage space, time of management as well as the cost.

Most of the companies require following 3 ways of offline data entry solution:

Entering Information from web: This is related to research. It is merely a copy-past type of task. For instance, medical organization requires the data of doctor such as name, degree, address, phone number and other detail. So, coping from web and pasting in to require application. Generally, organizations are using such service to collect person/company related information. You can outsource detail requirements to some reputed company as offline data entry project.

Entering Information in Software: In this type, you have to provide software of program as well as the paper document. Data typing professional from entry firm will enter the information into your program from the paper document. Such type of task is helpful to generate big database or organizing the lacs of detail.

Entering Information in word, excel and other application: If you have reports or huge documents and want to convert into digital format, this is the way. It is very hard to maintain the same quality of paper year by year. I am sure that the quality will degrade over a period of time. By entering the information in word, excel or other application, you can easily solve such problem.

The payment is the issue for any company. In such type of task companies are charging the money per entry. If you have descriptive offline data entry, they may charge per page or per word. These are the general formats of payment.

One Advice "To avoid scam; please outsource your offline data entry requirement to reputed company only."

Bea Arthur is a quality controller at Data Entry India, a well-known firm, accepting data entry projects, data conversion projects and data processing projects. They are having more than 17 years of experience in offline data entry.




Source: http://ezinearticles.com/?Offline-Data-Entry---3-Ways-of-Offline-Data-Entry-Solution&id=4341318

Online Data Entry and Data Mining Services

Data entry job involves transcribing a particular type of data into some other form. It can be either online or offline. The input data may include printed documents like Application forms, survey forms, registration forms, handwritten documents etc.

Data entry process is an inevitable part of the job to any organization. One way or other each organization demands data entry. Data entry skills vary depends upon the nature of the job requirement, in some cases data to be entered from a hard copy formats and in some other cases data to be entered directly into a web portal. Online data entry job generally requires the data to be entered in to any online data base.

For a super market, data associate might be required to enter the goods which have sold in a particular day and the new goods received in a particular day to maintain the stock well in order. Also, by doing this the concerned authorities will get an idea about the sale particulars of each commodity as they requires. In another example, an office the account executive might be required to input the day to day expenses in to the online accounting database in order to keep the account well in order.

The aim of the data mining process is to collect the information from reliable online sources as per the requirement of the customer and convert it to a structured format for the further use. The major source of data mining is any of the internet search engine like Google, Yahoo, Bing, AOL, MSN etc. Many search engines such as Google and Bing provide customized results based on the user's activity history. Based on our keyword search, the search engine lists the details of the websites from where we can gather the details as per our requirement.

Collect the data from the online sources such as Company Name, Contact Person, Profile of the Company, Contact Phone Number of Email ID Etc. are doing for the marketing activities. Once the data is gathered from the online sources into a structured format, the marketing authorities will start their marketing promotions by calling or emailing the concerned persons, which may result to create a new customer. So basically data mining is playing a vital role in today's business expansions. By outsourcing the data entry and its related works, you can save the cost that would be incurred in setting up the necessary infrastructure and employee cost.

E-dataentry is an offshore India based company providing superior quality data mining services to clients across the globe with high level of accuracy at reasonable price.




Source: http://ezinearticles.com/?Online-Data-Entry-and-Data-Mining-Services&id=7713395

Outsource Data Entry Services to Reduce Labour Cost

India has become a hub for outsourcing services. One of the services being outsourced highly to India is data entry. Managing data is a tough task, especially for growing organizations. So, many of these organizations outsource their services to India.

Outsourcing data entry services to India helps companies in maintaining everyday records and details in proper order. India has many reputed firms dealing with our services. These companies have highly qualified and experienced experts that assist you in managing business related data aptly. Experts keep themselves updated with the latest technologies to live up to your expectations.

These can be availed both offline and online. Online services include managing data from e books, image files, and web browsers. Offline services include managing data from documents, papers and directories. Outsourcing data entry services to India will help you get an appropriate solution for data processing. You can also ask for a free trial of the data entering services before outsourcing your work to them. Other services that you can avail are word and data conversion, OCR clean up and PDF conversion.

By outsourcing your services to India, you can enjoy the benefit of saving up to 70% cost incurred on business operations. Thus, outsourcing will help you drive down the cost that can be further invested in the expansion of the business.

Data entry services can be outsourced regardless of the industry type. Be it retail, lodging, finance or real estate, this type of companies cover every field you can think of. By outsourcing tasks you can minimize the workload of your employees, thereby improving their efficiency and competence. This too puts you on the forefront as it reduces the labor cost up to a great extent without any effect on quality.




Source: http://ezinearticles.com/?Outsource-Data-Entry-Services-to-Reduce-Labour-Cost&id=5805062

Data Mining Tools - Understanding Data Mining

Data mining basically means pulling out important information from huge volume of data. Data mining tools are used for the purposes of examining the data from various viewpoints and summarizing it into a useful database library. However, lately these tools have become computer based applications in order to handle the growing amount of data. They are also sometimes referred to as knowledge discovery tools.

As a concept, data mining has always existed since the past and manual processes were used as data mining tools. Later with the advent of fast processing computers, analytical software tools, and increased storage capacities automated tools were developed, which drastically improved the accuracy of analysis, data mining speed, and also brought down the costs of operation. These methods of data mining are essentially employed to facilitate following major elements:

    Pull out, convert, and load data to a data warehouse system
    Collect and handle the data in a database system
    Allow the concerned personnel to retrieve the data
    Data analysis
    Data presentation in a format that can be easily interpreted for further decision making

We use these methods of mining data to explore the correlations, associations, and trends in the stored data that are generally based on the following types of relationships:

    Associations - simple relationships between the data
    Clusters - logical correlations are used to categorise the collected data
    Classes - certain predefined groups are drawn out and then data within the stored information is searched based on these groups
    Sequential patterns - this helps to predict a particular behavior based on the trends observed in the stored data

Industries which cater heavily to consumers in retail, financial, entertainment, sports, hospitality and so on rely on these data methods of obtaining fast answers to questions to improve their business. The tools help them to study to the buying patterns of their consumers and hence plan a strategy for the future to improve sales. For e.g. restaurant might want to study the eating habits of their consumers at various times during the day. The data would then help them in deciding on the menu at different times of the day. Data mining tools certainly help a great deal when drawing out business plans, advertising strategies, discount plans, and so on. Some important factors to consider when selecting a data mining tool include the platforms supported, algorithms on which they work (neural networks, decisions trees), input and output options for data, database structure and storage required, usability and ease of operation, automation processes, and reporting methods.

Jeff Smith is the managing director of Karma Technologies and feels strongly about implementing ways to be green into their business practices, to a point they are almost a paper-free company.




Source: http://ezinearticles.com/?Data-Mining-Tools---Understanding-Data-Mining&id=1109771