-
Automated conversion of spreadsheet clip logging data
I recently wrote a Python script to import clip logging data that my clients had entered into a Google spreadsheet.
Export the spreadsheet data as a CSV file, do a tiny bit of cleanup in a text editor, and run the script. The script converts the CSV entries into an XML file of an FCP bin containing all the clips, with the Clip Name, Reel, Log Note, Description, Master Comment 1-4, et al columns populated with the data from the spreadsheet. Import the XML into FCP, reconnect the media, and viola, all the logged clips are right there.
Caveats:
(A.) The script is designed for a file-based workflow, as the footage for the current project originated on an EX1. It could theoretically be expanded to include TC IN and OUT for tape-based logging, but I’d leave that up to you.
(B.) It’s a command line script with no GUI. If you’re comfortable typing something like
python csv2xml.py path/to/loggingdata.csv path/to/mynewbin.xmlin the Terminal, then check out the script: https://johnpilgrim.net/color/csv2xml.html
Feature requests are welcome, but please be circumspect that this is simply a quick in-house workflow tool that I’m sharing, not a commercial product. I will keep working on it as time permits. Better documentation is the first task!
Cheers,
John
SF, CA -
0 Replies
Sorry, there were no replies found.
Reply to this Discussion! Login or Sign Up