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
6
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.
AdChoices