Skip to main content
janj93296155
janj93296155
Participant
February 21, 2024
Answered

Update text of AE Mogrt with spreadsheet not updating Text

  • February 21, 2024
  • 1 reply
  • 342 views

I have created a Mogrt in AE, placing multiple copies of it on the timeline. I even renamed each of the clips to unique name. I also created a CSV file with the two colums with placeholder and new text.

 

When I run the Update text of AE Mogrt with spreadsheet.xml it replace all the placeholder text with the first text change in line one of the csv file, "Base enclosure". When I look at the console output I see the following:

 

execute script replace "TitlePlaceholder" by "Base enclosure" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 1) replace "TitlePlaceholder" by "Battery" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 2) replace "TitlePlaceholder" by "Speakers" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 3) replace "TitlePlaceholder" by "Touchpad" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 4) replace "TitlePlaceholder" by "USB board" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 5) replace "TitlePlaceholder" by "Wireless LAN module" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 6) replace "TitlePlaceholder" by "Heat sink" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 7) replace "TitlePlaceholder" by "System board" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 😎 replace "TitlePlaceholder" by "Display panel assembly/Top cover" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 9) replace "TitlePlaceholder" by "Display bezel" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 10) replace "TitlePlaceholder" by "Display panel" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 11) replace "TitlePlaceholder" by "Support bracket" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 12) replace "TitlePlaceholder" by "Webcam" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 13) replace "TitlePlaceholder" by "Display panel hinges " in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 14) replace "TitlePlaceholder" by "Display panel cable" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 15) replace "TitlePlaceholder" by "Wireless LAN antennas" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 16) replace "TitlePlaceholder" by "Display enclosure" in sequence "\Himalayan_Chaptered_FRU.prproj\Himalayan_Chaptered_FRU" (spreadsheet row 17) execution result:undefined destructor final end point 'main script' reached

    This topic has been closed for replies.
    Correct answer Mathias Moehl

    You are talking about Automation Blocks, right? Make sure to always mention Automation Blocks in the title in that case, otherwise it is likely that I overlook the post.

     

    By design, the "Update text of Ae Mogrt" tool replaces all instances of the text, i.e. if your spreadsheet looks like this:

    TitlePlaceholder, Text 1

    TitlePlaceholder, Text 2

    TitlePlaceholder, Text 3

     

    then the first row says "replace 'TitlePlaceholder' everywhere by 'Text 1' ".
    and the second row says "replace 'TitlePlaceholder' everywhere by 'Text 2' ".
    But effectively, the second row makes nothing anymore, since all 'TitlePlaceholder' texts are gone and replaced by 'Text 1' already.

    Solution:
    Setup your spreadsheet like this:

    TitlePlaceholder1, Text 1

    TitlePlaceholder2, Text 2

    TitlePlaceholder3, Text 3
    and then also set the texts in the first mogrt instance to TitlePlaceholder1, in the second mogrt instance to TitlePlaceholder2 etc. before running the Automation Blocks tool.

     

    Cheers,

    Mathias

     

    1 reply

    Mathias Moehl
    Community Expert
    Mathias MoehlCommunity ExpertCorrect answer
    Community Expert
    February 21, 2024

    You are talking about Automation Blocks, right? Make sure to always mention Automation Blocks in the title in that case, otherwise it is likely that I overlook the post.

     

    By design, the "Update text of Ae Mogrt" tool replaces all instances of the text, i.e. if your spreadsheet looks like this:

    TitlePlaceholder, Text 1

    TitlePlaceholder, Text 2

    TitlePlaceholder, Text 3

     

    then the first row says "replace 'TitlePlaceholder' everywhere by 'Text 1' ".
    and the second row says "replace 'TitlePlaceholder' everywhere by 'Text 2' ".
    But effectively, the second row makes nothing anymore, since all 'TitlePlaceholder' texts are gone and replaced by 'Text 1' already.

    Solution:
    Setup your spreadsheet like this:

    TitlePlaceholder1, Text 1

    TitlePlaceholder2, Text 2

    TitlePlaceholder3, Text 3
    and then also set the texts in the first mogrt instance to TitlePlaceholder1, in the second mogrt instance to TitlePlaceholder2 etc. before running the Automation Blocks tool.

     

    Cheers,

    Mathias

     

    Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices