[AccessD] cataloguing mp3 albums

Dan Waters dwaters at usinternet.com
Sun Sep 14 12:01:16 CDT 2003


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




More information about the AccessD mailing list