The Traders' Den  

  The Traders' Den > Where we go to learn ..... > Technobabble
 

Notices

Technobabble Post your general Need for Help questions here.
Lossy or Lossless?
Moderators

Reply
 
Thread Tools
  #1  
Old 2007-03-06, 02:45 AM
Ritual
0.00 KB/0.00 KB/---
 
Icon4 How To Do A List Database?

I am trying to make a list of my recordings for the first time. How should I do it? Which software should I use? I would like it to be available via the web, so I'm concerned about using Excel or something that people might not have installed in order to read the list. What a good way to go about making a list/database?

- Ritual
Edit/Delete Message Reply With Quote Reply with Nested Quotes
  #2  
Old 2007-03-06, 06:26 AM
SRVRules's Avatar
SRVRules SRVRules is offline
Love Struck Baby
139.79 GB/210.15 GB/1.50
 
Join Date: Nov 2004
Location: Third Stone From The Sun
Re: How To Do A List Database?

Quote:
Originally Posted by Ritual
I am trying to make a list of my recordings for the first time. How should I do it? Which software should I use? I would like it to be available via the web, so I'm concerned about using Excel or something that people might not have installed in order to read the list. What a good way to go about making a list/database?

- Ritual
You might try db.etree.org and enter your shows there. You can export your list to Excel as backup from the website. Then you don't have to write and maintain a DB application.

If you do create a DB (say in MS Access), you can export from Access to Excel or to a text file with some of the reporting capabilities. The same is true for Excel--it has some reporting capabilities. The biggest difference is that you can normalize your data in a DB whereas in Excel, it's pretty much just a flat file.
Reply With Quote Reply with Nested Quotes
  #3  
Old 2007-03-06, 06:46 AM
AAR.oner's Avatar
AAR.oner AAR.oner is offline
TTD Staff
1.11 TB/1.41 TB/1.27
 
Join Date: Feb 2005
Location: Appalachia
Re: How To Do A List Database?

i use excel, works fine...you can always use the "save as web page" if you are worried about folks not being able to open an xls file [although there is great freeware out there for dealing with excel/database file ]
__________________
TTD's Gear Lust Forum -- info & reviews on taping gear
The Basics of EQing
Reply With Quote Reply with Nested Quotes
  #4  
Old 2007-03-06, 02:50 PM
direwolf-pgh's Avatar
direwolf-pgh direwolf-pgh is offline
On the Beach
666.18 GB/1.29 TB/1.99
 
Join Date: Dec 2005
Location: down in the basement
Re: How To Do A List Database?

.. this program has excellent reviews

http://www.codeaero.com/music-label/awards.htm

Quote:
Put a big stack in front of you and click Entries from the View Manager. Then click the CDDB FastScan button found at the top of the screen, select Default, and get ready to go assembly line. All pertinent information will be downloaded from the Net and stored as quickly as you can swap audio CDs out of your drive.

Last edited by direwolf-pgh; 2007-03-06 at 02:56 PM.
Reply With Quote Reply with Nested Quotes
  #5  
Old 2007-03-11, 01:29 PM
katnapz's Avatar
katnapz katnapz is offline
What'cha Got There?
208.73 GB/1.99 TB/9.77
 
Join Date: Nov 2004
Re: How To Do A List Database?

WhereIsIt.
Excellent program. Will automatically import all your data in from the disc (or harddrive) after you burn it off (if there's an info file/artwork...it'll pull it into your database). Great searching/filtering capabilites. Allows importing of thumbnails of artwork. Exports to a ton of formats, including html so you have a web page ready built. Plug-ins allow it to import the details on your files (such as what framerate a DVD is in so you can easily see whether you have a NTSC or PAL copy of that favorite show).
Plus, I keep separate databases for different formats (audio/video, whether it's a live or commercial release)....so this means I can combine them quickly for searching if need be.

Here's an old link from way back when I ranted and raved about it before: http://www.thetradersden.org/forums/...ead.php?t=2557

Also, as I mentioned in that old post, if you go to www.nonags.com, there are some freeware programs out there that will let you do a collection too. Look for "catalog." Haven't tried any myself but it's worth a shot for being free.

Here's a link to one of the DVD webpages I keep (BTW-sorry, but I'm really not currently looking to snail trade for personal workload reasons so please no requests....well, unless some special show was involved....or you're a beautiful girl who wants a new friend ....or you're Lynn, who "is" a beautiful girl with lots of special shows ). This page took me about....oh, I don't know....maybe two minutes to make??? Only thing I have to do every time I update it is pull it into Frontpage to make the frames white.
http://home.comcast.net/~musicavista/DVD.html
If I really wanted to be tidy I could clean up the comments from the info files that I've gotten with the shows, but I haven't felt up to it for awhile. I mainly use this for my own reference if I'm not at home.

Hope this (and my old post) helps you think of not only what you need NOW, but also for the future. One thing for me, if I would've used some common sense years back I would've DEFINATELY used a YYYY/MM/DD format, but it's too late for that now so I just live with what I've got until I win the lottery and have the time to redo from scratch.
Good luck-
__________________
...Catnip is my middle name...
Reply With Quote Reply with Nested Quotes
Reply

The Traders' Den > Where we go to learn ..... > Technobabble

Similar Threads
Thread Forum Replies Last Post
how about a list list? some sort of database? - chewie420 Site Announcements & Suggestions 4 2006-07-01 11:25 AM


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forums


All times are GMT -5. The time now is 03:30 PM.


Powered by: vBulletin, Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004 - , TheTradersDen.org - All Rights Reserved - Hosted at QuickPacket
no new posts