Hello! Just wondering if anyone knows if it's possible to export ALL Workfront project templates as excel files using Fusion. At our company we need to keep a copy of the xls file as a source of truth. I've been exporting them all individually as they change but would really like to find a way to just export them all at once.
Admittedly, I haven't spent a lot of time looking into it
Thank you!
Views
Replies
Total Likes
Hi @amybillmayer,
Hmm. You got me thinking...
Although not (yet) listed as a standalone entry in our www.atappstore.com catalog, as one of the first steps in our Workfront Merge (or Split) service, we run our Merge Validator solution to compare the Source instance against the Target instance in order to (literally) highlight any differences using the Excel file it generates.
By default, the Merge Validator includes The Basics (i.e. Overview, Statuses, Priorities, Severities, Job Roles, Expense Types, Hour Types, Groups, Teams, Schedules, Parameters, Parameter Groups, Custom Forms, Companies, Portfolios, Programs, and Projects). Each object has its own tab in the Excel File comparing the Source data on the left, the Target data on the right, with any differences (missing or changed) highlighted in yellow. Here's an example of the Priorties tab:
Once we've conducted a Workfront Merge (or Split), we run the Merge Validator again to see "what made it", but in addition to The Basics, also turn on some other options...two of interest that twigged when I read your requirements being Template Task Dates and Template Assignments. Here's what it looks like, with those options selected:
Following this line of thought, I hopped into my preview environment (which was sync'd over the weekend from my production environment) and made a few changes to the Templates (namely deleted one, renamed one, changed a duration on a Template Task, deleted a Template Task, and added a Template Task with Assignments). I then ran the Merge Validator with the settings above to capture the data (and highlight the data) in a similar fashion.
Here's where I'm going.
I suspect that like you, many organizations would be interested in monitoring changes within Workfront over time for auditing / regulatory purposes. For such organizations that also have a client refreshable Sandbox environment (e.g. SB02), I'm imaging the following:
If you or any others reading are interested in repurposing the Merge Validator in this manner, I'd be happy to chat further via doug.denhoed@atappstore.com.
Regards,
Doug
Views
Replies
Total Likes
There is no way to batch-export all templates as XLSX in Workfront, nor is there a "export report" action in Fusion.
So I looked into the calls the UI makes and... and we can emulate it. But the scenario is not for the faint-hearted
To do this my scenario
- creates a form where you select templates and the view to us (all based on the currentUser access)
- upon submission, calls the export API and retrieves the binary
- uploads to the backup project (and creates the task if it doesn't exist)
Ping me at sven.niemetz@ibmix.de if you want to tackle this.
My custom dashboard
The Backup project
Glance at the scenario
Views
Replies
Total Likes