PhreeZone 20 #1 October 18, 2002 Does anyone use any type of indexing database software to catalog the video on their tapes? I've used Excel and stuff, but would perfer a database driven app. I'll write one my self if nothing else but figured if I can save a step or two...Yesterday is history And tomorrow is a mystery Parachutemanuals.com Quote Share this post Link to post Share on other sites
diverds 0 #2 October 18, 2002 I can email you a copy of the access database I use if you want. Just send me an email. You will have to change the names in and locations in the drop down windows to suit your needs. I enter all the information into the database using the "forms" view. Check all the boxes that apply to your jump (freefly, tandem, rw, etc) and then you will be able to filter later to find certain types of jumps. You will also be able to search by date or any other field in the database. Works real well for me. I never tape over anything except tandems, so I have a lot of tape and this helps me keep it straight. Skydive Radio Quote Share this post Link to post Share on other sites
nacmacfeegle 0 #3 October 18, 2002 I don't have limitless disc space, so when I'm building a movie I do it the old fashioned way... Logging with a bit of paper and a pen. It works.....Seldom crashes, doesn't take up any Pc resources, and the slow and boring bit of editing..capturing.. is done as fast as possible. I've used this system on several big way events to keep track of video from as many as 14 camera fliers, and its useful when it comes to building the final movie. If you stash the captured clips in logical places, eg named directories such as jump #, exits, faces, plane shots, ground shots, etc etc etc, the process of building the movie becomes relatively simple. Once the movie is built, rendered, titled, backed up to tape etc I clean the system out ready for the next one. This is where the paper based system works well because you have a catalogue of your tapes, as oppsed to file locations which are only temporary. Stills titles, graphics etc are all backed up to CD rom.-------------------- He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me. Thomas Jefferson Quote Share this post Link to post Share on other sites
ernokaikkonen 0 #4 October 18, 2002 >I don't have limitless disc space, so when I'm building a movie I >do it the old fashioned way... I think he was referring to a some kind of archiving solution, so that you wont end up with a pile of 56 unlabeled 60-minute miniDVs... A database that would include just the information on the contents of all the tapes, not the data itself. Something like that would be a lot of help if you have a situation where you remember 'I have just the clip to insert here, it was that 3-way sitfly jump that's probably somewhere on one of those three tapes labeled "summer-2001". Damn.' With a database, you could just look up "sitfly, 3-way, 2001", and end up with tape numbers and time-codes that have matching material. Of course it'd be no use if you wont bother entering the data to the database... Or then again I could be completely off here and I could shut my mouth which knows next to nothing about video stuff... Quote Share this post Link to post Share on other sites
AggieDave 6 #5 October 18, 2002 That'd be a quick write to do with ASP/SQL, put it up on your server, then you can hit it anywhere.--"When I die, may I be surrounded by scattered chrome and burning gasoline." Quote Share this post Link to post Share on other sites
nacmacfeegle 0 #6 October 18, 2002 "so that you wont end up with a pile of 56 unlabeled 60-minute miniDVs" I should be so lucky, I came back from one event in 99 with over 60 hours of video......But because we logged it at the time, there really was no point in 'double dipping' on the logging thing. Id teh clip is outstanding, I'll generally back it up to a 'good stuff archive tape' otherwise, it just gets sealed up, and stashed somewhere safe. In skydiving I'd estimate 'good stuff' represent less than 10% of the footage....-------------------- He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me. Thomas Jefferson Quote Share this post Link to post Share on other sites
diverds 0 #7 October 21, 2002 QuoteWith a database, you could just look up "sitfly, 3-way, 2001", and end up with tape numbers and time-codes that have matching material. This is exactly what I have with the access database I was refering too above. If any of you would like a copy of it just drop me an email. It is about 550K which is over the limit for attachments here. Skydive Radio Quote Share this post Link to post Share on other sites
