Awake in London!

Er m m m . . . . is is possible to do an OCR scan using tables option? This could then be implrted into anything that would recognise the Table formats: EXCEL, ACCESS or even WORD!

Only a thought . ..

Grazie

Voice activated software? I've had success using IBMs s/w.

"ZERO ZERO [TAB] ZERO ONE THREE [TAB] .. . " etc etc . .. You get to SEE the stuff as you read it off too! I've done this waaaayy ago and it worked nicley in EXCEL.

. . . another silly idea ! :)

Grazie

Another Idea that may be silly ! Perhaps there is a Possibility they could send the File as an Email Attachment then edit it in Avid ..

Well,
yes they could maybe send the file, who knows, I'm sure going to ask.
However the point is, it's not uncommon to give a tape with burnt int TC to a client for them to write out an EDL. I've even had one very kindly do it as a speedsheet. But then you've got to get that onto the format the Vegas requires and so far I've found a bug in the way it exports its EDLs. Seems it uses ";" as fiedl delimiters, now that's easy, Access and Excel will read that EXCEPT in one place Vegas uses s ":" as the delimiter which trips both of them up.

Also when Vegas exports its EDL it in double intereger time format, not formatted as TC, that makes sense because that way you can convert to TC depending on if it's PAL or NTSC.

Now Vegas also includes and aweful lot of stuff that I don't need to use, like fade in / out length etc. I need to experiment to see if it'll accept a 'barebones' EDL and fill in the blanks as it were.

Anyway I've made a start.

Seems to me in this day and age someone should even have a simple app, maybe something that'll even run on a PDA that you can give to a client for them to log shots with.

Bob.

Anyway that doing the simple find and replace on the ":" for";" using anything that is totally spurious .. I've had great success in the past using "$>$" OR anything that aint a needed field delimiter series? . . . This then gives a "set" point in which I can then enter a TAB mark. Any good?

Graze

what can i say - you all directed me to
http://www.peachrock.com/products.html
whenever i've asked about paper cut edls....

randall is right now at work on the edl editors dream veggie script...

the present version is not really what i wanted, but the next version, due i think in the next couple of months looks to be the answer to all our paper cut edl problems....

leslie

It's nearly there!
I've got it outputting an EDL, just Vegas I think wants me to specify every damn parameter, what a pain.
Bob.

Well. it's working. Well the hard part does anyway, writing the data out from the database into formatted text that Vegas will accept as an EDL. I'd though Vegas would be smart enough to need just enough data to specify what is needed for say a video track but it seems you have to have all the fields filled in.
Thanks to Grazie proding a few brain cells I realised the old Copy from Notepad into the code saved a LOT of typing!

I've still got a bit more to do and anyone who can use it can have it.
Please don't get too excited, it's NOT a script, you'll need Access 2000 or higher to use it. It is however totally standalone apart from that, so you can give to the wife/mistress/girlfriend/secretary to type in an EDL and when it's done this thing will spit out a text file that Vegas will read in.

Bob.

Oh yes, Bob, I'm a great "prodder" . . ;-)

Glad you got it sorted. I've used MS WORD for all sorts of . . well .. "sorts" for delminting syntaxs . . syntaxes? .. . sintax's .. oh well you know what I mean ..

Grazie

Actually in my other 'life' I've had all sorts of grief caused by people doing just that!
Our medical data is sent as position dependant text files, now if you open one of those files in Word (each line is about 700 chars long) and save it, good old Word reformats it to x chars long with a hard CR on the end. When that gets to the big number crunchers they have a total dummy spit.
Worse still we've found sending these kinds of files as attachments through Hotmail, it reformats them to 80 char line length. Did that cause major grief, I had various government guys blaming my software.
Bob.

Guess I'm one of those "people" . .. :)

Bob if you or any of the other Clever People here could write a script SO that Vegas could read an EDL File ...That sure would be Excellent... I wouldnt mind betting that some Very BIG Projects Hollywood Films ect would be using that script to edit in Vegas !

Just a thought !

Added:::::
also makes a File That is suitable for EDITING Film

Vegas CAN read and write EDLs. Just select the EDL option when you do a Save As. Also you can select a .txt fiel for Vegas to open.
The trcik though is getting the EDL in a format that Vegas will understand. This isn't excatly rocket science stuff, it's only a formatted text file.
The issue as I understand it with film editing and neg matchback has more to do with how film TC works. There's only one 100% reliable system made by Avid exclusively for the task. Their system integrates with film readers that read the frame numers from the edge of the film using OCR. I guess this COULD be done sort of by treat the film as a still sequence where each frames file name is the frame number, but then you have to deal with the precise fps of film and holding audio sync, could be much harder than it looks.
Bob.