• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Metadata

New Here ,
Dec 13, 2023 Dec 13, 2023

Copy link to clipboard

Copied

I need to export a report with this metadata from my premiere file which has about 300 clips:

- timecode of each clip

- duration of each clip

- start and end time of each clip within the source

 

I'm preparing a spreadsheet in order to have certain assets validated and it's something a computer could do way better and fast then me lol.

 

Please send help.

 

I'll be here until 2025.

 

Thank you.

TOPICS
Editing , Export , Formats , How to

Views

488

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Dec 14, 2023 Dec 14, 2023

Exporting an edl might also give you what you want.

Votes

Translate

Translate
Community Expert ,
Dec 14, 2023 Dec 14, 2023

Copy link to clipboard

Copied

This is a perfect job for Automation Blocks.

I recoreded this tutorial for you showing how I created a custom script in 10 minutes, which exports the data you need to a spreadsheet:

The script I create in the tutorial is attached. You can load it in Automation Blocks (also in the free trial) and just run it.

 

Extra tip: make sure the spreadsheet file does not exist, yet, if you run the tool. If it exists already, Automation Blocks will append the new spreadsheet data to the existing file. Of course, you can also add a block to the beginning of the block script, which deletes the file if it exists, but I wanted to keep the block code simple.

 

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Dec 18, 2023 Dec 18, 2023

Copy link to clipboard

Copied

Amazing.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Feb 20, 2024 Feb 20, 2024

Copy link to clipboard

Copied

Is it also possible to extract text from ae mogrts, which I can output to a spreadsheet?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 20, 2024 Feb 20, 2024

Copy link to clipboard

Copied

LATEST

Absolutely.

The Get Clip Parameter Value block can retrieve any clip parameter, also the texts or mogrts. 

I don't have a tutorial for exactly this, but here is a tutorial showing how to set the text of mogrts based on a spreadsheet.

https://docs.mamoworld.com/automation-blocks/tutorials-pr/mogrtFromSpreadsheet

This shows you how to access a particular text of a mogrt (setting and getting is works similar).

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 14, 2023 Dec 14, 2023

Copy link to clipboard

Copied

Exporting an edl might also give you what you want.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines