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.
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.
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.
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.
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!
HP Z2 Mini Workstation OS: Windows 11 Pro Display:HP Z27 QHD DreamColor CPU:i9-10900K @3.70GHz 10 Core GPU:Radeon Pro WX3200 eGPU:Core X RTX 3090 RAM:64GB NVMe SSD:OS 2TB, Data 4TB NLE: DaVinci Resolve Studio 18.6
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?
HP Z2 Mini Workstation OS: Windows 11 Pro Display:HP Z27 QHD DreamColor CPU:i9-10900K @3.70GHz 10 Core GPU:Radeon Pro WX3200 eGPU:Core X RTX 3090 RAM:64GB NVMe SSD:OS 2TB, Data 4TB NLE: DaVinci Resolve Studio 18.6
- 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)