Known Participant

Question

Export my sequence name to the spreadsheet using AUTOMATION BLOCKS

16 replies
5213 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

M

MakePPROgreatAgain

Participating Frequently

What is automatation blocks?

Translate

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/

Translate

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

M

MakePPROgreatAgain

Participating Frequently

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

Translate

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

Translate

Mathias Moehl

Community Expert

Hi Evelyn,

concerning the file path: Since they are just texts, instead of using a file block, you can create those with any text blocks:

(code is attached).

Translate

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

spreadsheet_file_from_sequence_name.xml

Kevin J. Monahan Jr.

Legend

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

Translate

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:)

Translate

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.