Skip to main content
E
evelyn_6350
Known Participant
December 4, 2024
Question

Export my sequence name to the spreadsheet using AUTOMATION BLOCKS

  • December 4, 2024
  • 3 replies
  • 5026 views

Hello,

 

I am working with a script on Premiere and can't for the life of me export my sequence name to the spreadsheet using automation blocks. Is there a way to export my sequence name as the spreadsheet instead of "mySpreadsheet.csv"? It would be ideal if I could get a new spreadsheet for every sequence I export.

 

Any info would be greatly appreciated!

 

thank you!

Evelyn

    This topic has been closed for replies.

    3 replies

    M
    MakePPROgreatAgain
    New Participant
    December 8, 2024

    What is automatation blocks?

    Mathias Moehl
    Mathias Moehl
    Adobe Expert
    December 8, 2024

    It is a paid third party extension, which I am developing.

    You can get it here:
    https://aescripts.com/automation-blocks-for-premiere-pro/

    Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
    E
    evelyn_6350Author
    Known Participant
    December 5, 2024

    Hi Mathias, 

    I hope you are doing well. I have one other question that's been driving bananas. I created a script to export a spreadsheet which includes all the metadata in my sequence. The spreadsheet looks amazing w/ the exception of a few empty rows in columns D, E & F. I am only testing w/ a couple of clips for now and hoping you can shed some light. I am attaching a screengrab of my script and the exported spreadsheet. any idea of what I am doing wrong here?:(   
    Thank you so much in advance for your help.

     

    Ev

    Mathias Moehl
    Mathias Moehl
    Adobe Expert
    December 5, 2024

    Concerning your second question:
    Each "add row to spreadsheet" block adds a new row. If you keep fields empty while adding a row, they will stay empty when the next row is added.

    I also don't really understand why you want to have the marker data and the clip data in the same table. In your example, you have three markers and three clips, but clip 1 and marker 1 are not really related, right? There could be many more markers than clips or vice versa, so why should they be in the same row of the export. WOuld it not make sense to export markers and clips into two separate spreadsheets? Or keep it as is and have first a lot of rows with only clips and then a lot of rows with only markers.

    Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
    Mathias Moehl
    Mathias Moehl
    Adobe Expert
    December 20, 2024

    Hi @Mathias Moehl I hope your day is going well. I have been using the "Render Frames at Markers" from the scripts in the Library - under Examples-> rendering-> Render Frames at markers. There seems to be an issue w/ the script when I tried using it today. It is exporting hundreds of black still frames along w/ the correct jpgs. I had a sequence w/ 10 files and exported the jpgs using this, it did exported however it also exported 486 other jpgs - all black. Do you know why this is happening all of a sudden? I am adding the copy of the script here for you to review if possible and if you have time. 


    Have you checked your marker panel? Maybe you have additional markers before the beginning of the sequence or after the end of the video content?

    Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
    Kevin-Monahan
    Community Manager
    Kevin-MonahanCommunity Manager
    Community Manager
    December 5, 2024

    Hi @evelyn_6350,

    Our Adobe Expert, @Mathias Moehl  should be able to help you with this. Be sure to use the SDK tag next time. I did that for you just now. I hope that's OK. I hope the answer was helpful.

     

    Thanks,
    Kevin

    Kevin Monahan - Sr. Community & Engagement Strategist – Pro Video and Audio
      E
      evelyn_6350Author
      Known Participant
      December 5, 2024

      thank you Kevin! I'll remember to use the SDK tag next time:)

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