Getting Time/date from avchd over to srt file??

blink3times wrote on 3/4/2009, 4:26 AM

I went in to Bestbuy to pick up a movie and ended up walking out with a Sony SR11 (price was too good to ignore).

Extracting the time/date from my old HC3 was easy... HDVsplit would do that for me on capture. It would label each clip with the metadata time/date. Then once in Vegas I could use "quick labels" in Excalibur to take each clip label and create a subtitle file which of course would be used on the final disk.

Now the question is.... How the heck do you do this with avchd???

The aim here is to end up with a subtitle file containing the time/date of each clip. Rumor has it that the time/date of each clip is stored in the MPL file in the PLAYLIST folder, And some one even wrote a program to extract time/date for the Canon avhcd cams and stuff it into a srt subtitle file.

(last post in the thread)
http://www.avsforum.com/avs-vb/showthread.php?t=1018113

Of course this program doesn't seem to work for my sr11 (or maybe it's vista 64?)

Anybody have any ideas on how I can automatically extract the metadata time/date from avchd and stuff that info into a srt file??

I should point out that when you import the MTS files from the cam windows explorer does create a "date modified" column and that date/time does seem correlate with the time each file was created, so I guess the NEXT best thing short of using the real metadata info, would be to figure out how to automatically rename each clip with the "date modified" info in windows explorer.

ideas???

Thanks.

Comments

blink3times wrote on 3/4/2009, 6:47 PM

Just a follow up for those in the same boat....

I opted to for the the "Date Modified" rename trick and renamed the files with the windows explorer "modified date" which is in fact the time and date shot of the MTS files.

The trick was finding a file renamer that not only handled the date... but could also handle renaming with the time as well... right down to the second (this is necessary so that you don't have a "march 23_a" and a "march 23_ b" scenario)

Took ALL friggin day and about 100 downloads of different renamers.... but finally found one:

http://www.den4b.com/

After renaming the files then it's just a matter of using the "quick labels" switch in EXCALIBUR plugin to create a region track with the clip's file name, then exporting the track as a SRT subtitle track.

MozartMan wrote on 8/2/2009, 4:42 PM

blink,

You can use tsMuxeR to demux raw .M2TS AVCHD file and you will get .SUP subtitle file. But if you even smart render AVCHD file from Vegas, you will lose subtitle track.

john-beale wrote on 8/2/2009, 5:08 PM

I'm curious about this- do the AVCHD cameras store metadata like time,date, exposure, GPS coords, etc. into a subtitle file? I wasn't aware of that, but it sounds like a reasonable way to do it.

MozartMan wrote on 8/2/2009, 5:42 PM

It is only time and date as subtitles, as far as I can see with my test.

blink3times wrote on 8/2/2009, 5:47 PM

Thanks MozartMan...
but I think I'll stick with things the way I have now. The tmuxer method handles things on somewhat of a singular affair and the method I have worked out operates very much on a batch principle. I can rename 1000 clips in a few seconds and use excalibur to create a subtitle time line for those 1000 clips in about 30 seconds.