[AccessD] cataloguing mp3 albums

MartyConnelly martyconnelly at shaw.ca
Sun Sep 14 22:11:23 CDT 2003


On the newer Audio CD's there are text files that you can read directly 
for track name and length.
There are freeware and shareware programs that will catalog from this info.

Dan Waters wrote:

>Kathryn,
>
>You might want to look at a program called CD Trustee.  It's pretty slick at
>reading CD's, recording tracks, and other stuff.  Also, it uses an access db
>so if you want to do extra stuff of your own you can.  I think it's about
>$20.
>
>Dan Waters
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
>Sent: Saturday, September 13, 2003 7: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
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>




More information about the AccessD mailing list