Add support for Premiere CSV

[mangelope]

MarkerToolbox.io website says TC + TSV work, no luck pulling from .CSV. Just paid for MarkerToolbox.io today to convert .CSV transcriptions from Adobe Premiere into FCPX as markers. What is is the required format including timecode? Here’s what comes out of Premiere (see attached). I am not a coder so hopefully there's a simple solution, thanks in advance!

Michael Angelo

[mangelope]

PS obviously erased End Time column and some other failed revisions of .CVS file

[mangelope]

Problem was the semi colons in the timecode, MarkerToolbox.io doesn't like them, premiere defaults to them, did a find replace and got it to work using manual past into MarkersToolbox then Process Comments Locally.

Would love any advice on how to improve workflow, but I've been working on this for 10+ years, so today just happy to get this to work!!!

Gratitude - MA

[latenitefilms]

Could you share a CSV from Premiere? I will look into adding support natively.

[latenitefilms]

Unfortunately your CSV didn't attach properly in GitHub, you might have to reply via the website or send me a DM or email instead.

[latenitefilms]

There is actually functionality to apply markers to an existing clip:

https://markertoolbox.io/how-to-use/#apply-markers-to-existing-final-cut-pro-clip

[mangelope]

Replied from email, didn't know ti was from github, sorry, here ya go ;)

This is amazing, test .CSV file from Adobe Premiere attached:

• VB221115_MULTI_TEST01_CClip_CAPT_v01ma.csv

VB221115_MULTI_TEST01_CClip_CAPT_v01ma.csv

Gratitude!

Michael Angelo

PS An option to embed markers into original source clip instead of Chapters/Compound Clip workflow would be pretty amazing ;)

[mangelope]

Got your embed message, thank you, will try it!

MA

[mangelope]

Hey Chris, tried the embed, it's perfect as it's markers instead of notes, awesome!

With that said, the MarkerToolbox.io workflow extension inside of FCPX says our markers start at timecode 2.00.26.05 but when it "Applies Markers to Existing Final Cut pro Clip" it starts them at 2.00.18.23 ;( Any thoughts why this would happen?

Our workflow with embedded markers is such that they travel with clips into project timelines, a 7 second delay in markers would cause some serious challenges.

Appreciate you, your amazing product, we are SO close, been working on this challenge for over a decade, look forward to hearing back from you!

MA

[latenitefilms]

Have you got the correct frame rate selected?

[mangelope]

Morning Chris,

Caught an issue with Premiere frame rate but re-ran everything with correct frame rate thru entire pipe same results:

HD 23.98p 2:00:00:00 start FCPX out ---> MP3 Premiere Timeline ---> HD 23.98p 2:00:00:00 start Premiere Create transcriptions ---> export .CVS Prep for Marker Toolbox ---> _PREPD.cvs one column timecode in + second column text Manual Copy paste .CSV data into ---> Marker Toolbox Workflow Toolbox Process comments locally ---> Apply Markers to Existing Final Cut pro Clip

Markers start at timecode 2.00.26.05 but when it "Applies Markers to Existing Final Cut pro Clip" it still starts them at 2.00.18.23 ;(

Interesting to note, when we export to XML from Marker Toolbox Workflow Toolbox after processing comments locally, the compound clip has the markers at the right timecode! Though there is an hour of black before, like it wants to force a 1:00:00:00 start. The compound clip is not idea given they are notes, complicated for our multicams and for some reason VERY CPU heavy and this is on fastest fully loaded mac from last year.

REALLY appreciate all your time expertise and compassion, we r so close to solving, sorry to interupt your weekend!

MA

[mangelope]

and yes correct frame rate in Marker Toolbox Workflow Toolbox ie 23.98p

[mangelope]

Hi Chris,

Audio ONLY clips DO work to embed Premiere transcriptions .CSV into FCPX clips when we do the manual paste / process comments locally then "Apply Markers to Existing Final Cut pro Clip" method then use Marker Toolbox Workflow! We are using it today, thank you ;)

Unfortunately, we are unable to get the embedded markers to sync with multicams and standalone video clips. Maybe you can provide a VIMEO .CSV template where we can simply replace "timecode in" + "notes" column? We'd LOVE to find a cheat as we are trying to get as much done as we can this week before one of our team members leaves town.

Either way, we are SO grateful for all your help and this wonderful tool!

MA