jb wrote:
> I'm in the hunt for a computer program that would enable the user to archive
> and retrieve data about a large record collection. For instance, if you
> wanted to know every record (or individual cut) you owned on which Doc
> Roberts played, you could retrieve the info. Likewise, if you wanted to know
> how many recordings you had of Hawk's Got a Chicken, the program could pull
> it up. Has anyone out there in old time land been down this road?
To date, the best data base I know of is at:
http://milton.mse.jhu.edu:8001/research/folkindex/index.html
for you Doc Roberts example the site lists"
Roberts, Fiddlin' Doc
Appearance as principal performer
1.All I('ve) Got's Done Gone, Old Time Tunes, County 412 (), cut # 1
2.And the Cat Came Back, Fiddle Band Music from Kentucky, Vol.3, Wish I
Had ..., MorningStar 45005 (1980), cut # 13
3.Billy in the Lowground, Classic Fiddle Tunes, Davis Unlimited DU 33015
(197?), cut # 3
4.Black-Eyed Susie (Susan), Classic Fiddle Tunes, Davis Unlimited DU
33015 (197?), cut # 7
5.Brickyard Joe, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?),
cut # 1
6.Brickyard Joe, Fiddle Band Music from Kentucky, Vol.2, MorningStar
45004 (1980), cut # 3
7.Charleston #1, Old Time Tunes, County 412 (), cut # 6
8.Cripple Creek, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?),
cut # 13
9.Cumberland Blues, Old Time Tunes, County 412 (), cut # 3
10.Cumberland Blues, Mountain Blues, County 511 (), cut # 11
11.Cumberland Blues, Classic Fiddle Tunes, Davis Unlimited DU 33015
(197?), cut # 6
12.Deer Walk, Old Time Tunes, County 412 (), cut # 2
13.Devil in Georgia, Old Time Tunes, County 412 (), cut # 13
14.Drunken Man's Dream, Old Time Tunes, County 412 (), cut # 9
15.Farewell Waltz, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?),
cut # 4
16.Hawk's Got a Chicken (and Gone), Old Time Tunes, County 412 (), cut #
11
17.Hog Trough Reel, Visits, Heritage (Galax) 033 (1981), cut # 4b
18.I Don't Love ('a) Nobody, Old Time Tunes, County 412 (), cut # 4
19.I Don't Love ('a) Nobody, Classic Fiddle Tunes, Davis Unlimited DU
33015 (197?), cut # 10
20.Jack's Creek Waltz, Old Time Tunes, County 412 (), cut # 12
21.Martha Campbell, Old Time Tunes, County 412 (), cut # 10
22.Martha Campbell, Visits, Heritage (Galax) 033 (1981), cut # 4a
23.Miss McCleod's Reel, Classic Fiddle Tunes, Davis Unlimited DU 33015
(197?), cut # 5
24.New Money, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?), cut
# 2
25.New Money, Fiddle Band Music from Kentucky, Vol.3, Wish I Had ...,
MorningStar 45005 (1980), cut # 2
26.Old Buzzard, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?),
cut
# 8
27.Old Buzzard, Fiddle Band Music from Kentucky, Vol.2, MorningStar
45004 (1980), cut # 11
28.Rocky Mountain Goat, Old Time Tunes, County 412 (), cut # 5
29.Run, Boy, Run, Old Time Tunes, County 412 (), cut # 8
30.Run, Boy, Run, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?),
cut # 11
31.Rye Straw, Old Time Tunes, County 412 (), cut # 7
32.Rye Straw, Old Time Fiddle Classics, Vol. 2, County 527 (1973), cut #
8
33.Sally Ann, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?), cut
# 9
34.Shortenin' Bread, Kentucky Country; Old Time Music From Kentucky,
Rounder 1037 (1983), cut # 15
35.Take Those Lips Away, Early Mandolin Classics, Rounder 1050 (1989),
cut # 4
36.Waynesboro, Classic Fiddle Tunes, Davis Unlimited DU 33015 (197?), cut
# 14
37.Way Down South, Old Time Tunes, County 412 (), cut # 14
38.Way Down South in Dixie, Fiddle Band Music from Kentucky, Vol.3, Wish
I Had ..., MorningStar 45005 (1980), cut # 6
39.Wednesday Night Waltz, Classic Fiddle Tunes, Davis Unlimited DU 33015
(197?), cut # 12
If you want to make one for your own collection, Microsoft Excel would work, in
that you can sort by different columns so that you can rearrange your data base
by performer, tune, record label, etc.
Carl
> I'm in the hunt for a computer program that would enable the user to archive
> and retrieve data about a large record collection. >>
Carl Baron suggested Excel. Good choice.
If you are running a MAC - FileMAker Pro is excellent. (I think it's also
available for PC - but not sure.)
Has a great graphic interface - that you can easily customize for your
particular needs. (You could even include a scan of each cover art.)
Can be as simple or complex as you like.
Version 5.0 has direct import/export to Excel.
Ed Britt
Please Remove *UNSPAM* from my address, to e-mail me.
My husband, Ron Cole, started this project years ago and has it in a very
"low-tech" way on a WordPerfect database. He has most of his tapes of 78s
archived and much of his other stuff, too. However, he was working on it
last night.... I guess as he gets more stuff, he has to keep archiving.
It is very handy, gotta admit!
Nancy
>I made a data base for my recordings. as Carl suggests, I used Excell. Early on I
>hit the limit on the number of rows allowed in Excell. I think that the limit has
>since been increased, but I converted the information to Acess. It works well. It
>would take a lot of time to enter the entire collection, but adding each rocording
>one at a time takes only a few minutes. If you decide to build your own, send me a
>message and I'll point out some things to avoid.
I go back a long way with my musical catalog. It was originally kept
in a flat file manger called "Nutshell" that was back in 1984. I
changed to Access approximately in 1990.
I have about 8000+ LP's, cassettes and CD's spread over a huge musical
category. There are about 100,000 tracks. I also like old time radio
musical shows and have over a thousand of these. When I decided to
make the DB change I looked at everything that was out there in the
canned category. Very quickly each and every one was eliminated for
one reason or another. Most I just did not like having to go along
with what the author thought important to include and those things he
thought were not important.
I am not a programmer but Access was really very easy to setup. The
most important consideration IMO is how you set up the fields as many
as possible. This makes searching very easy and very quick even with a
large catalog.
I have one large unlimited size field which I classify remarks. This
contains anything from side information to reviews about that
particular release. The track catalog has a similar field where the
musicians, backups are listed. All searchable.
Over the years the catalog structure has evolved by adding several
fields that were not there originally. I use Access to also generate a
MS Word document which becomes my traveling catalog. The printout of
that is about 400+ pages. It has helped me many times not too
duplicate something I already have.
The only thing I could add to the other remarks made by several
people. Is do BACKUPS. <grin> For me I could never re-enter all the
information again so backups are mandatory.
***** PLEASE NOTE *****
Anti--Spam Address In Effect
Please Reply Only To Newsgroup
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Brittles wrote:
>
> Carl Baron suggested Excel. Good choice.
Just my opinion, mind you... Excel is a spreadsheet program.
Access is a relational database program. My preferences would be
to go with a relational database, as you can query the data
in many more ways rather than having to sort and resort the
spreadsheet. In this case, and with many other brands of these
applications, the data is transportable from one type of app.
to the other. Excel data is easily ported to Access and vice-versa
and most have conversion utilities to use material from other
brands.
a spreadsheet seems to be easier for some people to enter
data than many relational data bases, though the data base
data entry screens often look like spreadsheets.
Yes, I have some data stored in spreadsheets, because I was
too lazy to create a data base for it and the size of the
data was small enough to not matter. I've also been too busy
and too lazy to put all my stuff into a data base. The data
entry is too daunting for me. And it is what I do all day
at work... the last thing I want to do when I come home.
I think I need an intern...
kerry
--
Blec...@WolfeNet.com
"When you get above the clouds, you can do just as you choose."
- The Rector Trio, Asheville, NC 1930
Wait a minute, Nancy. WordPerfect is a word processing application.
Does it have a data base function built in? (I'm unfamiliar with
WP). Or is it merely vast lists of entries, something that you
can sort or use a "find" function to locate particular items?
Just curious.
At any rate, he can search and retrieve, and probably sort...
Nancy
"Jack Aldrich" <john.w....@boeing.com> wrote in message
news:39B67155...@boeing.com...
Jack Aldrich wrote:
>
> I had the package on my Amiga 1000,
Way cool!
A guy at work this morning asserted that Access
was not a "real" data base management system. So
it's probably a whole lot cheaper than what he
was envisioning.
I would guess that FileMaker Pro is in
the same class as Access. And I think
FileMaker Pro is available for both Mac's
and Windows. Don't know what the UNIX guys
are going to do.
"bill blevins" <io...@mailcity.com> wrote:
> Robert Palasek> <bobpa...@home.com> wrote:
> > Jack Aldrich wrote:
> > >
> > > I had the package on my Amiga 1000,
> > Way cool!
> Real old-timer!!
He is... oh...um ... *that* is... and he probably wrote the
package in machine code. 00000100 10100011 etc.
Kerry
--
Blech Family (Kerry, Sheila, Mirabelle & Louise)
Blec...@WolfeNet.com www.wolfenet.com/~blechfam
"The Old Tunes Are the Best Tunes" -- Luther Davis
"Blech Family (Kerry & Sheila)" wrote:
> "bill blevins" <io...@mailcity.com> wrote:
> > Robert Palasek> <bobpa...@home.com> wrote:
> > > Jack Aldrich wrote:
> > > >
> > > > I had the package on my Amiga 1000,
> > > Way cool!
> > Real old-timer!!
>
> He is... oh...um ... *that* is... and he probably wrote the
> package in machine code. 00000100 10100011 etc.
He had zeros? Back in my day, we only had 1's.