Skip to main content
E
evelyn_6350
Known Participant
December 24, 2024
Answered

Exporting Thumbnails to spreadsheet with Automation Blocks

  • December 24, 2024
  • 1 reply
  • 4231 views

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

    1 reply

    Mathias Moehl
    Community Expert
    Mathias MoehlCommunity ExpertCorrect answer
    Community Expert
    December 24, 2024

    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-thumbnails/idi-p/14466053

    Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
    E
    evelyn_6350Author
    Known Participant
    January 7, 2025

    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

    E
    evelyn_6350Author
    Known Participant
    January 11, 2025

    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.


    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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices