Adobe Workfront Fusion is an incredibly useful tool that allows you to automate your processes so that you can reduce repetition and focus on what’s important. In this upcoming Coffee Session scheduled for June 15th at 8a PT, come join us for an exclusive opportunity to ask our in-house experts on anything related to Workfront Fusion!
This text-only event takes place here in the Workfront Experience League Community. Post your burning questions, hot tips, key takeaways, and let’s chat about them! Our experts will be interacting live for that hour, but the conversation can continue!
For some guidance, here are some sample topics you can ask the in-house Workfront Fusion expert team about:
Note: If you cannot make the live Q&A, that’s okay! Ask your questions in this Community thread now and your question will be answered in the order that it was received.
REQUIREMENTS TO PARTICIPATE
Andy Hess @AndyHess
Experienced IS Professional with a strong history in Retail, Wholesale & Finance. Skilled in Business Administration & Process, Database Administration, Business Intelligence, and Integration Strategy. Focused on helping clients integrate Adobe Workfront into their enterprise technology landscape by setting realistic expectations and developing long-term roadmaps for integrations.
Ewan Hruska @ewanh
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Well folks....that's a wrap!
Thank you for reaching out to us and we look forward to catching you next time. We will make every effort to follow up with any followup responses or anything posted at this point or before.
@AndyHess would you be able to 1) step through the process of setting up a data store in Workfront (vs Fusion), and 2) give a short example showing one at work in a scenario please. Along with 3) any best practices you can suggest to make it as riskfree as possible (i.e. what are the possible risks, what are the symptoms when they are realized, and how to protect against them)
This is a great question to get the thread started Skye,
Data stores should be thought of primarily as temporary storage, or parameterization tables, not necessarily as permanent logging or large scale data use cases. To create one, think of this as 2 steps, of which both will typically occur within the scenario creation operations. To start simply select a datastore module and select Add, provide a name and then the most important step, Add or select a data structure. It is the combination of the Data store and Data structure, that create the object. If you forget a row in the data structure, you can simply go back to any Data store module and select Edit from the drop down and add rows.
One example I just setup was to capture a triggering event from a 3rd system, a Salesforce Opportunity Stage. The reason I want to capture it, is that in some cases we have to hold processing the transaction > create a Workfront project until a secondary field is filled out. So in effect, track the integration from Salesforce and leverage the datastore to 're-try' processing until all fields are properly managed in Salesforce. This technique will use 3 scenarios
#1. A Watch Field triggered event to watch for a Salesforce Opportunity Stage to reach a certain stage. This scenario will add every intake at this stage to the datastore where the key=OpportunityID, then a text column for status, and a date Changed field to timestamp the event. Every new record has the status of 'Pending'. In this scenario we submit to a subroutine scenario
#2 The subroutine scenario that uses a Fusion Webhook module as it's trigger. This scenario actually processes the transaction and creates the WF Project. When successful changes the status field to 'Processed' or perhaps a failure message
Then #3 a scheduled event that searches (iterates) on all records not 'Processed'. This scenario re-submits to scenario #2 which will either succeed due to the fields being managed finally in Salesforce, or leaves in a holding stage.
The gotcha, make sure in scenario #3, you delete 'Processed' records older than 90 days old to prevent growth of the data store. Remember you only have 100MB to play with so use your storage wisely.
One thing I would add is it is possible I missed the general premise, of using Workfront itself as a Data store. So following up with a basic response there.
This use case has more limitations and would not work in the example above, as Workfront as a Datastore's use case is solely for parameterization or itemization. Whether we use a series of Issues, Tasks, or Expense objects depends on the use case. One of the best reasons to use Workfront as an itemization object for a Fusion process will involve when we need to create multiple objects or have a single object rendered with multiple lines. One of my favorite use cases was with a client that needed to produce different video shorts (commercials) in different languages, frame sizes, lengths for each asset. So to do this we would use the Issue object on a given project as a itemization data store that Fusion will iterate through to then push multiple tasks to the video editing platform pre-loaded with all of the requirements in one process. The draw back.... hmm... this one is so effective and dynamic not sure I have one.
Views
Replies
Total Likes
Hi, Andy.
Finding this thread 7 months later, but I am in dire need of some assistance and I believe you have set up this exact scenario based on the above information.
I am attempting to create a Fusion Scenario that does the following:
1. Create a Workfront Project based on when a Salesforce Opportunity STAGE is changed to the status as “Closed Won”
I have been able to complete the remaining flow & read the opportunity & media brief information for the Project to be created in Workfront, however, I am running into a key problem of not understanding where I select the opportunity "STAGE" to trigger a project at "Closed Won"
Please let me know if you have any observations or next steps I need to take (hopefully not having to create a CSV and there is a more automated way to complete this work)
Views
Replies
Total Likes
We have been using Fusion for 4 years now and have 14 active production scenarios at a time, another 9 adhoc production scenarios, and numerous in development (organized in folders). Do you have any recommendations on how to document and organize the data within those scenarios for external and internal users? I often am asked "If I change this field, will it break fusion?" - I can often answer based on my own memory but if I am out of office, or as we start to have others build in Fusion I have become more unsure. Thanks!
Hi @DanielClarke ,
We have developed a standard Design Document that we use to capture the following:
In addition we export a copy of the blueprints.json (using the ... menu) and record a video of us walking through the scenario module by module. Curious if others in the community use other things?
It would be an awesome enhancement for Fusion to support some exports/notes of the design. It would also be great if there was a way to bulk export all of our scenarios (or at least by folder/live status) - so that I don't miss one as I click through them.
From a documentation standpoint, I've created slide decks for our key scenarios that include screenshots and key notes as a reference.
@AndyHess We've been Fusion users for a couple years now. We have seen a tremendous time savings on the automations just Workfront to Workfront today. We are starting to explore using the webhook to connect to other tools.
My questions are:
Hi Kimberly,
I'll answer a few of these.
Views
Replies
Total Likes
Hi @AndyHess,
We have been using WF for almost half a year now. Right now we are in the middle of considering Fusion to integrate and automate the vital processes we have.
I have been looking at the available OneDrive modules for Fusion and it looks like we are able to set up actions to upload, delete, get files and etc into OneDrive. Reference: https://experienceleague.adobe.com/docs/workfront/using/adobe-workfront-fusion/fusion-apps-and-modul...
These look like things that we can do inside OneDrive, for example to upload a certain file into OneDrive after it has been uploaded into Workfront.
My question is, is there a way that these action modules can be reversed? Our situation is that we would want to automate a process where a file is automatically uploaded into Workfront task level after it has been created or updated inside OneDrive.
Appreciate your feedback on this. Thank you!!
Views
Replies
Total Likes
HI Taufiq,
I would suggest that one of the best ways to manage Fusion and OneDrive is to switch your mindset a little, and have Fusion automatically create OneDrive folders in a dedicated drive space, for each project created, then create that folder in Workfront. We suggest that you also leverage the native OneDrive product integration for documents as part of this.
Once that is performed, when the user uploads the document to Workfront, have them select this OneDrive (remote) folder. Doing this will allow the Workfront Native connector to push that document into the OneDrive remote folder and it actually never exists physically in Workfront.
Specifically to your point, having a remote folder in WF, for this document that was uploaded from OneDrive, it will not automatically be available in the WF object where the remote folder is created by Fusion.
Hi @AndyHess
Thank you for your reply! I would like to confirm with you further. Since the document uploaded will not be appearing in Workfront but will be in remote folder of OneDrive instead - What would someone who needs to look into the document in the project need to do?
Is there a link to the remote folder provided in Workfront for everyone to go inside the folder and look at the documents?
Appreciate your reply on this. Thank you!!!
Views
Replies
Total Likes
HI Taufiq,
In Workfront, it would look like any other document inside a folder.
The folder itself will have a icon next to it indicating that it is a remote folder, as the user descends into the folder, they will be shown the contents of the remote folder and the files will look like they are present in WF, but like the folder, will have an icon next to them indicating that it is a remote document.
All actions appear as though the user was in WF, but in reality occur remotely.
The only caveat is that the accessing user must have credentials in the remote system, and rights to these folders.
Cheers!
Views
Replies
Total Likes
Hey Andy,
This is perfectly clear to me. Thank you for your insightful input. We will definitely consider this.
Appreciate your help.
Regards,
Taufiq
Views
Replies
Total Likes
@ewanh or @AndyHess can you walk through the basic process of how to set up a scenario that would take information from a csv file that contained project name, field 1, field 2, etc.. convert those to projects, placed into a new program within a portfolio each time the document is uploaded.
the walk through would be the team takes an exported csv file from a different system, uploads that file to portfolio documents section, fusion converts those into projects and places them into a program within that portfolio.
We just built this very thing @alferaj16! Downloading CSV, checking for duplicate projects, gathering required project data, validating addtl info from Salesforce, creating project from template, making assignments, and creating a supplemental issue on the new project.
Biggest headache was confirming/gathering all the required data to setup the project and fill in the custom forms.
Happy to discuss if Andy and Ewan can't dig in deep!
I have one like this as well and it's amazing how quick it streamlines the process.
That would be great to discuss this further!
Views
Like
Replies
Views
Likes
Replies