Welcome to WebmasterWorld Guest from 54.144.72.150

Forum Moderators: not2easy

Message Too Old, No Replies

Website data extraction

     
11:20 am on Aug 19, 2011 (gmt 0)

Junior Member

5+ Year Member

joined:June 25, 2007
posts:108
votes: 0


Has anyone had experience retriving data from a site using 3rd party software, i badly need an export of data from my site but do not have a facility to do so, im expecting my developers to charge but im wonding if there is some software that will crawl the site and pull off the info I (price, type, description etc) need for around 2000 products.
12:23 pm on Aug 19, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 7, 2003
posts:788
votes: 0


I've used the paid service from Mozenda but I assume you are looking for a free service.
If it is a SQL database could you not export the data yourself.
1:19 pm on Aug 19, 2011 (gmt 0)

Junior Member

5+ Year Member

joined:June 25, 2007
posts:108
votes: 0


Hi I just looked a Mozenda, yes ist is an SQL database but its hosted with the developers which I have no access, My CMS is archaic so cant do it from there. Im expecting the devs to charge so i was just wondering if there is an alternative.
2:08 pm on Aug 19, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Dec 7, 2003
posts:788
votes: 0


Compare the Developers fee with what Mechanical Turk would cost.
8:41 am on Sept 21, 2011 (gmt 0)

Junior Member

5+ Year Member

joined:June 25, 2007
posts:108
votes: 0


Hi All

Just to re-touch on this subject my developers have increased there quote from 350 to 495 to 1125 for the task of creating a csv export facility from a CMS.

Due to the miss quoting they have offered to do the work for 750 now this still seems rather high considering exporting the data directly from the SQL server can be done relatively easly, The site is basic php, I would not thave thought it would be so expensive.
9:33 am on Sept 21, 2011 (gmt 0)

Senior Member

WebmasterWorld Senior Member 5+ Year Member

joined:Feb 12, 2006
posts:2492
votes: 22


if all the info you need about each product is displayed using the same template, then it should be pretty easy to scrape the data straight from the page

if you're only talking about 2000 products then it wouldn't even take very long. you just need someone to write a simple little .php script for you
9:35 am on Sept 21, 2011 (gmt 0)

Moderator from GB 

WebmasterWorld Administrator brotherhood_of_lan is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Jan 30, 2002
posts:4842
votes: 1


A simple one line command with WGET can fetch all the pages, and as said, a simple script can extract the data from them.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members