Media Manager as SQL Tape Mnger/Archavist?!??

Grazie wrote on 6/2/2005, 11:57 PM
How about that then?

As we have a relational database - in the sleek Media Manager - how could I use it to perfom my intricate physical tape-logging? Could we, maybe, use Advance Capture to LOG in the relational way the MM provides? This would be a total boon to Vegas! PLUS, and for this messy, badly organised chump, this would provide me a start to finish media managment system, with my tapes logged and plopped back in the IKEA drawer!

Nice idea? Stooopid idea? Or what?

Grazie

Comments

farss wrote on 6/3/2005, 12:44 AM
I think that's the grand plan, once I saw they were running it on top of SQL Server i had a pretty good idea what the plan was.
There's nothin to stop you rolling your own either, MS Access and other DB apps, can link to the SQL Server, such as Delphi (free personal versions are available).
To see how versatile SQL Server is this forum runs on top of it!

The only glitch is I don't know if we need / have the password to open the thing!

Bob.
Grazie wrote on 6/3/2005, 1:27 AM
"I think that's the grand plan" . .ah! Great Minds?

Here's the thing: Doesn't Normal VidCap & AdvCap provide tape name already? Why not have create a "Tape Library" thingy? We could then use the INS and OUTS and Comments as the basis of all the stuff for the reports? If we are TAGGING Own-Rolled MEdia: Grazie's Outakes; Grazie's Buildings . .. howabout "London Eye Tape1" tape . . "London Eye Tape2" tape TAGS . .or just plain ole TAPE NAME Tagging?

Look, we already have this info sloshing around our various hard drives, we got Media Manager - can't we/I already bring this together? Already? I reeeeeallly don't want to inpout export to ACCESS . . why not do it all from within V6?

See what I mean now Bob?

Grazie


.. oh, and to have this list printable too! I thank you!

<spilling edit>



farss wrote on 6/3/2005, 2:52 AM
You don't have to import to Access, Access just LINKS to the SQL Server via ODBC, then in Access you can use its report writer to print reports, you can use the Query builder etc to define relationships, do all kinds of magic on any data that's in there.

But here's the nice part. Say you don't want to mess with the Vegas tables but would like to store more info. Well you create a table in Access that has a relationship to the stuff in the Vegas tables. Now you will not be able to see that from within Vegas but no drama, your Access application can. With a bit of coding you can get Vegas to open the file from your own Access application. The sky's pretty much the limit.

All that said the fancier stuff would take a bit of work on our part but that's fair enough. You cannot expect the Madison team to caover everything that every user might want or the way they'd like to work. This is much the same as writing scripts but it should be a lot easier.

If you're game and with a little knoweldge you could even do this in the backend SQL tables, you can add stored queries etc. Even more exciting opportunities there.

As it is I think you should even be able to get the data from the Vegas Media Manager into an Excel spreedsheet, that's something that' s pretty inuitive to deal with.

The problem with ANY of these things (sorry if I state the bleeding obvious here), it ALL relies on you entering the data in the first place. I know that sounds trite but you have no idea how many times people have waved flashy reports under my nose and said 'see what the other guys software can do', forgetting that all those nice reports are based on data that they didn't want to take the time to enter.


Bob.
RNLVideo wrote on 6/3/2005, 4:23 AM
This type of capability would be OUTSTANDING! Definitely a thread I'm going to follow... :)
ForumAdmin wrote on 6/3/2005, 8:57 AM
One tip for "cheap" integration today is if you want hard copy or other more "open" form of archive: select all rows when the search results is in grid view, you can copy and paste into Excel very well (column identity is preserved). Hit print.