Hi Mathias, I wanted to continue our conversation from aescripts.com here on the forums. Thank you for providing me with this updated code block image. You were spot on to have the template block for exporting clip data embeded into the "For each sequence" block. It took me a while to get it to work but eventually got it to a place where I could export all the data for the selected sequences. Couldn't seem to get it to work as a Bin and Sub Bins option. I don't mind selecting the sequences though. The challange I am now facing is the time it takes to export all the clip data in those sequences. With only 3 sequences selected (out of 8), the export to .csv took 29 minutes. I feel like I'm missing something. My concern is the sheer amount of data i'm pushing from all these clips is irrelevant. All I really want to be able to do is export the text only from all the AE Mogrts in a project to a .CSV, Then I can translate and re-import the .CSV and have it update all AE Mogrts in all sequences in a chosen language based on the column. I've tried the template update AE Mogrt Texts with Spreadsheet, and it has been hit or miss for me. Punctuation seems to throw it off, and sometimes it misses whole text strings all together. I have used the Export Properties of selected clips to spreadsheet because it works reliably. It seems to make all the changes with accuracy. Creating a spreadsheet that has just the mogrt text and then reimporting it for the entire project is my goal. I can make this work by exporting massive amounts of data, but I'm concerned about the processing time. I know i'm doing it wrong, because I'm not much of a programmer. I'm attaching what I ended up with for the export of the data. Thanks Mathias.
1 Correct answer
Hi Nick,
to give some context for everybody else, here is the original conversation:
...I've watched this tutorial several times: Update Clips, Texts, Colors and More With A Spreadsheet . It's a great video tut, and I have learned how to export, "all selected clips" to a spreadsheet. I've modified the data and re-imported it. Works great! I try to reverse engineer this process by adding the automation block: For Each Project Item, but I've been unsuccessful so far. My goal is to export all c
12
Replies
Hi Nick,
to give some context for everybody else, here is the original conversation:
I've watched this tutorial several times: Update Clips, Texts, Colors and More With A Spreadsheet . It's a great video tut, and I have learned how to export, "all selected clips" to a spreadsheet. I've modified the data and re-imported it. Works great! I try to reverse engineer this process by adding the automation block: For Each Project Item, but I've been unsuccessful so far. My goal is to export all clip data from all sequences in a Premiere project to a .CSV. As an example, the projects I work with have many sequences, and each sequence contains Essential Graphics. Rather than exporting the data of "the selected clips" one at a time, is it possible to export the data for all clips inside all sequences to a spreadsheet?
Much appreciated. Thank you.
By @Nick24532079q08t
Hi Nick,in a nutshell, you have to nest the block, which loops over the items of the sequence into a block which loops over all sequences. See attached screenshot. That way, you cannot only loop over the clips of the active sequence, but off all sequences one after the other. Note that in this case, you should also modify the "add row to spreadsheet" block to also save the sequence itself in some cell. Otherwise you don't know which data belongs to which sequence and won't be able to do anything useful with it on import.
now my answer 🙂
To process all sequences instead of the selected ones, you need to uncheck this checkbox:
Some ideas to improve performance:
When looping over the clip parameters, you could check if "my param" starts with
Maybe before writing a property to the spreadsheet, you could check if its name starts with "Graphic Parameters". I think this should be the case for all essential graphics properties and for no other properties. Then you could do the processing (retrieving the property value and writing it to the spreadsheet) only, if it is an essential graphics property and skip writing everything else to the spreadsheet.
Even better: You could add an additional check when looping over each clip, to avoid processing clips at all, which are no mogrts. You could try to retrieve the media path of the clip and if it exists and ends with .mogrt you know that it is a mogrt. Only in that case, you need to loop over all parameters of that clip and otherwise you could skip that entirely, which should speed up processing a lot.
The great thing with Automation Blocks is that everything can be customized.
In Henrique's code, just find the part which loops over the properties that are exported, then add a condition to only export if it is one of the entries you want to export.
What might be confision about TMMW's code at first is that it consists of functions, which are collapsed. So you need to right-click->expand on the "run" block to see the details of the main code.
#
The only thing that you need to figure out is what exactly distinguishes the values you want to export from the ones you don't. Maybe they have some keyword in their name? Like only export properties whose "prop" value does not contain "color" or "guide"? Really depends on your templates.
If you use the "get prop of clip" block, you retrieve the actual text that the template parameter has. If you use just "prop" itself, you get the graphics parameter column instead of the value column:
The "in text ... find" block returns 0 if no occurrence of the word was found. Hence, we check if it is NOT 0, because then we know that the keyword has been found.
This will return true if the prop is
"Graphics Parameters\Darth"
but also if the prop is
"Graphics Parameters\My Darth V"
i.e. it only checks if the word "Darth" occurs anywhere in the name.
If you want to be more precise, you can do an equality check with the full parameter name:
AdChoices
