Setting the IN and OUT points of a video clip with google sheet data
-
Hi!
Is there a way to set the IN and OUT points of a video clip with google sheet data? Meaning I set the footage file with one column (file path) and in the next column I set it´s IN Point (TC) and in the next column I set it´s OUT point (TC). If the IN or OUT column cell is empty the clip will be placed with it´s full length or only trimmed on one of the ends. What would be the easiest way to achieve this?
Thanks!
Sascha
-
@sakodc Hi Sascha. Apologies for the delayed reply. Have you seen our Time Sculpting features? You may be interested in seeing the video on Time Shifting and Time Cropping.
If the Time Sculpting features do not suite your needs, You will need to make use of Templater’s ExtendScript API. You essentially write ExtendScript code that makes use of Templater’s in-memory job data, and use that data to set specific layers’ In and Out points.
You would use the
$D.job.get("column-name")
method to get the data from the job’s column into a variable. Then you can use that data to set an In point or Out point of a specific layer.Does this help?
-
Are there any devs you can recommend who understand this well enough to implement for me?
-
I understand that we’re in direct contact on this particular issue, but I wanted to make sure that any additional technical questions that you might have get answered. As far as referrals go, we’re in the process of creating a system for clients to get in touch with skilled developers. That should be launching relatively shortly, but if we can answer any other questions in the meantime, please just us know.