Known Participant

Question

Export my sequence name to the spreadsheet using AUTOMATION BLOCKS

Forum|Forum|1 year ago
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

SDK

This topic has been closed for replies.

M

MakePPROgreatAgain

New Participant

What is automatation blocks?

Mathias Moehl

Community Expert

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

M

MakePPROgreatAgain

New Participant

Can it do what I want here: https://community.adobe.com/t5/premiere-pro-discussions/is-there-a-tool-extension-free-native-that-let-you-convert-any-sequence-with-items-to-code/m-p/15026572#M542523

E

evelyn_6350Author

Known Participant

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

Community Expert

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

Community Expert

Hi Mathias,

thank you so much for your help and taking the time to asnwer my questions. To answer your second question, I am working on a workflow to help the producers on our end when submitting shot requests to post production. We need the file name of the clips which contains burnt in metadata (slates, scrnr takes, VFX ID etc). This is to help the production team track where the files originally came from so they can gather that footage and sent back to us in a higher resolution when creating promos. So because I cannot copy and paste burnt in metadata, I have been adding that metadata in the markers comment box to make it easier to export that in one spreadsheet. But I can't get the markers metadata/comments to export to the same row where the clip name is exported to. I just was curious if there is any way to move those up to the top row of the colum since that info corresponds to the clip file name. Please let me know if you need more info or another example. I wuld be happy to share mor einfo w/ you.

thank you again so much for your help and time.

Ev

I see. Here is a basic example which puts

- in row 1 the name of the first clip and the name of the first marker
- in row 2 the name of the second clip and the name of the second marker

...

We use a variable "clip number" to count upwards with each iteration of the loop to know which clip number we are currently at. Then we can fetch the corresponding marker easily.
Note that this expects that if you have 100 clips, you also need at least 100 markers.

Also, maybe you want to use clip markers instead of sequence markers? Like just having one marker on each clip. Then the markers move with the clips if you move the clips around. And instead of doing the counting, you could just retrieve the first marker of "my clip" instead of a marker of the active sequence.
Also, if markers are missing, the export will then always stop at the clip, which has no marker. With the sequence markers, the export will stop at the last marker and not really notice if one is missing inbetween.

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects

export_each_clip_with_corresponding_marker.xml

Kevin-Monahan

Community Manager

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

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded