hi there,
it has come to my attention that what I am trying to achieve is the pseudo-completion of album track listings with existing pre ripped tracks
as the title and artist wording of tracks in my collection have already been verified this post focuses on the musicbrainz datastream, the actual source of the information is not important.
take the following best of complication album (10cc):
Wikipedia lists 2 releases (uk with 18 tracks, and us with 15 tracks)
http://en.wikipedia.org/wiki/The_Very_Best_of_10cc
musbrainz tag lookup (
http://musicbrainz.org/taglookup.html) returns 4 albums with 100% match each
100 The Very Best of 10cc 10cc 18 1 gb 1997-03-07 compilation eng / latn
100 The Very Best of 10cc 10cc 18 1 gb 2009-04-20 compilation eng / latn
100 The Very Best of 10cc 10cc 15 1 us 1997 us 1997-06-17 compilation eng / latn
100 The Very Best of 10cc 10cc 18 2 gb 1991 compilation eng / latn
Code: Select all
comma deliminated cause I cant figure out how to show intable
track#, 18 1 gb 1997-03-07, 18 1 gb 2009-04-20 , 15 us 1997-06-17, 18 gb 1991
1,Donna - 10cc, Dreadlock Holiday - 10cc, Donna - 10cc,The Wall Street Shuffle - 10cc
2,Rubber Bullets - 10cc,The Things We Do for Love - 10cc,Rubber Bullets - 10cc,I'm Not in Love - 10cc
3,The Dean and I - 10cc,I'm Not in Love - 10cc,The Dean and I - 10cc,Art for Art's Sake - 10cc
4,The Wall Street Shuffle - 10cc,Cry - Godley & Creme,The Wall Street Shuffle - 10cc,Dreadlock Holiday - 10cc
5, Silly Love - 10cc,Rubber Bullets - 10cc,Silly Love - 10cc,People in Love - 10cc
6, Life Is a Minestrone - 10cc,The Wall Street Shuffle - 10cc,Life Is a Minestrone - 10cc,Donna - 10cc
7,Une Nuit a Paris: One N….- 10cc,I'm Mandy Fly Me - 10cc,I'm Not in Love - 10cc,Life Is a Minestrone - 10cc
8,I'm Not in Love - 10cc,Under Your Thumb - Godley & Creme,Art for Art's Sake - 10cc,I'm Mandy Fly Me - 10cc
9,Art for Art's Sake - 10cc,Art for Art's Sake - 10cc,I'm Mandy Fly Me - 10cc,An Englishman in New York - Godley & Creme
10,I'm Mandy Fly Me- 10cc,Life Is a Minestrone - 10cc,The Things We Do for Love - 10cc,Food for Trought - 10cc
11,The Things We Do for Love- 10cc,Good Morning Judge - 10cc,Good Morning Judge - 10cc,Rubber Bullets - 10cc
12,Good Morning Judge - 10cc,Bridge to Your Heart - Wax,People in Love - 10cc,Good Morning Judge - 10cc
13,Dreadlock Holiday - 10cc,Wedding Bells - Godley & Creme,Dreadlock Holiday - 10cc,Feel the Love - 10cc
14,People in Love - 10cc,Donna - 10cc,For You and I - 10cc,Memories - 10cc
15,Under Your Thumb - Godley & Creme,The Dean & I - 10cc,Cry - Godley & Creme,The Things We Do for Love - 10cc
16,Wedding Bells ,Ready to Go Home - 10cc,,Don't Turn Me Away - 10cc
17,Cry ,Silly Love - 10cc,,Cry - Godley & Creme
18,Neanderthal Man,Neanderthal Man - Hotlegs,,Silly Love - 10cc
19,, - ,,
20,,,,
click here for table formatted display
IE
TRACK#,version1,version2,
I intend to use the Albumartist & Albumname as per existing Musicbrainzed tags future editions will filter track# of sample track thus if the sample MP3 has tags of track#:1,title:donna, I will eventually show user (myself) only entries 1 & 3 above,
im guessing several xml web service requests per album would be the way to get this information
(1 to get list of albums by artist X with title Y), another for each result to get track titles ?? - what areas of the XML would I best query?
to summarize my plan would be eventually take tag input from a music library
display results in grid like above that match existing track(s) from album
IE
with input mask of <track#> - <AlbumArtist> - <trackname> - <albumname>
if the input is track# 1 - 10CC - Donna - very best of.I would see a grid containing 1 and 3 from above
if how ever I also had track# 15 - 10CC - Cry- very best of. the app would narrow results down to the 3rd entry above because thats the only album called very best of 10cc with track#1=Donna and track#15=Cry
then provide user with list boxes for each track# they don't have associated to an album named X by artist Y
IE if user has an album call "The Very Best of 10cc" with album artist: "10cc" missing track 1 the first list box would contain the following contents
- Donna -<information*>-filename**
- Donna -<information*>-filename2
- Dreadlock Holiday -<information*>-filename
- The Wall Street Shuffle -<information*>-filename
- The Wall Street Shuffle -<information*>-filename2
- The Wall Street Shuffle -<information*>-filename3
*where information is an as yet unidenified series of facts could be existing files album tags, remix info etc - its not important right now!
**one entry per existence of track in database (IE if you have 1 live, 1 studio release, and 2 remixes of 1 song off for albums the user can choose between versions
remember the aim is not to create an exact replica of the album just a compete tracklist if user later decides that the one they chose did not suit for example if they ended up placing a live song in the middle of a sudio album user would delete that entry and try again if it really bothered them.
what to do with users new arrangement of songs??
1) create playlists for each new "album like arrangement of tracklists"
2) since HDD space is not to scarce and HDDs are cheapish - perhaps you could simply create new folders for each album changing tags accordingly
thanks