Closed

Data fetcher (Get hints from the program I have!)

This project received 8 bids from talented freelancers with an average bid price of $125 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
8
Project Description

I am easy to work with, communicative, and almost always give all-5-star review.

=======Project description===========

Open the attached "[url removed, login to view]". I want to make this type of format using musicbrainz data.

[url removed, login to view] is a music data website, and each artist, label, release, recording has their own MBID (musicbrainz identifier)

I will make an excel spreadsheet "[url removed, login to view]" containing a list of artists.

Suppose the [url removed, login to view] contains only one artist "Rihanna"

I want a program to get the list of songs (=recordings) that Rihanna participated as a "featuring" or "guest" artist rather than as a "main" artist.

The result will look like the "[url removed, login to view]" that I attached.

However, don't include songs that are in compilation or remix album.

====Meaning of recording, release, "don't include recordings with compilation and remix release"===

Go to
[url removed, login to view]

You will see the recording (=song) "Love the way you lie" 's release artist is "Eminem feat. Rihanna"

This means Eminem is the main artist and Rihanna is the featuring artist of the song "Love the way you lie".

For this recording with MBID "29d6a30b-b911-475c-808c-8b289844ca75", there are 6 release titles.

Clicking the first release title "recovery", you will get to

[url removed, login to view]

In the right part of the page, you will see "Additional details" and "Type:Album".

This means the album is neither compilation nor remix.

So include this song in the [url removed, login to view] along with the song's year "2010" and main artist "Eminem"

But, for the recording at [url removed, login to view]

there are two release titles but both's album type is "Album+Compilation".

So don't include this recording in the format_about_featured.xlsx.

=====You don't need to do both idea 1 and 2. Do just one. Or suggest me a better idea====
======Idea 1: Use musicbrainz webserver request========

Musicbrainz lets developers to connect to its webserver.

I already have such a program coded by a previous programmer.

I will send you this once you post message.

For this webserver idea also, don't include recordings which are only in compilation or remix albums.


=======Idea 2: Use data dump of musicbrainz============

Go to [url removed, login to view] and

[url removed, login to view]

You can download the entire musicbrainz data dump in xml.

A crude schema is at [url removed, login to view] .

For this xml idea also, don't include recordings which are only in compilation or remix albums.

=======Other ideas are welcome========

Or if you find out a better way to make the number of artists updated during a

specified time range, then you don't necessary have to use

[url removed, login to view]

If you are stuck, you can even ask questions on musicbrainz forum at

[url removed, login to view]

======I will tell you more details once you post a message.=======

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online