** Short story:
I need to subtract 04:15:12:17 from the "Start Timecode" tag in every XML file for every clip on a card. Is there any way to Automate this process?
** Long Story:
I'm editing a Behind-the-scenes piece that was shot over 2 days with 2 cameras. A lot of the footage is B-roll shots, some is interviews and the rest is following whatever action happened. Sometimes the action was covered by both cameras, and this is where my question lies..
There was no slate used during shooting, and the shooters did not sync their timecodes. Normally I sort the footage in Log & Transfer by Media Start so any double covered footage will line-up pretty close to each other. That way I can log the A cam shot and then quickly log the B cam shot with the same name. The way it is now, I log the A cam shot and then have to search for the corresponding B cam shot, if there is one. I wasn't on the shoot, so I don't know what was double covered and what wasn't.
So with all that said, is there any way I could go in to the Metadata of the XML files and batch edit the timecodes to match? For instance, let's say I find a shot on the A cam and the timecode is 16:16:34;01. Then I find the same moment on the B cam at 20:31:46:18. So if I could subtract 04:15:12:17 from the B cam's timecode for every shot on the entire card, then in theory that would sync the 2 cameras for that card. I should also be able to follow that logic with the starting timecode for the next card and so on until I had both cameras synced for the entire shoot, barring any timecode drift issues.
Now this all sounds good in theory, but the ultimate question: Is it possible? I know that I can go into the "Clip" folder, open the XML for the clip and change the "Start Timecode" to whatever I want. I can confirm the change by opening the clip in L&T and checking the Media Start Column. What I can't figure out is how to automate this process across all the B cam shots on all the B cam cards.
Also, if this isn't possible, can you lend any advice on logging multi-cam footage that wasn't properly slated or synced during shooting?
I've also posted this on the FCP forum in case someone there has had a similar issue.