I am easy to work with, communicative, and almost always give all-5-star review.
=======Project description===========
Open the attached "[login to view URL]". I want to make this type of format using musicbrainz data.
[login to view URL] is a music data website, and each artist, label, release, recording has their own MBID (musicbrainz identifier)
I will make an excel spreadsheet "[login to view URL]" containing a list of artists.
Suppose the [login to view URL] 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 "[login to view URL]" 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
[login to view URL]
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
[login to view URL]
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 [login to view URL] along with the song's year "2010" and main artist "Eminem"
But, for the recording at [login to view URL]
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 [login to view URL] and
[login to view URL]
You can download the entire musicbrainz data dump in xml.
A crude schema is at [login to view URL] .
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
[login to view URL]
If you are stuck, you can even ask questions on musicbrainz forum at
[login to view URL]
======I will tell you more details once you post a message.=======