Skip to main content
Elwoodjblues1
Inspiring
March 4, 2025
Answered

Automation Blocks Renaming multiple Timelines based on Excel.

  • March 4, 2025
  • 1 reply
  • 3269 views

For a project, I regularly have to rename a lot of timelines based on a template from Excel. I used to do this manually, which takes a lot of time. Now I would like to automate this with the help of Automation Blocks. Unfortunately, I don't know what the appropriate script has to look like to realise this. Based on another script I have tried this so far as you can see on the screenshot. Unfortunately it does not work like this. What do I have to change to make it work?

Correct answer Elwoodjblues1

Maybe your issue is that yu have the "Process only selected items" checkbox checked, but actually want to process all items instead of only selected ones?

 

I just recorded this video to test the workflow and it worked fine for me (in the video I kepft the "process only selected items" in the inputs panel, such that you can check/uncheck it there):


OK. I have figured out where the problem was. The CSV file must be saved in CSV UTF-8 format (separated by separators). This is the only way the file can be read correctly.

1 reply

Mathias Moehl
Community Expert
Community Expert
March 4, 2025

Looks almost good! Just plug the purple block inside the green one. Currently it is only executed once, after the spreadsheet has been read. If you plug it inside, it is executed many times, namely once for each row of the spreadsheet and this is what you want:

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
Elwoodjblues1
Inspiring
March 4, 2025

Thanks for the advice. It still does not work. But at least I no longer get an error message. Can I send you the script with a sample project and the Excel file? Or would the script itself be enough for you?

Mathias Moehl
Community Expert
Community Expert
March 6, 2025

OK. I have figured out where the problem was. The CSV file must be saved in CSV UTF-8 format (separated by separators). This is the only way the file can be read correctly.


Thanks a lot for the feedback - great to hear that it is working now. For issues with reading/writing csv also see the links at the bottom of this page: https://docs.mamoworld.com/automation-blocks/block-reference/filesSpreadsheet#troubleshooting-spreadsheet-issues

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