Advanced Reporting Help: Getting an image thumbnail on a request | Community
Skip to main content
SamanthaIsin
Level 7
November 1, 2021
Solved

Advanced Reporting Help: Getting an image thumbnail on a request

  • November 1, 2021
  • 2 replies
  • 2436 views

Alright, all you advanced reporting crazies! I've been wrestling an issue for a month now and am at a complete loss.

I need to generate a request report with an image thumbnail of the document uploaded with the request.

Not too hard to do with the following code and a little Fusion work:

displayname=Thumbnail

image.name=Link Project

image.valuefield=url

shortview=true

textmode=true

type=image

usewidths=true

valueformat=

I just take the previewURL from the doc and concatenate it with our instance URL to create a new URL which I place into the request URL and pull into the request report as an image.

However, the access keys to images stored in Workfront expire over time. This means my thumbnail appears only for about an hour - then it's gone. The concatenated link still works, but the image in the report disappears. Workfront Support recommends uploading my image to another place on the web and using that URL. I tried that and it worked, but uploading an image somewhere else and then pulling that link into a request it's too much for my requestors. They won't do that when there are other tools that are much easier (Airtable, MS Teams, etc.). The problem is that our creative teams work in Workfront and need a single source of truth.

My requestors are adamant that the image be included in the report/request view. They will kick and scream and find other tools to submit requests if I don't get this to work. It's what they're doing now and my creative team is chaos.

Workfront support is no longer any help. The system just doesn't cooperate that way.

SO! I need help - what other ways can I achieve my goal??

Goal: I need to generate a request report with an image thumbnail of the document uploaded with the request.

@Tanner DeVinny‚ @Dawn Henderson - inactive‚ @Anthony Imgrund‚

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

I was able to get this working on a task report a while back, so you might be able to get it on an issue report as well. I used the syntax from the large thumbnail URL. It looks something like this:

https://YOURDOMAIN.my.workfront.com/internal/document/thumbnail?build=&size=DOCUMENT_SHARE&documentVersionID=________________________

So maybe if you just put in the document version ID, that would work? (or maybe this just works for me because these are all JPGs?)

2 replies

Doug_Den_Hoed__AtAppStore
Community Advisor
Community Advisor
November 1, 2021

Hi Samantha,

That's a familiar but tough ask. We solved it in our Magic Reports and Editorial Calendar solutions (among others), but -- along the lines of what Workfront support mentioned -- had to build some special tech in order to do so.

Perhaps someone has a workaround, but until then (or in case not), thought I'd at least offer your misery some company.

Regards,

Doug

SamanthaIsin
Level 7
November 1, 2021

@Doug Den Hoed‚ As always I have to innovate complicated solves without using any of our budget 😭

Your company is much appreciated 😂

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
November 1, 2021

I was able to get this working on a task report a while back, so you might be able to get it on an issue report as well. I used the syntax from the large thumbnail URL. It looks something like this:

https://YOURDOMAIN.my.workfront.com/internal/document/thumbnail?build=&size=DOCUMENT_SHARE&documentVersionID=________________________

So maybe if you just put in the document version ID, that would work? (or maybe this just works for me because these are all JPGs?)

SamanthaIsin
Level 7
November 2, 2021

@Skye Hansen‚ What was your text mode to get that URL to display in a column?

skyehansen
Community Advisor
November 2, 2021

that's pretty weird. My thumbnail was still in the report that I made yesterday, plus nothing in the url I'm using references anything other than the doc version ID. I'm sorry your experience isn't the same :(.