Creating client reports from Shotgun project data

Hello,

At our studio, we often generate reports to send to clients, which include shot data relating to the delivery of the project. At present we query data on Shotgun and input it to an Excel sheet, either manually or via a script. We would very much like to automate this process and generate reports straight out of the Shotgun web app. Is there a way to do this and/or any best practices to go about it?

Any ideas would be appreciated!

3 Likes

I found this useful article: Help

Wondering if there’s any way to export a report page or share it externally?

3 Likes

Hey Viktor,

I am glad you found that doc. I was about to link it here as well.
The is a really good way how to create a customised visual overview to follow up on the project status and share the information.
You can design it as you wish, every graft is interactive and you can export/share them in different formats ( like PDF)

3 Likes

Hi Linda,

Thanks for your comment! Yeah, playing around with a visual design overview page now, it seems to be flexible enough for our purposes. How would you go about exporting/sharing these?

3 Likes

Hey,

So here is doc with videos and explanations how to customize and save the overview in different formats. :smiley:

Cheers,
Linda

4 Likes

@Linda thanks for the doc. It’s very useful, but I still cannot seem to find a way to export my entire page to PDF, as far as I can see the doc only refers to exporting graphs as images and other formats. Could you please specify if/how this can be done for the entire visually designed overview page? Thanks!

2 Likes

Hey @viktor_petrov,

Yes, you’re correct, the export to .pdf is just for individual graphs. A cheeky hack if you want to make a .pdf of the whole page is to use the browser print option and save as a .pdf.

4 Likes

@DavidMason thanks for chiming in. Right, I figured I could do that, but as you say it’s hacky and not ideal since users would have to manually select the printable area as default printing from the browser includes the Shotgun header with all the different navigation pages. Also, some graphs disappear this way…

It would be ideal to just have an export button on visually designed overview pages so these can be easily exported as PDFs. I’ve submitted this as a request to the Shotgun road map - hope it’s simple enough to implement soon :slight_smile:

4 Likes

Hey Victor,

Yep, it is not the smoothest way at the moment, but at least there is a workaround. So thank you for submitting it to the roadmap and our team will surely consider it :slight_smile:

Stay safe and happy Friday!

2 Likes

Joining this request, this feature will be highly appreciated, mainly for the ability to be able to use thumbnails/images in the PDF, and maintain the visual look of the page.
Or even just the spreadsheet but that will also include the Thumbnail in the cell

Was this considered since this post started?

Thank you,

1 Like

Just bumping this thread as the ability to produce and export controllabel reports such as delivery sheets has been sorely missing for me for 11 years now.
Printing as pdf produces artifacts (e.g. overlaps the ShtioGrid logo with other parts of the page) and shows things I don’t watnt the client to see.
I would love to see the ability to design a print view that actually exports as expected.

1 Like

So I just spent a lot of time printing custom canvas pages wth graphs to pdf. As usualy the font comes through as light grey on white, which is impossible to read. No adjustments on SG side fixed this. So I ended up deleting the pages with graphs in the pdf, then exporting the individual graphs, then comping those together (while cursing a lot), the adding the result into the pdf that exported fine (the grid view).

Please, please, please add a modern, controllable and reliable way to producer report pdfs with graphs etc. It’s a massive pain every time I habe to send a report (which is every Friday).

Why has this been ignored for a decade now when it’s such an important step???

4 Likes

Totally agree with @frank - this is something we’ve now had to develop internally by populating HTML templates with data via ShotGrid API, just to generate a simple shot progress list report, for example. This is desperately needed for smooth client interactions.

1 Like

One of the biggest killers is that status icons are not included in “printed” pdfs.
How do people work around that?

I guess I could group by status but that works against keeping the shots in cut order. I guess I could make up a custom fiels that just shows text per status and update that via the shotgun event daemon to match the actual shot status field (in other words create a text version of the status field).
But really we shouldn’t have to do any of this just to be able to print a status report, right?!

1 Like