PDA

View Full Version : scan music and produce a word (ish) file



g7pkf
2005-12-28, 04:13
I have a bit of music now, back up to 4Gb (did have 112Gb but HDD died) what i would like to know is is there a way or program that will scan my music libary and produce a word/csv/excel document of what music artist songtitle etc i have?


cheer's

the easier the better

mikeb
2005-12-28, 13:03
I'm sure some of that MS junk can make use of comma separated files.

Use sqlite to dump your database into such a format and import it.

Or use MP3::Info and write something in perl to read the actual files.

-- Mike

g7pkf wrote:
> I have a bit of music now, back up to 4Gb (did have 112Gb but HDD died)
> what i would like to know is is there a way or program that will scan
> my music libary and produce a word/csv/excel document of what music
> artist songtitle etc i have?
>
>
> cheer's
>
> the easier the better
>
>

g7pkf
2005-12-29, 06:12
Now i have no idea where to start to find the sqlite database but will have a go if anyone has done it a few pointers would be helpfull. (i use a nix box running cent os)

as for programming and pearl-the last programming i did was in assembler for a Z80 so i dont think i will go back to programming after all these years.

Maditude
2005-12-29, 09:53
> Now i have no idea where to start to find the sqlite database but
> will have a go if anyone has done it a few pointers would be
> helpfull. (i use a nix box running cent os)

Never heard of that one... If you can find an sqlite (version 3) package for your OS, install that. Once you've done so, here's a script to retrieve a simple list of artist/album/song-title/genre:

.mode html
select c.name, a.title, t.title, g.name
from albums a, tracks t, genres g, genre_track gt, contributors c
where t.age > 0
and a.id = t.album
and g.id = gt.genre
and t.id = gt.track
and c.id = a.contributor
order by 1,2;

(I'm actually building this query in a shell-script, and using the 'age' column a bit differently, but if you want everything, the above works)

With the .mode option, you can specify: csv, column, html, insert, line, list, tabs, tcl.