Itunesdb file to text file

[DataStorm]

Hi!
    An ipod that I tried to backup/recover music from for a friend has been corrupted. There are errors on the disk and scndsk just shrugs at it. I ran a program to check the blocks and some are turning up red. The good news is that I seem to be able to read the list of songs and playlists on the ipod using copytrans. I would like to preserve the metadata content of the list in .csv file format. I'm thinking that this is contained in the itunesdb file, which I have access to. I've tried various ways to get at this file to no avail (http://www.joescafe.com/tunes2html/, and have exchanged emails with the copytrans tech support.) The file is 31mb. I've seen rewards in this thread start at .05 BTC, so I'll start there. 


Edit: here's the itunesdb file: http://ge.tt/6ROuhvE2

[amacar]

And of course we need your itunesdb file, so please enclose it.

[TheButterZone]

I tried to import it to a Google Docs spreadsheet, it says "Too large to import. Remove rows or columns and try again." no matter what settings I try.
LibreOffice just freezes when I try to add it to a sheet with tab and semicolon as delimiters.

[DataStorm]

Yarr, I've tried opening in notepad. That works, but the format is somewhat gibberish. You could try opening in notepad then changing to save as utf-8 or some other text type, then libreoffice or google docs.

edit: it sounds like the carriage return isn't being picked up. I'm uncertain what the return character is.

[person]

What information are you trying to have in the CSV? Which iTunes fields?

Lot's of AC/DC, Aerosmith, Alanis, Alicia Keys...etc in there

[DataStorm]

Yarr, don't forget Phil Collins, that's one of his favorites. Anyways, more is better. I'd like to have as many fields as possible so that I wouldn't have to ask later for something that is missing. Having album name, artist, song name, year, would be at the top of the list.

[person]

Ok - so that will be a lot of work for $10 bucks. What about 0.25 BTC?

[DataStorm]

I'll push it up to .08 if that will make you happy. This is the first day the thread has been up and there are already hits. Getting more columns isn't any different than just a few, there's a delimiter and a carriage return, and some format that the file is in. Naming the columns may take more time if it isn't in the file, but if you're pressed for time I can figure the names out. I'm not in any rush to get this work done, either. 

[person]

Oh well - took it for the challenge.

I'll push it up to .08 if that will make you happy. This is the first day the thread has been up and there are already hits. Getting more columns isn't any different than just a few, there's a delimiter and a carriage return, and some format that the file is in. Naming the columns may take more time if it isn't in the file, but if you're pressed for time I can figure the names out. I'm not in any rush to get this work done, either. 

For 0.08 BTC I'll give you the full list of songs considering the following fields (see sample):

Code:

song,artist,album,genre,composer,track,totalTracks,year,bitrate,samplerate,disc,totalDiscs,BPM,mediaType
"We Need A Resolution","Aaliyah","Aaliyah","R&B","S. Garrett/Tim Mosley",1,0,2001,64,22050,0,0,0,1
"Loose Rap","Aaliyah","Aaliyah","R&B","E. Seats/R. Stewart/S. Garrett",2,0,2001,64,22050,0,0,0,1
"You Got Nerve","Aaliyah","Aaliyah Unreleased","R&B","B. Bush/E. Seats/R. Stewart",9,0,2001,192,44100,0,0,0,1
"Rock Da Boat","Aaliyah","MTV Party Beatz 2002","R&B","E. Seats/R. Stewart/S. Garrett",10,0,2002,160,44100,0,0,0,1
"Rock the boat","Aaliyah","TMF Hitzone 19","Pop","",14,0,2002,192,44100,0,0,0,1
"If Your Girl Only Knew","Aaliyah","Unreleased","R&B","",3,0,2001,128,44100,0,0,0,1
"Where The Stars And Stripes And The Eagle Fly","Aaron Tippin","Stars & Stripes","Country","",1,11,2002,124,44100,1,1,0,1
"I'll Take Love Over Money","Aaron Tippin","Stars & Stripes","Country","",2,11,2002,125,44100,1,1,0,1
"I Believed","Aaron Tippin","Stars & Stripes","Country","",3,11,2002,125,44100,1,1,0,1
"Honky Tonk If You Love Country","Aaron Tippin","Stars & Stripes","Country","",4,11,2002,125,44100,1,1,0,1
"If Her Lovin' Don't Kill Me","Aaron Tippin","Stars & Stripes","Country","",5,11,2002,126,44100,1,1,0,1
"Love Like There's No Tomorrow","Aaron Tippin","Stars & Stripes","Country","",6,11,2002,125,44100,1,1,0,1
"At The End Of The Day","Aaron Tippin","Stars & Stripes","Country","",7,11,2002,124,44100,1,1,0,1
"We Can't Get Any Higher Than This","Aaron Tippin","Stars & Stripes","Country","",8,11,2002,126,44100,1,1,0,1
"Five Gallon Tear","Aaron Tippin","Stars & Stripes","Country","",9,11,2002,125,44100,1,1,0,1
"This Old Couch","Aaron Tippin","Stars & Stripes","Country","",10,11,2002,124,44100,1,1,0,1
"Love Me Back","Aaron Tippin","Stars & Stripes","Country","",11,11,2002,124,44100,1,1,0,1
"City Of Angels","Above The Law Feat. Frost","The Crow: City Of Angels","Crow: City Of Angels","Frost, Gilbert Ruedaflores, Julio Gonzalez, ony Gonzalez, Kevin Gully",15,15,1996,128,44100,1,1,0,1
"Give The Dog A Bone","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"Have A Drink On Me","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"Let Me Put My Love Into You","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"Rock And Roll Ain't Noise Poll","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"Shake A Leg","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"Shoot To Thrill","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"What Do You Do For Money Honey","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"You Shook Me All Night Long","AC","DC / DC / Back In Black","Pop","",0,0,2001,128,44100,0,0,0,1
"Hells Bells","AC/DC","Back In Black","Rock","",1,0,0,128,44100,0,0,0,1
"Shoot To Thrill","AC/DC","Back In Black","Rock","",2,10,1980,129,44100,1,1,192,1
"What Do You Do For Money Honey","AC/DC","Back In Black","Rock","",3,10,1980,130,44100,1,1,192,1
"Givin' The Dog A Bone","AC/DC","Back In Black","Rock","",4,10,1980,126,44100,1,1,192,1
"Let Me Put My Love Into You","AC/DC","Back In Black","Rock","",5,10,1980,128,44100,1,1,192,1
"Back In Black","AC/DC","Back In Black","Rock","",6,0,0,128,44100,0,0,0,1
"Back In Black","AC/DC","Back In Black","Rock","",6,10,1980,129,44100,1,1,192,1
"You Shook Me All Night Long","AC/DC","Back In Black","Rock","",7,10,1980,130,44100,1,1,192,1
"Have A Drink On Me","AC/DC","Back In Black","Rock","",8,10,1980,128,44100,1,1,192,1
"Shake A Leg","AC/DC","Back In Black","Rock","",9,10,1980,127,44100,1,1,192,1
"Rock And Roll Ain't Noise Pollution","AC/DC","Back In Black","Rock","",10,10,1980,127,44100,1,1,192,1
"Dirty Deeds Done Dirt Cheap","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",0,0,2001,128,44100,0,0,0,1
"Love At First Feel","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",0,0,2001,128,44100,0,0,0,1
"Problem Child","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",0,0,2001,128,44100,0,0,0,1
"Ride On","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",0,0,2001,128,44100,0,0,0,1
"Squealer","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",0,0,2001,128,44100,0,0,0,1
"There's Gonna Be Some Rockin'","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",0,0,2001,128,44100,0,0,0,1
"Dirty Deeds Done Dirt Cheap","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",1,9,1976,124,44100,1,1,0,1
"Love At First Feel","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",2,9,1976,124,44100,1,1,0,1
"Big Balls","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",3,9,1976,123,44100,1,1,0,1
"Rocker","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",4,9,1976,124,44100,1,1,0,1
"Problem Child","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",5,9,1976,125,44100,1,1,0,1
"There's Gonna Be Some Rockin'","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",6,9,1976,123,44100,1,1,0,1
"Ain't No Fun (Waiting Round To Be A Millionaire)","AC/DC","Dirty Deeds Done Dirt Cheap","Rock","",7,0,0,128,44100,0,0,0,1

Is that what you are looking for?
 
As soon as you transfer the 0.08 BTC, I can send you the entire list (over 20 thousand songs): 1Gu4VpCjQJRKziZ6Ur3oVTQNFLQTnpNGYh

[person]

Someone paid
So here is the link: http://ge.tt/51xKYxE2/v/0?c

[DataStorm]

Yep, I sent & downloaded the file. Thanks! I may post a question if something comes up, but you need not feel obligated to answer. I do appreciate the work!