Data-driven video automation export

[mr.dinkov]

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!

[Kevin-Monahan]

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

[Roland Kahlenberg · Accepted solution]

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

[Stan Jones]

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

[Roland Kahlenberg]

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

😄

[mr.dinkov · Accepted solution]

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]

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

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

[Kevin-Monahan]

Mr. D.,

Cool. It's possible you could code up a CEP panel to do such things. Would that interest you?

Thanks,
Kevin

[mr.dinkov]

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

[Kevin-Monahan · Accepted solution]

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

[mr.dinkov]

Thank you @Kevin-Monahan. Definitely, will dig deeper into that topic. I feel that the end result could be very interesting for such workflows.

[Kevin-Monahan]

Good luck!

Kevin