Dataclay — Automating Digital Production
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Register
    • Login

    Setting the IN and OUT points of a video clip with google sheet data

    Scheduled Pinned Locked Moved
    Templates
    4
    4
    357
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • sakodcundefined
      sakodc
      last edited by

      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

      ariestavundefined 1 Reply Last reply Reply Quote 0
      • ariestavundefined
        ariestav @sakodc
        last edited by

        @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?

        1 Reply Last reply Reply Quote 0
        • Ben Formanundefined
          Ben Forman
          last edited by

          Are there any devs you can recommend who understand this well enough to implement for me?

          1 Reply Last reply Reply Quote 0
          • Jeffundefined
            Jeff
            last edited by

            @Ben-Forman

            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.

            1 Reply Last reply Reply Quote 0
            • First post
              Last post