Kathryn Bassett
kathryn at bassett.net
Sat Sep 13 22:20:45 CDT 2003
Looks like a good program, but I don't have the albums on my computer and the program doesn't have a way to look at the mp4 player. I'm ripping direct to the player as I don't have room for 50+ cd's of music on computer. Thanks for the idea though, I can at least catalog the music that *is* on my computer. -- Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my bag" "GH is my soap" kathryn at bassett.net http://bassett.net > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of > Tortise at Paradise > Sent: 13 Sep 2003 8:02:PM > To: Access Developers discussion and problem solving > 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