No database, these are audio files.
<L>
Lou Judson
Intuitive Audio
415-883-2689

On Jan 10, 2018, at 3:33 PM, Matthew Sohn <[log in to unmask]> wrote:

> Lou, What software are you using for your database?If you use Access, you can create a relational database which connects together individual tables of records. Assign a control number to each tape and create tables for different aspects of the recording. You can then create search queries that pull the data you want from each database and create reports customized however you choose.The trick is to design the database so that it is as flexible as possible.Here's a link to a basic description of Access:https://www.youtube.com/watch?v=WGXYjBC8hGI -Matt Sohn 
> 
>    On Wednesday, January 10, 2018 3:36 PM, Mickey Clark <[log in to unmask]> wrote:
> 
> 
> The filing system needs to be consistent and logical. I use a terabyte hard 
> drive to store my 'working files' i.e. - if I have existing work by an 
> artist, it then has a SKU number. I use that number E:\Working\016 Amelita 
> Galli-Curci . If it is not in a current or past project I would store in 
> E:\Working\Opera\Soprano\Galli-Curci Amelita\ then the audio.    If I have 
> done a final edit with my current Hi-def process I add a code (HD) to know 
> that I can use that audio at any time and know that it is ready to go.  Caro 
> Nome-ELECTRIC-HD would then tell me that it is not the acoustical version. I 
> also use take numbers in the title.
> 
> E:\Working\Classical Instrumental\Piano\Samaroff Olga      keeps reliance on 
> my memory to a minimum.
> 
> Sometimes these files sit for years until I use them so the codes remove 
> second-guessing . - Mickey Clark
> 
> 
> Mickey Clark
> 710 Westminster Avenue West
> Penticton BC
> Canada
> 250-462-7881
> V2A 1K8
> http://mcproductions.ca
> 1-250-462-7881
> 
> -----Original Message----- 
> From: Lou Judson
> Sent: Wednesday, January 10, 2018 9:12 AM
> To: [log in to unmask]
> Subject: Re: [ARSCLIST] Archiving audio help.
> 
> Hi all ARSC-listers. I am on this list as part of my work is transferring 
> audio tapes for occasional clients. I am not an archvist or a library 
> person. I’ve been an audio engineer for over 50 years in various capacities.
> 
> Since 1973 I have been engineer for a radio nonprofit that does interviews 
> for public radio (and now podcasts which is “the new radio”). I post-produce 
> an hour-long program each week, and restore from tapes our old programs for 
> continuing distribution. The interviews are good and document the progress 
> of the cultural institutions known as the consciousness movement, science 
> and social changes here in California. We consider them documentary material 
> of a niche of humanity in the process of discovering itself.
> 
> One of our team has taken it upon himself to be the archivist and manager of 
> the library of thousands of hours of programs. He is a brilliant person, 
> perhaps too much so, and keeps devising various ways of organizing the audio 
> archives so they can be preserved and accessed for “retail” and podcast 
> distribution. He has found many ways to origanize it, and keeps changing it 
> according to his latest bright idea. I get confused trying to keep up with 
> the latest scheme and file organization. We keep adding material from tapes 
> that has never been digital before. We have abnout 1500 hours now and there 
> may be 3 to 4 thousand hours in toto.
> 
> Many of you are professionals at this, and I know there must be standardized 
> methods of organizing audio files that don’t need to be reinvented 
> constantly!
> 
> How can I find out what these methods are, and suggest to him how to keep 
> the audio archives we have organized and accessible to future generations? 
> We are both around 70 and going to school for library science is not an 
> option. Online links would be fine, and/or personal knowledge from some of 
> you would be valuable!
> 
> Thanks for any pointers and suggestions!
> 
> <L>
> Lou Judson
> Intuitive Audio
> 415-883-2689 
> 
> 
> 
>