Participating Frequently

Answered

Is there a way to log a list of all the clips used in a timeline?

Forum|Forum|7 years ago
January 17, 2019
12 replies
25901 views

I have a bunch of timelines with a bunch of clips on them. I need to know a list of the clips in their original file names that were used in the timeline. Short of right-clicking on each one and selecting "reveal in finder" is there any way of performing this in a printout or a log file?

Correct answer smrpix

Select your timelines and export as an Avid Log Exchange file. This will create a text document that lists all the clips used in alphabetical order. It will also list source folders.

L

laurieB82C

Participating Frequently

The scenario is I need to provide an excel spreadsheet to attorneys for clearance, it needs to have all assets as separate line items with timecode so they can refer to the footage for each clip. Is editing the XML manually the only way to accomplish this? I cannot believe there is not a solution for filmmakers who need this.

ApexAV

Inspiring

Perhaps this online tools will help you to convert your xml to an excel

https://editingtools.io/editlist/

or

https://editingtools.io/cuesheet/

I use this to provide music info to our executive producer. Sometimes very helpful for me.

S

Steve AU

Participant

Hi,

The best way to do this is export an XML out of Premiere Pro. Import, as a timeline, into Da Vinci Resolve. Select the sequence, right click and select Timelines > Export > Edit Index. This will generate a .csv files that can be opened in any spreadsheet program.

🙂

J

jdvideo

Inspiring

Hey Steve, trying to follow your instructions here but don't know where to find the sequence file. I found the XML in the media pool but there is no timelines > export option there.

S

smrpixCorrect answer

Participating Frequently

Select your timelines and export as an Avid Log Exchange file. This will create a text document that lists all the clips used in alphabetical order. It will also list source folders.

W

Wylie_702

Participating Frequently

Thanks for this. Excellent suggestion. I then imported it into excel and have a tab for each of my sequences! You rock.

C

CRAYONSEED

Participant

I just found this page looking for the same feature. I just want a list of all the clips I used so my client can buy stock licenses for them. There was no reasonable way to keep track as I went (we were swapping files constantly), so I guess I'm stuck right-clicking and finding the files one by one by one...

R

Ravenshoe

Known Participant

Another work-around is to:

1. Export the sequence using Project Manager. Exclude unused clips in export.

2. This will give you a folder of all the media in that sequence.

3. Then you can copy those file names and past into a text edit file.

B

Boka2112

Inspiring

Well... There really should BE!

A

ateigen

Inspiring

I realise the thread is old, but for the still curious: Sure, you can use the EDL and tick off for "use source file name". You can also export a FCP XML and make a cusomized retrieval of the info you want for your workflow with for example an XSLT stylesheet. This could be a place to find out how to do it: https://www.w3schools.com/xml/xml_xslt.asp

A

Alex22139330nbsc

Participant

Great question! I had the same after reading some of these I just ended up going into my sequence and unlinking that media. Once offline relinked and it gave me a list of the clips to locate, didn't give time codes but was a enough to be able to dump unused clips!

K

kellys10537129

Participant

Check out EDL Ease. It provides very limited data, but one of the line items looks to tell me the original file name.

ClipClearance

Participant

Thank you kellys10537129

I am the developer of EDL Ease and the software can do this. You would need to export CMX formatted EDLs for every video layer in each sequence. You can then drop all the video layers and they will be re-combined into one excel document and if selected in the settings will create duration summaries for SOURCE, FROM CLIP NAME and SOURCE FILE (depending on the workflow) so you would have a parsed out list of all edit events and separate tables with clip names (from all layers) and their combined Source and Program durations.

EDL Ease is free, secure, codsigned and notarized by Apple and has been tested on OS X High Sierra through Catalina. It is intended to create a simple yet elegant human readable static list and tabled data from EDL File(s) and should not be used to conform or clean EDL's There are plenty of other tools out there that offer these functions.

Download a free copy here:

EDL Ease

J

JG_Work_Account

Participating Frequently

Wow, this EDL App is a lifesaver! Thank you for developing and sharing this. Just came across the gem of an app. Amazed this isn't built-into PremPro as a feature, so glad this exisits. Thank you.