Exporting Thumbnails to spreadsheet with Automation Blocks

[evelyn_6350]

Hello,

I have a question and not sure if this is something automation blocks can do, but thought I'd give it a try. Is there a way to export thumbnails/jpegs straight to a spreadsheet?

Thank you so much in advance for your help,

Ev

[Mathias Moehl · Accepted solution]

This thread gives you some starting points:
https://community.adobe.com/t5/premiere-pro-ideas/how-do-i-export-a-shot-list-from-premiere-pro-with...

[evelyn_6350]

Hi Mathia, Happy New Year!!

thank you @Mathias Moehl this was very helpful and I got what I needed. one last question I promise haha. I have been exporting my sequece file names including start/end and duration of the clips in my sequece to my spreadsheet which works fine but for the task I was assigned, I am being asked if I can get the source start timecode and source end timecode instead of the sequence time code. Is that possible? apologies for all my messages, I have very little knowledge with this extension/scripts.

thank you so much in advance for your help.

Ev

[Mathias Moehl]

This sounds like the script you are running uses the Get Attribute of Clip block with the option "start time in sequence" and "end time in sequence", and you want to change those to "in point" and "out point" instead.

So it is just a matter of locating that block in the block code and changing these values.

[evelyn_6350]

Hi @Mathias Moehl , apologies for my lack of knowledge w/ automation blocks. Yes, I had "Get Attribute of Clip with the option of "start time in sequence" and "end time in Sequence" but when I change to "in point" and "out point". The results on my spreadsheet changes to 00:00:00:00 (for In point) and Duration of clips as my "out point". what am I doing wrong:(? Please help. Thank you so much for your patience w/ me. I have attached screengrabs of my script and the files in my bin w/ timecodes and my spreadsheet export results. Please let me know if you need more info to help me w/ this script. much appreciated!

[Mathias Moehl]

There are three different times which you can look at and I am not sure, which one you want.

With respect to a particular clip inside a sequence, you can look at the start and end time in the sequence or at the in and out point of the clip:

Now a clip has a corresponding project item and this project item also has an in and out point. But the in and out point of the project item is not necessarily identical to the in and out point of the clip (the project item just has one in point, but the clip can be used many times in sequences all over the project and have a different in point each time).
If you want to export the in point shown in the project panel, you need to replace the 
Get Attribute Of Clips blocks by Get Attribute of Project Items blocks.  But again: then this is really not the in point used at that particular clip in the sequence.
Note that you can exchange the "Get Attribute of Clip" by "Get Attribute of Project Item" without worrying about the parameter. "Get Attribute of Project Item" expects a project item as parameter, but if you give it a sequence clip as parameter, Automation Blocks will convert it to the project item corresponding to the clip. Only if you try to do that for a text clip, for example, this will cause an error, because texts have no corresponding project item.

[evelyn_6350]

Hi @Mathias Moehl thank you for your response. I tried all the options you provided me with but the outcome is still off for me. I need the In Point & Out Point of each clip used in the sequence. The In point is alway zero, but as you can see in my bin I have a consolidated AAF that was sent to me, which you can see all the In and Out Points of the clips in my sequence, but not sure why it's showing as 00:00:00:00 when I export using my script. Are you able to take a look at my script? I have attached here. I truly appreciate you w/ helping me w/ this journey. Hoping the more I use this application, the better I'll get. Thank you soooo much! I also attached a screengrab of my end result after running my script.

Please let me know if you have any questions or need additional info to test on your end.

Ev

[Mathias Moehl]

Oh, I see. The issue is that inPoint and outPoint are values in seconds where the start of the clip is always. 0 (see my image above). But you want to take into accout that the first frame of the clip has a different time code than 0.

Attached is a version, which retrieves the timecode of the first frame and adds it to the inPoint and outPoint to deal with that.

Note that I removed the marker-related code (since i had no markers on my test sequence and therefore it caused errors) and changed the file path. I also changed the code such that you need to change the file path just once at the very beginning of the code instead of in each "add row" block.

(code attached)

[evelyn_6350]

omg Mathias! you are my hero! yes, this is exacly what I have been trying to get at. This is perfect! I can't thank you enough! thank you sooo sooo much!!

[Mathias Moehl]

You are welcome - and thank you for the feedback ! 🙂