Project Detail

script to extract data from web  

script to extract data from web is project number 204331
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: Uppuganti

Budget: $30-100

Created: 12/13/2007 at 16:39 EST

Bid Count: 13

Average Bid:
$ 66

12/15/2007 at 16:39 EST

Project Creator: andromeda2004
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (21 reviews)

Bid On This Project
 

Description

This is NOT a manual entry job. This project requires you to create a small program or to create a script inside excel.

Project details:
I have created an excelsheet (sample.xls) attached that I would like to automatically update.

Your program/script will do two things: 1) It will read the artist name from the excelsheet and search the corresponding information from the web (allmusic.com). 2) It will return and update the values in the excelsheet. (It needs to be flexible enough to allow me to edit the information in case it does not pull the correct information).

The information I need to automatically update is 3 pieces of information:

1) Last album name (main studio albums only, not compilation albums, single or eps)

2) Last album release date (month/day/year)

3) Last review date (month/day/year)

For the sources, I would like to use:
For 1+2) allmusic.com
For 3) i will give you a link to a website that i created, but that requires login info. So your program/script should be flexible enough to allow me to update the username/password.

A sample excel sheet (sample.xls) is attached. I will enter the artist name and everything else should fill out/update automatically. For artists we cannot match, we simply leave it blank or I enter it by hand afterwards so that I can maintain that excelsheet. I will add new artists almost every day.

I also attached a first attempt (called demo.xls) at creating the solution to this project so you have an idea how it should work. Instead of the year it should list the exact album date, so that it can be used to make some calculations as you can see in the sample.xls file. In the end, format should look exactly as in sample.xls.

I have 3 other projects where I need someone to extract data from websites, etc and create some scripts. If you are good we can immediately continue with those as well.

If you have any questions, feel free to ask me. Need this asap!Thanks!


Additional files submitted:
sample.xls
demo.xls

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

100

2 days

12-13-2007 18:24 EST

help

 

80

3 days

12-14-2007 02:32 EST

Hello,Please refer your PMB.Thank you.

help

 

100

2 days

12-14-2007 08:48 EST

Please check PMB.

help

 

100

4 days

12-14-2007 10:13 EST

Hi, This is more than a $100 project. More info was sent in the PM. Best Regards, Yousef

help

 

50

2 days

12-13-2007 23:32 EST

This can be done.Please see pm details.

help

 

100

3 days

12-13-2007 20:39 EST

I think you are going to quickly find that this is more than a $100 project {sigh}. Hello my name is Bill.. I am a VB.Net, VB6, VBA, VBScript, SQL, MsAccess, MsExcel, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed several GAF projects, so you can find additional references for me here: http://elance.com/users/feedback_172391.html I have 20+ years of hands-on Programming and Business Information System experience to include Internet interfacing applications. I have a BS in Accounting / Marketing Minor; graduating with the highest of honors. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving ALL of your goals in your every endeavor. Respectfully, Bill.

help

 

45

6 days

12-13-2007 18:03 EST

Hi there, check your PM for details, thanks!

help

 

50

2 days

12-13-2007 22:36 EST

Please check pmb.

help

 

50

2 days

12-13-2007 16:44 EST

(No Feedback Yet)

cheeck pmb sir

help

 

80

2 days

12-14-2007 00:02 EST

(No Feedback Yet)

hi I have a good experence to extract data from sites so I can do it very easily u can email me [removed]

help

 

32

3 days

12-14-2007 03:12 EST

(No Feedback Yet)

basic knoweldge in computer. & hardware

help

 

30

1 day

12-14-2007 10:35 EST

(No Feedback Yet)

pay me the Amount that you Can Have A Deal frequently..! more I can work For lesser You Pay

help

 

40

0 days

12-15-2007 01:09 EST

(No Feedback Yet)

Hello, * I spent the last 3 years creating automatic data entry stuff exaclty like what You are talking about. * The most notable and fun is a bot which automatically plays online strategy games; the most useful one made in few minutes the many-days-long work of 25 data entries (secretaries) in a small business. :) * I also made lots of scripts like this for the online apartment rental and management services of the Torino2006 Olympic committee. * I shouldn't take more than 2 hours, with both functionality and user interface. :) P.S.: Let me also suggest You to consider using some kind of database software instead of Excel, even Access (Excel is OK anyway, and this only a suggestion): if You want to make strange or just more complex and interactive things, You'll have several benefits from the way Access handles data ^__^ P.P.S.: Yes, I know, It's my first day at GAF.com, but I just discovered it two days ago. Therefore nobody could have posted comments about me. I hope I have been convincing anyway :) Best regards, DM

help


    Bid on this Project