Import Assets and Shots

Now that we have our animated short film “Hyperspace Madness” created, we need a quick way to get data into Shotgun since we need to hit the ground running. You may have an asset breakdown, scene breakdown, or other document that holds information you would like to import to Shotgun. For “Hyperspace Madness”, we have an Asset Breakdown and Scene Breakdown.

Importing Assets

My Asset breakdown is a spreadsheet comprised of asset names, asset types, and asset descriptions.

Asset breakdown

First, navigate to the Project’s Asset landing page and display the fields you would like to import.

Manage columns

Next, export these fields to Excel so that the formatting matches, and copy/paste your Excel data into the new exported Excel sheet. You can delete the “id” and “Project” columns.

Export Excel

Then, copy the data (including the column headers) from your new Excel sheet, and select Import Assets.

Copy data

Import assets

Follow the steps to Import your Assets.

Importer_step1.png

Importer_step2.png

Importer_step3.png

Importer_step4.png

… and that’s it! Your assets now exist in Shotgun.

Assets

Importing Shots

You can swiftly import Shots following the same steps as Assets above, just from a Shots page instead. My Shot breakdown is a spreadsheet comprised of Shot names, descriptions, and cut information.

First, navigate to the Project’s Shots landing page and display the fields you would like to import.

Shot fields

Next, export these fields to Excel so that the formatting matches, and copy/paste your Excel data into the new exported Excel sheet. You can delete the “id” and “Project” columns.

Export Excel

Then, copy the data (including the column headers) from your new Excel sheet, and select Import Shots.

Shot data

Import shots

Follow the same steps you followed to import your Assets to Import your Shots.

Note that since you already had your Assets created in Shotgun from the previous import, you can link them directly to Shots via the importer.

Shots

Linking Shots and Assets together

Now that you have the things you would like to track imported into Shotgun, the next step is to connect them together. With these connections, you’ll be able to reference Assets that are in Shots and Shots that have specific Assets. You’ll also be able to see the statuses of Shots that may have Assets still in progress, and drill in on more information. On Assets, there is a field called “Shots”, and likewise, on Shots there is a field called “Assets”. This is a bi-directional field that is used to link the two together.

Link shots and assets

These fields will autocomplete results when the item exists in Shotgun, or you can create a new Shot or Asset easily from there.

New shot

Now that you’ve linked your Assets to Shots and vice versa, you have connected the important things and your Project and are ready to track.

Creating Shots and Assets individually (without the Importer)

Moving forward on your Project, you may need to add more Shots and Assets individually rather than import them. You can do this by clicking on the “+ Shot” and “+ Asset” buttons on their corresponding pages.

Add new asset

Add new shot

Follow