Extract names, phone numbers, email addresses from web sites into a database提取物的名称,电话号码,电子邮件地址,从网站到数据库

Posted on October 17, 2008 at 5:23 am发布于08年10月17号在上午05时23分

Wouldn’t it be nice if you could convert a bunch of data from Super Pages or Yellow Pages into an Excel table or an Access database?那岂不是很好如果你能转换成一串数据从超级网页或黄页到Excel表或一个Access数据库? If you have a business where you need to take a large list of names, phone numbers, email addresses, street addresses and put them into your CRM database or into Outlook, then you might be interested in this nifty little freeware app.如果您有业务,您需要一个大名单,电话号码,电子邮件地址,街道地址,并把它们到您的CRM数据库或到Outlook ,那么您可能有兴趣在这个漂亮的小免费的应用程序。

ZoloPages ZoloPages is a free program that can extract data from a web site or web page (web data mining) and convert it into a more user-friendly format like Excel (XLS), Access (CSV), or XML!是一个免费的程序,可以提取数据从一个网站或网页( Web数据挖掘) ,并转换成一个更加方便用户的格式,如Excel ( XLS ) ,存取文件( CSV ) ,或XML ! Personally, I don’t have a business, but I am sure I could use it to save a list of doctors in my area or my favorite films, etc.就个人而言,我并没有业务,但我相信,我可以用它来保存的医生名单在我区或我最喜爱的影片等

Web数据挖掘

The way the program works is that it has some pre-configured sites that it works with, such as Yellow Pages, Super Pages, 411, etc. You download the program and go to to the File menu and choose Open a Zolo Page .道路工程的计划是,它有一些预先设定的网站,它与工程,如黄页,超级页, 411等您下载该程序并转到档案菜单,并选择打开一个Zolo页。

数据挖掘

Now you can choose from the list of web sites that it can extract data from.现在,您可以选择从名单上的网站,它可以提取数据。 There are a couple of US ones at the top and then a bunch of other ones from different countries.有几个美国的上方,然后一大堆其他的来自不同国家。 These are called Zolo Masks.这些被称为Zolo面具。 You have to have a mask in order to capture data from a website!你必须有一个面具,以收集数据,从一个网站!

You can either download more masks at您可以下载更多的口罩在 Zolo Masks Zolo面具 or you can create your own mask for the particular website you want to extract data from.或者您也可以建立自己的面具为特定网站要提取的数据。 If you create your own masks, you can then do things like go to AutoTrader.com and download a list of a bunch of used cars in your area that you are looking to buy.如果您创建自己的面具,然后你可以做的事情一样去AutoTrader.com和下载的名单一堆的二手车销售的领域,你在寻找购买。 Or you can go to Eventful.com and download a list of all events going on locally in your area!或者,您可以去Eventful.com和下载列出了所有事件发生在当地的地区!

You get the idea?你的想法? By default, it’s limited to only a few sites, but if you spend a little time creating your own Zolo Mask, you can basically extract data from any website!默认情况下,它的只限于少数网站,但如果你花一些时间创建自己的Zolo面具,你可以提取数据基本上来自任何网站! There is also an extensive help included with the program so you can figure out exactly how to create your own mask.还有一个广泛的帮助包括的程序,因此您可以找出如何建立自己的面具。 It’s worth to note that Super Pages also lets you search for restaurants, physicians, hotels, car dealers and more in your area.值得指出,超级网页,您还可以搜索餐馆,医生,旅馆,汽车经销商,更在您的地区。

Once you’ve loaded the site and performed the search you click on the Select and Save button to save the data into XLS, XML, or CSV format.一旦你的网站加载和执行搜寻您按一下选择和保存按钮保存数据转化为XLS , XML或CSV格式。

zolo页

You also have other options such as inverting the name, capturing the full address or just the street, and more.你也有其他选择,如翻的名称,捕捉完整的地址或只是在街上,等等。 Note that you actually browse the website within the program itself on the Surf & Collect page.请注意,您实际上浏览网页的程序本身的海浪&收集网页。

I ran it myself to get a list of moving companies in Atlanta, GA and it worked pretty well!我跑它自己得到的清单移动公司在佐治亚州亚特兰大,它的工作相当不错! It extracted the name, address, city, state, zip, phone, fax, and website name from the web site in just a few minutes!它提取的名称,地址,城市,州,邮政编码,电话,传真和网站名称的网站,只需几分钟时间!

zolo口罩

So if you are looking for a free web mining or data mining program that can pull data from web sites and web pages into Excel or Access database, then you will want to check out Zolo Pages.所以,如果你正在寻找免费的网络采矿或数据挖掘程序,可以将数据从网站和网页到Excel或Access数据库,然后你会想查看Zolo页。 Enjoy!享受!

Enjoyed this post?得到这个职位? Subscribe to Online Tech Tips via订阅在线应用技巧通过 RSS Feed RSS供稿 or via或通过 Email电子邮件 and receive free daily productivity tips.并获得免费日报的生产力秘诀。

» Filed Under »文章属于 Software Reviews软件评述

添加到美味 Save this page 保存该网页 它Mixx Stir it up on Mixx 它搅动了Mixx
Reddit Add to Reddit 添加到Reddit StumbleUpon公司 Stumble this page 失败此页

Related Posts 有关职位

One Response to “Extract names, phone numbers, email addresses from web sites into a database” 一对“物的名称,电话号码,电子邮件地址,从网站到数据库”

  1. Pavan Kumar 帕凡库马尔 said on : 说:

    Bad tool, its a boon for spammers 坏的工具,它有利于为垃圾邮件


    Please post your comments/suggestions! 请张贴您的意见/建议!