[AccessD] cataloguing mp3 albums

If you know how to get the MP3 info out of the file and you're running
windows 2000, I have another suggestion for you.  You could make a
service/program that would automatically import the MP3 data into your
database as soon as an MP3 file is changed or added to your hard drive.

Drew

-----Original Message-----
From: Kathryn Bassett [mailto:kathryn at bassett.net]
Sent: Saturday, September 13, 2003 8:38 PM
To: dbAdvisors (AccessD)
Subject: [AccessD] cataloguing mp3 albums


Got one that I haven't a clue about trying to convert. I've got a text
report (about 50 albums of varying numbers of tracks) Sorry for length of
message but I wanted to put in several to show you the general patterns of
the data.

Now, what I want is to have a query (or series of queries) put this into
Access as a database. It only has to be done once, one I'm finished ripping
all my CDs, as any new ones I don't mind entering by hand. I want to be able
to print a report that would be in order similar to below, plus a report in
order by title of the track, with what album it is on and the track number,
and lastly, by the artist, sub-ordered by track then album, also album then
track. I feel confident I can do the queries and reports, but need one of
you to help me with turning the text to tables. I do notice that I've got
some natural breaks, to break the components apart - the period for the
track number, the first - is the split between song title and the artist,
and the ( ) for the time track (which I do want). Note that Simon and
Garfunkel have a second - that might cause a problem, but when I've got the
final text file, I can eliminate those easily before doing the conversion.

So, any volunteers to help?

Album : 18 Original Greatest Hits
01. All Night Long - Jerry Lee Lewis (00:02:04)
02. Big Blon' Baby - Jerry Lee Lewis (00:01:41)
03. Big Legged Woman - Jerry Lee Lewis (00:02:25)
04. Breathless - Jerry Lee Lewis (00:02:43)
05. Crazy Arms - Jerry Lee Lewis (00:02:44)
06. Drinkin' Wine Spo-Dee-O-Dee - Jerry Lee Lewis (00:02:35)
07. Great Balls Of Fire - Jerry Lee Lewis (00:01:52)
08. High School Confidential - Jerry Lee Lewis (00:02:30)
09. It'll Be Me - Jerry Lee Lewis (00:02:46)
10. Jambalaya - Jerry Lee Lewis (00:02:00)
11. Lewis Boogie - Jerry Lee Lewis (00:01:58)
12. Matchbox - Jerry Lee Lewis (00:01:43)
13. Put Me Down - Jerry Lee Lewis (00:02:08)
14. Ubangi Stomp - Jerry Lee Lewis (00:01:46)
15. What'd I Say - Jerry Lee Lewis (00:02:27)
16. When The Saints Go Marching' In - Jerry Lee Lewis (00:02:09)
17. Whole Lot Of Shakin' Goin' On - Jerry Lee Lewis (00:02:53)
18. Wild One - Jerry Lee Lewis (00:01:48)

Album : Biggest Hits
01. 11 Months And 29 Days - Johnny Paycheck (00:03:28)
02. Colorado Cool-Aid - Johnny Paycheck (00:02:57)
03. Drinkin' And Drivin' - Johnny Paycheck (00:03:37)
04. Fifteen Beers - Johnny Paycheck (00:03:25)
05. Friend, Lover, Wife - Johnny Paycheck (00:05:04)
06. I Can'T Hold Myself In Line (With Merle Haggard) - Johnny Paycheck
(00:03:05)
07. She'S All I Got - Johnny Paycheck (00:02:42)
08. Take This Job And Shove It - Johnny Paycheck (00:03:47)
09. The Outlaw'S Prayer - Johnny Paycheck (00:03:08)
10. Yesterday'S News Just Hit Home Today - Johnny Paycheck (00:02:36)

Album : Gershwin : Rhapsody - Tilson Thomas
01. An American In Paris - George Gershwin (00:18:37)
02. Funny Face - George Gershwin (00:05:54)
03. Girl Crazy - George Gershwin (00:05:45)
04. Let 'Em Eat Cake - George Gershwin (00:08:18)
05. Of Thee I Sing - George Gershwin (00:04:40)
06. Oh, Kay - George Gershwin (00:07:11)
07. Rhapsody In Blue - George Gershwin (00:13:46)
08. Strike Up The Band - George Gershwin (00:07:11)

Album : Messiah Highlights
01. And The Glory Of The Lord - London Philharmonic Orchestra And Chorus
(00:03:11)
02. Comfort Ye My People - London Philharmonic Orchestra And Chorus
(00:07:42)
03. For Unto Us A Child Is Born - London Philharmonic Orchestra And Chorus
(00:04:11)
04. Hallelujah! - London Philharmonic Orchestra And Chorus (00:04:15)
05. I Know That My Redeemer Liveth - London Philharmonic Orchestra And
Chorus (00:07:28)
06. Overture - London Philharmonic Orchestra And Chorus (00:03:21)
07. Pastoral Symphony - London Philharmonic Orchestra And Chorus (00:03:06)
08. Worthy Is The Lamb - London Philharmonic Orchestra And Chorus (00:07:04)

Album : The Concert In Central Park
01. 59th Street Bridge Song (Feelin' Groovy) - Paul Simon - Art Garfunkel
(00:04:09)
02. America - Paul Simon - Art Garfunkel (00:05:50)
03. American Tune - Paul Simon - Art Garfunkel (00:04:13)
04. April Come She Will - Paul Simon - Art Garfunkel (00:06:02)
05. Boxer - Paul Simon - Art Garfunkel (00:03:55)
06. Bridge Over Troubled Water - Paul Simon - Art Garfunkel (00:02:37)
07. Fifty Ways To Leave Your Lover - Paul Simon - Art Garfunkel (00:02:19)
08. Heart In New York - Paul Simon - Art Garfunkel (00:03:22)
09. Homeward Bound - Paul Simon - Art Garfunkel (00:02:49)
10. Kodachrome/Maybellene - Paul Simon - Art Garfunkel (00:03:52)
11. Late In The Evening - Paul Simon - Art Garfunkel (00:04:22)
12. Me And Julio Down By The Schoolyard - Paul Simon - Art Garfunkel
(00:04:48)
13. Mrs. Robinson - Paul Simon - Art Garfunkel (00:03:52)
14. Old Friends - Paul Simon - Art Garfunkel (00:04:33)
15. Scarborough Fair - Paul Simon - Art Garfunkel (00:04:23)
16. Slip Slidin' Away - Paul Simon - Art Garfunkel (00:04:56)
17. Sound Of Silence - Paul Simon - Art Garfunkel (00:04:54)
18. Still Crazy After All These Years - Paul Simon - Art Garfunkel
(00:02:01)
19. Wake Up Little Susie - Paul Simon - Art Garfunkel (00:02:52)


--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net  

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com