Shot Sheet Maker

Version 3.9.0

Flame 2022.3+


Create shot sheets from selected sequence clips that can be loaded into Excel, Google Sheets, or Numbers..

Shot sheets can be created individually for each sequence or all selected sequences can be added to a

single spreadsheet as separate worksheets.


Install through Logik Portal or to manually install download here: Logik Portal Dropbox.

When manually installing from Dropbox download the entire folder in the desired version folder of the script to be installed. That folder should then be moved into /opt/Autodesk/shared/python.

Older versions of this script for older versions of Flame are also available through the Dropbox link.


Shot Sheet Maker Main Window

Shot Sheet Maker Edit Column Names Window


*** The First time this script is run in a new version of flame, it will need to install the xlsxWriter python module - System password is required for this ***

Sequences should have all clips on one track.


Menu:

Flame 2022 - 2023.1:

Right-click on selected sequences in media panel -> Shot Sheet Maker... -> Export Shot Sheet

Flame 2023.2+:

Right-click on selected sequences in media panel -> Export Shot Sheet

Updates:

v3.9.0 01.21.24

Updates to UI/PySide.

v3.8.0 11.16.23

Added ability to add Shot Frame In and Shot Frame Out to clip info column and column names.

Added drop down menus to add clip info to column names in Edit Column Names window.

v3.7.1 11.07.23

Fixed incorrect path in script path check error message.

v3.7.0 08.20.23

Updated to pyflame lib v2.

v3.6.0 06.26.23

Pressing return in the main window will now create shot sheets.

Updated script versioning to semantic versioning.

Updated xlsxwriter install for Flame 2024+.

Updated config loading/saving.

Fixed linux install problems.

v3.5 01.05.23

Misc bug fixes.

Error window will now pop up if the selected export path is not writable.

By using any of the following names for a column name, the corresponding clip info will be added to the cells in that column. For example, if you want to add the Shot Name to a cell, name the column 'Shot Name' and the shot name will be added to the cells in that column. Column names can be edited by clicking on the Edit Column Names button.

Shot Name

Source Name

Source Path

Source TC

Source TC In

Source TC Out

Record TC

Record TC In

Record TC Out

Shot Length

Source Length

Comment

v3.4 10.04.22

Updated menus for Flame 2023.2+

v3.3 08.03.22

Fixed bug where script would not work properly if 'Inclusive Out Marks' was selected in Flame Timeline Preferences. Thanks to KuleshovEffect for catching this.

Added Add Comment button as option for first column in shot sheet.

v3.2 07.21.22

Spreadsheets can now be created from multiple sequences.

When creating spreadsheets from multiple sequences, there is now the option(Create One Workbook) to create a single spreadsheet with all sequences added as separate worksheets.

Fixed export issues with 2023.1.

Messages print to Flame message window - Flame 2023.1 and later.

v3.1 03.25.22

Updated UI for Flame 2023.

Moved UI widgets to external file.

Updated xlsxwriter module to 3.0.3.

Gaps in timeline no longer cause script to crash.

Misc improvements and bug fixes.

Config updated to XML.

v3.0 05.28.21

Updated to be compatible with Flame 2022/Python 3.7.

Updated UI.

Added check to make sure sequence has only one version/track.

Added button to reveal spreadsheet in finder when done.

v2.2 07.15.20

Script setup now in Flame Main Menu: Flame Main Menu -> pyFlame -> Shot Sheet Maker Setup.

Window now closes before overwrite warning appears so overwrite warning is not behind window.

Better sizing of image column to match size/ratio of sequence images.

The following information can be added to the spreadsheet for each shot:

Source Clip Name

Source Clip Path

Source Timecode

Record Timecode

Shot Length - Length of shot minus handles

Source Length - Length of shot plus handles

v2.1 04.05.20

Fixed UI issues in Linux.

v2.0 12.26.19

Up to 20 columns can now be added through the Edit Column Names button.

Thumbnail images used in the shot sheet can be saved if desired.

Misc. bug fixes.