Using Automation Blocks to Create Randomized + Large Batch Edits from .csv Spreadsheets

Forum|Forum|1 year ago
August 22, 2024
2 replies
1804 views

Hi all! New to Automation Blocks but there are a few automations I am running now that are incredibly helpful. I am hung up on this on project I'd love to share to see if anyone has any ideas.

Alright my situation is this; I have a batch of 5 video clips, 1 music track, and 5 png graphics. I want to keep the music track and png graphics the same, but create 125 Adobe Premiere sequences (every combination of clip 1, 2, 3, 4, 5). From my playing around so far (and I still have alot to do) it seems like my best option would be to create the 125 combinations in excel first? Then I am wondering if I'd be able to automate the population of the 125 Premiere video sequences and send them immediately to render out.

Hope that makes sense. Let me know if anyone has completed any projects like this or has any automations that could help! All the best and I'm looking forward to hearing from the pros.

SDK

This topic has been closed for replies.

E

Ecomguru123

Participating Frequently

Kyle - was wondering if you ever solved this and were able to achieve your desired result?

Mathias Moehl

Community Expert

I just created this tutorial, which shows a similar workflow:

https://docs.mamoworld.com/automation-blocks/tutorials-pr/batchSequenceCreation

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects

Mathias Moehl

Community Expert

Great to hear that AB is so useful for you, Kyle 🙂

To pick videos randomly, the following blocks could be useful:

- Random Number

- Get in List: This block also has an option to get a random element. In this snippet, we create a list with three project items and then pick one randomly:

Of course, if you pick elements randomly like that, it can happen that the same elements are picket twice.

If your want create all possible combinations, you can do that with nested loops.

Say you have 5 clips and want to show exactly 3 of them in each video. Assuming that no video should contain the same clip twice, you can loop over all possible combinations with nested for each loops like this:

The block code xml is also attached.

To learn more about what to do with each combination of clips, see here:

https://docs.mamoworld.com/automation-blocks/tutorials-pr/mogrtFromSpreadsheet

Here I extended the example from above such that for each variant the first three clips in the active sequence are replaced with the chosen project items and then the instance is added to the render queue: