[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