Known Participant

Question

Export my sequence name to the spreadsheet using AUTOMATION BLOCKS

Forum|Forum|1 year ago
December 4, 2024
3 replies
5053 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

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

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

This is amazing @Mathias Moehl thank you so much for your help. Do you know if in the future automation blocks will have an OCR feature that will read burnt in text from files?

We have no plans for such a feature at the moment.

You could write an Automation Blocks script, which first exports a frame to an image file and then executes a custom bat file on Windows which itself runs a OCR tool like Tesseract on the exported file. On Mac OS you could execute a shell script instead of a bat file. But I haven't tried that yet and it would definitely be some work to set up such a pipeline.

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

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 and Engagement Strategist – Adobe 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