Automation Blocks - Multiple csv usage

Question

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:

Which table would you recommend to parse Sequence, or Shots.
How do you select specific columns in the "For Each Row/Column of Spreadsheet" block? Changing "with cell B as" to "my cell 3" didn't seem to work.
Is it possible to dynamically update the next dropdown based on the prior? i.e. Can a Sequences dropdown switch to a different show specific spreadsheet and be presented in the "custom input dialog with close options"? if the Show dropdown is changed?

I know this is a big question, and there are a lot of moving parts here, but any input or insights would be appreciated.

Mathias Moehl · Accepted Answer

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.

Mathias Moehl · Answer

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded