[AccessD] cataloguing mp3 albums

...what does this do that WinXP's Media Player won't?

William Hindman
So, then, to every man his chance -- to every man, regardless of his birth,
his shining golden opportunity -- to every man his right to live, to work,
to be himself, to become whatever his manhood and his vision can combine to
make him -- this, seeker, is the promise of America.
-- Thomas Wolfe



----- Original Message ----- 
From: "Tortise at Paradise" <tortise at paradise.net.nz>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, September 13, 2003 11:01 PM
Subject: Re: [AccessD] cataloguing mp3 albums


> Try Chequers Softwares "MP3Detective" at
http://www.cheqsoft.com/mp3detective.html you may find you don't even need
to write the
> database.....
> Feedback welcomed.
> Kind regards,
> David Hingston
> _________________________________________________________________________
>
> Engines2Go - Now THAT's a Search Engine!
> Automated major search engine manager
> Makes searching quicker and easier - Have you tried it?
> http://www.engines2go.com/
> http://www.cheqsoft.com/  The home of Clipboard Express, MP3 Detective,
TimesOwn and Break Reminder.
>
> ----- Original Message -----
> From: "Kathryn Bassett" <kathryn at bassett.net>
> To: "dbAdvisors (AccessD)" <accessd at databaseadvisors.com>
> Sent: Sunday, September 14, 2003 1: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
>
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>