Blackmagic Forum

Hi,

I've gone through the manual and can't find any mention of exporting markers as a .csv at 'clip' level, only from the timeline. I have tried exporting clip metadata, but while that gives me things like the 'comments' it does not give me the markers with comments.

So a couple of questions:

Is this possible in resolve 14 to export clip markers and import them to the same clip on a different drive/project?

Where is the marker metadata stored? (only in the project/a file somewhere/user database?)

Any insights welcome!

a workaround idea: drop a black clip on a separate track, splice it at each marker, export EDL. You can reformat the EDL in Word, convert text to table an delete unwanted column.

George Deierling wrote:a workaround idea: drop a black clip on a separate track, splice it at each marker, export EDL. You can reformat the EDL in Word, convert text to table an delete unwanted column.

Thanks for the suggestion.

Not sure if this helps you, but you can export markers as an EDL:

Exporting Marker list with timecode

If you want it as CSV, you will need to apply some scripting for the format conversion, or some search/replace magic in a text editor.

Here is a very crude and ugly one-liner which seems to work for my markers to output a simple csv:

Code: Select all

perl -a -ne 's/\R//; if (/^\d+/) {print join("\t", @F[0,4])} elsif (/\|/) {@comm=split /\|/; print "\t", join("\t", @comm), "\n"}' MY_MARKERS.EDL

It produces something like this (I used tabs intead of commas for readability, and it can be directly copy/pasted into Excel):

Code: Select all

001   01:00:00:00   FFoA   D:1
002   01:00:08:21   dust   D:1
003   01:00:21:17   damage   D:1
004   01:01:08:08   cc   D:1


(Not sure what the "D:1" after the comment is)

BTW, this was with Resolve 12.5. Not sure if anything would have changed in v 14.

Albert Hofmann wrote:Not sure if this helps you, but you can export markers as an EDL:

Exporting Marker list with timecode

If you want it as CSV, you will need to apply some scripting for the format conversion, or some search/replace magic in a text editor.

Here is a very crude and ugly one-liner which seems to work for my markers to output a simple csv:

Code: Select all

perl -a -ne 's/\R//; if (/^\d+/) {print join("\t", @F[0,4])} elsif (/\|/) {@comm=split /\|/; print "\t", join("\t", @comm), "\n"}' MY_MARKERS.EDL

It produces something like this (I used tabs intead of commas for readability, and it can be directly copy/pasted into Excel):

Code: Select all

001   01:00:00:00   FFoA   D:1
002   01:00:08:21   dust   D:1
003   01:00:21:17   damage   D:1
004   01:01:08:08   cc   D:1


(Not sure what the "D:1" after the comment is)

BTW, this was with Resolve 12.5. Not sure if anything would have changed in v 14.

Thanks Albert, it all works perfectly fine for timeline markers however it is clip markers that I'd like to export.

The copy markers at clip level would be very useful, this is very missing!

It's possible to get clip markers using the scripting API.

Igor Riđanović wrote:It's possible to get clip markers using the scripting API.

Thanks! I'm watching!

But is it possible with clip markers what add on timeline to the clips? Because you can add markers to clip on timeline also (what are not included in EDL export/ import, strange)

I worked out exactly how to export clip markers. Da Vinci Resolve Studio 16.

Step 1: Go to Edit view -> open Edit Index on the top menu.
Step 2: In Edit Index panel, click on the "..." -> Show Markers -> All (this is very important)
Step 3: Right click on Timeline in Media Pool -> Timelines... -> Export -> Edit Index...
Step 4: Pick either CSV or TSV. Save your markers and view it!

By far Step 2 is the most obscure. Once you set up the Edit Index, they can be exported.

P.S. I also tried the Python Scripting API, using Clip.GetMarkers(). Got nothing.

Xavier,

As a test, I added red media markers.. cyan clip markers and blue(and one yellow) timeline markers ... and python queries do return me their values (see example below). Can you check if you have an issue in your script?
Regards
Shrinivas

The script API will see timeline markers.
Op was mentioning clip markers.

The example above shows media, clip and timeline markers

Shrinivas Ramani wrote:The example above shows media, clip and timeline markers

Apologies,
Should have read it more carefully.


Sent from my iPhone using Tapatalk

Shrinivas Ramani wrote:As a test, I added red media markers.. Can you check if you have an issue in your script?
Regards
Shrinivas

Thanks Shrinivas. I don't have the scripts I was testing with now, but I think what I missed was that GetClips returned a dict, and not an array. So I'll try that next time if I need it, thanks!

xavier_ho wrote:I worked out exactly how to export clip markers. Da Vinci Resolve Studio 16.

Step 1: Go to Edit view -> open Edit Index on the top menu.
Step 2: In Edit Index panel, click on the "..." -> Show Markers -> All (this is very important)
Step 3: Right click on Timeline in Media Pool -> Timelines... -> Export -> Edit Index...
Step 4: Pick either CSV or TSV. Save your markers and view it!

By far Step 2 is the most obscure. Once you set up the Edit Index, they can be exported.

P.S. I also tried the Python Scripting API, using Clip.GetMarkers(). Got nothing.

Thanks! This is incredibly useful for creating YouTube chapter markers. Your method above has changed slightly, for the 2023 18.5b5 version. You need to click the three dots button in the top right of the edit index (replaces step 3, right click on timeline in media pool), then select export as per this screenshot.

It's even easier in version 18.

Jim Simon wrote:It's even easier in version 18.

Chapter Markers.png

Thanks. I did see that too (forgot to mention). But I couldn't get it to work as I was uploading to an account that I was an editor of but not an owner of. I will definitely try it again though for my own account. Do you have any tips for this?

schultzm wrote:Do you have any tips for this?

I don't. Sorry.

This is perfect thank you. In v18, you can export direct from the from the menu "..."

xavier_ho wrote:I worked out exactly how to export clip markers. Da Vinci Resolve Studio 16.

Step 1: Go to Edit view -> open Edit Index on the top menu.
Step 2: In Edit Index panel, click on the "..." -> Show Markers -> All (this is very important)
Step 3: Right click on Timeline in Media Pool -> Timelines... -> Export -> Edit Index...
Step 4: Pick either CSV or TSV. Save your markers and view it!

By far Step 2 is the most obscure. Once you set up the Edit Index, they can be exported.

P.S. I also tried the Python Scripting API, using Clip.GetMarkers(). Got nothing.