Skip to main content
Nick24532079q08t
Nick24532079q08t
Known Participant
October 10, 2024
Question

Automation Blocks - Importing text values from spreadsheet for ALL Sequences?

  • October 10, 2024
  • 1 reply
  • 377 views

Hi Mathias.  I thought I would start a new thread based on the amazing solution you and Henrique helped me with for exporting all text out of Premiere: 

https://community.adobe.com/t5/premiere-pro-discussions/automation-blocks-exporting-text-from-all-sequences-to-spreadsheet/m-p/14894802#M531702


I am sooo close to a nearly fully automated solution for translating text in Adobe Premiere.  I am struggling now to reimport the text from the spreadsheet we created.  I have been using the "Update Texts of Ae Mogrt with Spreadsheet" template as my base.  I modified it to look at just video tracks and removed the detailed analysis block.  (I did this in hopes of making things run faster).  For some reason when I run the script for all sequences the script hangs, or it takes a very very long time?  If I run the script for individual sequences at a time then it works within a minute if not seconds.  I'm not sure if I am approaching this problem correctly.  With the template "Update Texts of Ae Mogrt with Spreadsheet," is it processing every single item and clip on the timeline, or is it just processing Mogrts?  I'm concerned more complex sequences with a lot of clips and effects applied might be to blame, even though they contain only 2 or 3 Essential Graphics. 

I'm wondering if I should look to modify the template "Import Properties of Clips from Spreadsheet." as my base.  Do you think this would help me make things run faster?

Thank you for any help or advice you can give me.

This topic has been closed for replies.

1 reply

Mathias Moehl
Community Expert
Mathias MoehlCommunity Expert
Community Expert
October 10, 2024

To distinguish if the script hangs or is just processing for a long time, best add some write to console blocks which report step by step what the script is doing.
Then make sure the console panel is open when you run the script and then you see the progress.
Then you can understand better, what the script is doing and if is is just slow, hangs, or maybe runs in some kind of infinite loop. The "Update Texts of Ae Mort with Spreadsheet" already contains such console output, which you can enable with the "detailed console output" checkbox in the input panel.


In general, yes, the "Update Texts of Ae Mort with Spreadsheet" needs to look at all clips in the sequence, since it has no idea where the mogrts are, so it needs to look for them. If you have the clips that need to be modified, listed in the spreadsheet, then it will definitely be more effective to just loop over those. This is what the tools in the library at

Examples/Templates/Clip Property Spreadsheet

are doing.

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
    Nick24532079q08t
    Nick24532079q08tAuthor
    Known Participant
    October 14, 2024

    Hi @Mathias Moehl Thank you for your response 🙂 Okay, sounds like the "detailed console output" won't be slowing things down and I should re-enable it.  I will double check the console to see if it can shed any light.  I recall doing this in the past, but maybe I was just reading it wrong.  Would be nice if I could see where the hangup is.

    Okay, it sounds like I might be able to filter the Mogrts to be replaced in the same way I filter the text outputs using our export script.  I would still need to stick to a stringent set of predefined text parameters, but I think I could work with that.  If it looks for these text strings based on clip property specifically it might speed things up 👍

    Sorry for the delay Mathias, I have been pulled into another project, but hope to do more testing once I get some time.  I will let you know what I find.  Thanks!

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices