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.
... View more