I've been working on using spreadsheets for a setup solution on a show to build a shot from a template and add info and footage from shot folders. Since I'm trying to make it usable for multiple shows as well, I was hoping to export out data from Shotgun to assist this process.
With Mathias' help, I was able to understand linking to my shot table and this was very helpful. I first wanted to share his recommendation to the community. This was the table export from Shotgun.
and this was Mathias' recommendation.
you can first set the variable “Show Name” to an empty list and then loop over all rows of the spreadsheet. For each of those rows, you then add the cell from the column you want to that list and after the loop finished, the list then contains all entries from the spreadsheet.
I'd like to expand this concept further, by using other tables to further drill down into the data along the lines of...
The only thing I've changed from the example blocks is "dropdown from spreadsheet" to "Show".
I can export a sequence table from a single show that has all of the shots listed in th 7th column.
Alternately, I can export a shots table from a single show that has pretty much all the data, but since these lists could get long with more than 200 shots, my thinking was to have the three limiters that would hopefully keep the lists manageable.
Having said all that, what I'm looking for is if you have any recommendations on:
I know this is a big question, and there are a lot of moving parts here, but any input or insights would be appreciated.
To read more than the first two rows, you need to click on the blue cog wheel of the block to add rows C, D,...
there is no way to only ready row A and E, for example, you have to read A,B,C,D,E then and ignore the values you don't need.
"my cell 1" and "my cell 2" are just the names of the variables which store the values of the sells. You can give them any names, but the names themselves do not change the row from which they are read.
It sounds like what you want to achieve is to have three dropdown lists Show, Sequence, Shot, such that when "Show" is changed, the available choices for "Sequence" and "Shot" are changed. This is not possible inside a single dialog with Automation Blocks.
The only thing you can do is
1. show a dialog where the user can only choose the show
2. from the spreadsheet read all scenes of exactly the show the user has chosen and show a second dialog to select one of those scenes
3. from the spreadsheet read all the shots of exactly the show and scene that the user has chosen in step 1 and 2 and show a third dialog where the user can now choose that shot.
This worked perfectly. Thank you!
I'd like to extend the functionality a little further. I work on projects in different phases of production. Previsualization, Postvisualizaton, and Finals. As shots progress, they will sometimes change numbers so we just denote a different "phase" and kind of start over. So I've got an column that denotes a sequence "Type" which is the phase of production.
How can I limit the drop down list to just sequences of particular type?
I'm thinking it's somewhere in the "in list" block, but I just don't know the syntax.
As always, any insight is super appreciated.
The easiest thing would be to replace the "in list insert at" block by an if statement with the "in list inside" inside.
Then in the if block you can add a condition to only add the sequence column entry to the list, if Sequence Type colum equals "Finals", for example.
I swear I'm not trying to be ignorant (not willfully anyway), but when impementing your recommendation, I get no Sequence list at all now. I've updated the variables to be a uniform to help be super clear.
I've included the console to show that "Sequence Type" is set correctly.
hmm, maybe the sequence name is not in column F or your spreadsheet?
To check what is going wrong I would add a Write to Console block before the if-statement and use it to print both "Sequence Type" and "column Sequence Type" to the console. Then you can check which values are actually equality-checked and why they never seem to be equal.
It was a Uppercase on one value and a lowercase on the other value. Fixed at the source of Export.
Great that you could solve it!
Write to Console is often a life saver if you have no idea what exactly is going wrong. The more experience you gain, the quicker you will be able to solve these issues and idendify exactly the point where things go wrong.