SUSE 10

1kyle · 04-18-2006, 06:02 AM

Hi everybody -- I need to get a script which can retrieve data from a CD using Freedb.

I DON'T WANT RIPPING software. I simply want to be able to insert the CD into the drive, access FREEDB and then save the Track / album info as Text or in a spreadsheet.

All the software I can see involves Ripping the CD and storing music tracks on the computer. Also this type of software doesn't seem to have any way of extracting the track info to a text / spreadsheet file.

I'm sure someone has got some type of script to do this.

Thanks

-K

rickh · 04-18-2006, 06:41 AM

I use mp3report to extract that info. I don't use the id3 tag info tho, so you'd have to check out the man page to get the exact information for that. This is my little note to myself for remembering syntax for my needs.

First you set up a template for the info you want extracted following the instructions in the docs, then:

Code:

mp3report --template=./mp3rpt_template.html --outfile=marchive.html ./MP3Archives/

That produces an HTML formatted report of which the 'body' includes the spreadsheet information I want. I copy that 'body' of marchive.html to archive.txt, then...

Code:

sed -e 's/ - /|/' -e 's/\.\/MP3Archives\/Archive//' -e 's/\.\/MP3Archives\/MP3SeriousMusic/SM/' -e 's/\.mp3//g' archive.txt > mp3.txt

That section writes the info to a delimited file that can be imported into gnumeric or calc or whatever spreadsheet you like.

This is not pulling information from freedb ... only from the mp3 file and it's id3 tags.