[AccessD] cataloguing mp3 albums

dave sharpe davesharpe2 at cox.net
Sat Sep 13 20:56:00 CDT 2003


Kathryn

I feel that it would be simple to do, but would be tedious to explain how.

If you'd post the complete list; I'll do it and return an mdb with the code
that I write to do it.

Dave


----- Original Message ----- 
From: "Kathryn Bassett" <kathryn at bassett.net>
To: "dbAdvisors (AccessD)" <accessd at databaseadvisors.com>
Sent: Saturday, September 13, 2003 9:37 PM
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