Hi @Osama.Alim , welcome to the forums!
Sorry for the troubles there; let’s dig in. Are you just getting started with Shotgun, and have just signed up for a trial? Or, have you had a site for a while? Our templates change with new site spin-ups, so that’s why I ask.
Currently, there’s an order of operations you’ll want to follow while importing for Episodic. This will ensure everything is linked properly and imports smoothly:
- First, import your Assets.
- Then, import Episodes.
- After that, import your Sequences.
- Then lastly, import Shots to tie everything together.
Were you able to import 1-3, in this order, prior to importing Shots? If so, you can map the
sequence column to the Sequence column in Shotgun:
This is a bit odd. Can you pass along your excel spreadsheet to me in a DM? I’d be happy to investigate and report back. Sometimes there can be formatting issues that can cause strange errors.