How to export shots table to an Excel file with thumbnail image ?

[YuChen]

Hi support team,

I tried to export the shots table under "Tasks" panel to an Excel file and expect the thumbnail image of each shot would appear in first column. Of course this doesn't happen and it looks like this only happens when exporting table as a PDF file. I was wondering if there's any ftrack API that can help customize exporting behavior. Do we have any API that can help ? 

Thanks.

[Andrew Lawrence]

Hi @YuChen

Thanks for writing in, we'll be happy to help out here. You've correctly pointed out that unfortunately exporting data to Excel will not include the thumbnail as an image, as we currently don't support image formats when exporting to Excel.

That said, it should be possible to write something with the API to grab a thumbnail from an AssetVersion, and then you can process that accordingly, for example

t = session.query('select thumbnail from AssetVersion').first()
location = session.query('Location where name is ftrack.server').one()
url = location.get_filesystem_path(t['thumbnail'])

If you want scaled-down thumbnails, as shown in the web UI, you can use the following to get back a signed URL to the thumbnail.

select thumbnail_url from AssetVersion

Hope this helps, but if you have any further questions don't hesitate to give us a shout. 

Cheers,
Andrew