using a CSV file to add markers

Question

Level 1

4 points

using a CSV file to add markers

I do a lot of sports video editing. A new iphone app just appeared in the app store that allows you to tag events which are in sync with the games you are filming. It outputs as a CSV file. High end sports analysis software allows for CSV files to be imported and connected to a video file, is this possible in Final Cut Express or Pro...?

Ideally, I'd just like the file to show up as markers, or event better clip it into sub clips from the CSV file. Would save a lot of time editing.

Many thanks...

MacBook Pro, Mac OS X (10.6.5)

Posted on Nov 17, 2010 7:34 PM

Reply

Answer 1

Studio X

Level 7

27,229 points

Nov 21, 2010 9:54 AM in response to csacsa

Final Cut Pro imports and exports projects as XML files. I don't think you can bring in markers - even as XML files - without someone writing some 3rd party hack.

What editing software do you use now?

x

Reply

Answer 2

Meg The Dog

Level 6

13,880 points

Nov 21, 2010 2:07 PM in response to csacsa

Hi - There is a way to get that kind of info into FCP, although I am not sure it would work for markers or subclips - just clips only, I believe. But you could include some metadata. I am not sure it would be worth the effort, but . . .

You would take your CSV file, open it in Excel and reformat the information to conform to the format of FCP's Batch List, then export that from Excel and then import that file as a Batch List in FCP.

You can get information about Batch List formatting here:
http://blog.surrealroad.com/archives/2008/final-cut-pro-batch-list-specification /

and it appears they are readying a project management software package here:

http://synaesthesia.surrealroad.com/features/

Hope this helps.

MtD

Reply