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
  • 4248 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

    Mathias Moehl
    Community Expert
    Mathias MoehlCommunity Expert
    Community Expert
    January 11, 2025

    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


    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)

    Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices