Is there a way to access the menu 'export all shots' to a file using python script?
4 comments
-
Ben Hadden @Shani
RIght now, we don't have a function to export a .csv via the API, but you could use the find() method to return all Shots and then parse that list. Are you trying to backup data by exporting to CSV or some other format? Let us know a bit more about your use case and we can brainstorm on solutions.
-
Shani Turner Hi Ben-
Thanks for looking into this. Yes I am trying to back up specific pages in Python. Right now I'm doing it in a really crazy long way by getting all field values from all shots in shotgun and then (hopefully) can use pageSettings to recreate the specfic pages using the data save for all the shots. Is there a simpler way of doing this?
-
Shani Turner I mean backing up specific pages in shotgun through a python script:)
-
Ben Hadden Shani,
Exporting to Excel is actually one of the fastest ways to back-up data in Shotgun. You can export an entire entity's data by exporting to Excel (even if you're just displaying 25 records at a time), which will generate a list of all of the records along with the fields you have displayed on the page. Using Python is more flexible, which is probably why you're going that route, but Excel is certainly faster/easier. We'll be looking into ways to make the Excel export a one-step process for all of your data in the future. In the meantime, email support@shotgunsoftware.com if you want to keep chatting about going the Python route. We'll be standing by!