Page 1 of 1

Simple List of Files Used

PostPosted: Sun Aug 16, 2020 1:42 am
by crellinfilm
Hello,

Is there a way to get a simple list of file names of files used in a Resolve project?

Thanks

Re: Simple List of Files Used

PostPosted: Sun Aug 16, 2020 5:38 am
by Igor Riđanović
I'm not sure if this is the best way. You can select all clips in the project, make a new timeline from these clips, and export an EDL of this timeline. The EDL will contain all the media file names.

Re: Simple List of Files Used

PostPosted: Sun Aug 16, 2020 5:57 am
by Shrinivas Ramani
The Media pool > Export metadata (for media) and the Export Edit Index (from a timeline's context menu) should both give you csv files, arranged by clip.

Re: Simple List of Files Used

PostPosted: Sun Aug 16, 2020 6:02 pm
by crellinfilm
Thanks. Got the information from Media Pool > Export Metadata.

Unfortunately, the exported metadata all shows up in one column. Is there a way to either export so the CSV file has a column per category, or to convert the exported CSV file so there's a column for each category.

For example, Name should have only names of files under that heading.

Re: Simple List of Files Used

PostPosted: Tue Aug 18, 2020 10:39 am
by Peter Chamberlain
There is data in the export only for fields that have data, no export for empty fields. AS its a CSV you can import into a spreadsheet so there are multiple columns.

Re: Simple List of Files Used

PostPosted: Wed Aug 19, 2020 12:18 am
by crellinfilm
Beautiful! It took a bit to figure out the columns, but your suggestion set me going in the right direction and I appreciate that very much.

Thanks for your help.

Re: Simple List of Files Used

PostPosted: Thu Jan 07, 2021 6:30 am
by Yasser Saeed
crellinfilm wrote:Beautiful! It took a bit to figure out the columns, but your suggestion set me going in the right direction and I appreciate that very much.

Thanks for your help.


How did you figure it out? My exported list is a mess! All information of each clip is in one column!

Re: Simple List of Files Used

PostPosted: Thu Jan 07, 2021 6:31 am
by Yasser Saeed
Peter Chamberlain wrote:There is data in the export only for fields that have data, no export for empty fields. AS its a CSV you can import into a spreadsheet so there are multiple columns.


I am sorry I could not understand that. WOuld you please explain in little more detail?

Re: Simple List of Files Used

PostPosted: Thu Jan 07, 2021 6:43 am
by Shrinivas Ramani
If you're opening the csv using a spreadsheet application like Excel, you may need some additional steps.
For example, see this.

Re: Simple List of Files Used

PostPosted: Thu Jan 07, 2021 1:21 pm
by pinthenet
I just tried an export. To format in Excel:

- Open the csv in Excel
- Select column A by clicking on 'A' in the volume title cell
- Select 'Data' in the menu or toolbar
- Select 'Text to Columns'
- In the Wizard, Step 1: Select 'Delimited' then 'Next'
- I Step 2 select ',' in the delimiters options
- Select 'Finish' and the CSV is formatted in to columns with headers. You'll have to change the width of some columns
(You could go to step 3 with Next and specifiy the format of each colum but it's probably not necessary)