-
Spreadsheet for Logging w/Sequence Markers on Any Computer
I am working on a documentary and want to split the logging duty with my producer for the many interviews we are shooting. The only trouble is that he has an old PC and no knowledge of FCP. This spreadsheet will generate XML code to add the sequence markers and notes to your FCP sequence, allowing anyone with the raw footage, audio or video, and this spreadsheet template the ability to add notes that will show up as sequence markers in Final Cut Pro. (It currently only works with 24p projects but it could be modified to do 30p or any other frame rate).
Download the xlsx file here: https://www.robdavisphotography.com/logging_template.xlsx
Instructions:
1) Export audio or video of your sequence in Final Cut Pro.
2) Make sure you have at least one sequence marker on your timeline (you’ll see why in a minute). Export a XML file from your sequence (File>Export>XML).
3) Give the logging template and the raw audio/video to your producer/client and have them fill out the “LOGSHEET” sheet with the following…
a)Timecode: 4 columns for hours/minutes/seconds/frames (24p only)
b)Name
c)Comments
d)Marker Color: you have to enter the RGB (Alpha/Red/Green/Blue). Red, Yellow and Green are listed at the top (they are all green by default).The frames column will fill in automatically–do not change it.
4) Have the producer “save as” and send you the file.
5) Open the file and click over to the “CODE” sheet
6) Do a select all and then copy it to the clipboard
7) Open the xml file you generated from your sequence in any text editor. Find the code for the marker you made earlier. It will be all the way at the bottom and has ‘marker’ tags.
8) Select all the text from the first [markers] to the last [/markers], except with this bracket: < (the forum will think it is code and it won’t show up if I actually type it) . Paste your new code over it.
9) Save your XML file.
10) Bring your XML file back into Final Cut Pro. (File>Import>XML or just drag the xml file to the FCP icon in your dock)
Note: More than 70 markers will require two separate spreadsheet workbooks. (I only coded 70 lines). This is a beta version so watch out for mistakes. I was able to import all the markers on my test.
-
2 Replies
-
Sounds cool, Rob. Looks like you need a user/pass for the link you posted.
-
Sorry—I forgot I added the password protection.
Download it here: https://spreadsheets.google.com/ccc?key=0AobbqL1qxEefdENNRTRSV2ZENjhKekhSelp4d0U0dHc&hl=en&authkey=CNGbqZEF#gid=0
Reply to this Discussion! Login or Sign Up