Skip to main content
M
mr.dinkov
Participant
January 11, 2023
Beantwortet

Data-driven video automation export

  • January 11, 2023
  • 2 Antworten
  • 2167 Ansichten

Hello,

I'm looking for best practices with a specific workflow. I have created a bunch of videos inside Adobe Premiere Pro with some text effects similar to subtitles, but they are made using essential graphics because it provides more options for animations. I need to make translations for these videos in more than 20 languages, and I don't want to copy and paste the texts manually. Is there any option to automate the process?

 

For example, in Photoshop there are "Data sets" and, in combination with "File/Export/Data set as files," I can translate all of my static creatives in a matter of minutes.

 

Texts are looking like this:

 

And with different translations, the background must adapt to the text's length.

So the ideal workflow will look something like this: 

- Have a template with all texts

- Use variables for automatically replacing the text with the correct translations

- Some sort of "batch export" to the media encoder to rend all videos at once.

 

If this is possible in any other software I'm open to suggestions.

Currently, I have all the latest versions of adobe creative cloud / using Mac OS

 

Thank you!

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von Kevin J. Monahan Jr.

Never worked with such thing but as little as I read about it, sounds very interesting. Would like to hear more about it.


To make a CEP panel you can use ExtendScript, in PPro. 

Here's the PProPanel sample, which contains example code showing sequence generation, adding track items, inserting .mogrts, and manipulating .mogrt params.

 

Kevin

2 Antworten

M
mr.dinkovAutor
Participant
January 14, 2023

Ah, thank you all for these advices! I managed to automate the workflow using After Effects and compsFromSpreadsheet. 

For the current setup, I don't need to update the comps after filling them with content, so it's working like a charm. 

 

Once, again thank you @Kevin-Monahan, @Roland Kahlenberg 

 

Although, I'm interested in finding a solution for Premiere as well. Especially, for combining some automation techniques with essential graphics templates. 

    Roland Kahlenberg
    Roland Kahlenberg
    Legend
    January 18, 2023

    Hah!!! Apparently we taught you too much!  
    😄

    Thanks for reporting back and doubly glad that you got productive with the provided tips. 

    Very Advanced After Effects Training | Adaptive & Responsive Toolkits | Intelligent Design Assets (IDAs) | MoGraph Design System DEV
    Kevin J. Monahan Jr.
    Community Manager
    Kevin J. Monahan Jr.Community Manager
    Community Manager
    January 11, 2023

    Hi, mr.dinkov,

    Sorry for the frustration. You'd have to create these .mogrts or use a third-party solution. I just saw this Facebook page, and it looks like there may be a data-driven mogrt solution for you: https://www.facebook.com/broadcastGEMs.

     

    @Roland Kahlenberg can give us more info on this. 

     

    Thanks,
    Kevin

     

     

    Kevin Monahan - Sr. Community and Engagement Strategist – Adobe Pro Video and Audio
      Roland Kahlenberg
      Roland Kahlenberg
      Legend
      January 12, 2023

      That's a stunning Facebook Page, Kevin.   😄

      To Dinkov, here's a Promo Video I recently posted on Video Automation using Data from a Google Sheet - https://youtu.be/OoBY9oPcYRc

      And here's a screengrab of what a spreadsheet for a data-driven multiple languages video looks like - 

      You can access GogleTranslate via a Google Sheets formula - =GOOGLETRANSLATE

      You'll also want access to this Wiki to access country/language codes to use with Google Sheets - https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes

      Looking at your graphics sample, you'll also have to apply Responsive Motion Graphics features - this ensures your texts are encapsulated with an appropriately-sized panel.

      And all these are done in Adobe After Effects. I can assure you it's quite a fair bit of a deep dive cos it involves Expressions and hooking up AE Compositions to a TSV file (this is essentially an export of the Google Sheet). 

      You'll want to look at using Dataclay's Templater script to automatically create the comps and then update the data on an as and when required basis. Another option is compsFromSpreadsheet which creates all the required comps by reading details from a spreadsheet BUT it does not have a workflow, unlike Templater, to update the comps later. 

      ProTIP - while working on this; if you're going to bang your head against a wall, put on a safety helmet.  🙂

      HTH

       

      Very Advanced After Effects Training | Adaptive & Responsive Toolkits | Intelligent Design Assets (IDAs) | MoGraph Design System DEV
        Roland Kahlenberg
        Roland Kahlenberg
        Legend
        January 18, 2023

        Roland,

         

        > That's a stunning Facebook Page, Kevin.   

        lol. I had to take a look to see what impressed you!

         

        Wow. I often passed on info regarding scripts that used AE's abilities to handle text import, e.g. a pre-PR2021 method for getting high-quality subtitles. But your method is powerful.

         

        And yes, helmet needed if you try this from scratch.

         

        Stan

         

         


        I can be biased at times but I swear I wasn't lying!!!   

        😄

         

        Very Advanced After Effects Training | Adaptive & Responsive Toolkits | Intelligent Design Assets (IDAs) | MoGraph Design System DEV
        Allgemeine NutzungsbedingungenAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices