Export historical data from Adobe Workfront: Pros and cons

Last update: September 6, 2024

CREATED FOR:

  • Admin

This article explains the pros and cons of four options you can use to export historical data from Workfront.

Use one of our partners

AtAppStore (www.atappstore.com) has an easy-to-use app (their Workfront Snapshot solution) that allows you to download your data yourself. An optional viewer (their Workfront Snapshot Viewer solution) allows you to easily view your data offline.

  • Pros: All of your core Workfront objects are exported, including the custom fields and notes, all of which is then stored in an easily accessible MS Access database. The interface of the Viewer is easy to use and read. Extracting Documents is also available separately as a service, with the output organized into a logical folder structure that maps to each document (and optionally, its previous versions).

  • Cons: There is a technical limitation of 2GB of data, but AtAppStore allows you to purchase only what you need.

  • Costs: For more information, go to https://store.atappstore.com/product/workfront-snapshot/.

Request a Postgres data dump file from our Database team

You must submit a request to our Customer Support team, who will then submit a request to our Database team to export a database dump file (.dmp Postgres file) with your data. An additional request will go to our NOC team to retrieve all of your stored documents.

  • Pros: You get your entire data load, including custom fields, as well as documents that are stored in the system.

  • Cons: The database file is hard to read: there is no way you can read this file unless you upload it to a Postgres database and re-establish the relationships between the tables. The documents are stored on a separate file server and must be extracted separately using a separate process by the NOC team. In doing so, there is no organization to the documents, and they are all referenced by their GUID.

  • Cost: There is a cost associated with this download, depending on how long it takes the team to create the file. Check with your AE/ CAE for more information or to get this process started.

Export via Kick-Starts

Whether you have remote consulting hours or not, you can use one of our consultants to export your data in the form of reports or kick-starts, or you can run these reports yourself:

  • Pros: The reports are easy to read and can be imported in a variety of applications; they can be customized to include any groupings and views you’d like.

  • Cons: Documents will have to be downloaded separately.

  • Cost: It is free if you can run the reports yourself (all you would need is a system admin login), or if you can use remaining remote consulting hours. If you are interested in purchasing remote consulting for this, please talk with your AE/CAE.

    For more information about using Kick-Starts to export data, see Export data from Adobe Workfront via Kick-Starts.

Use our open API

if you have the right resources in your organization, they can build a custom API to retrieve all your data from Workfront:

  • Pros: You are in control of what exports from the system.

  • Cons: The time is spent on your side, and you will have to find resources to code the API and perform the export.

  • Cost: Internal to your organization.

More help on this topic

Previous pageExternal license missing in access levels
Next pageFields are invalid: emailAddr

Workfront


Learn: Automating Workflows with Workfront Fusion - Unique Use Cases in Action

Workfront

Tuesday, Mar 4, 6:00 PM UTC

Looking for creative ways to use Workfront Fusion to solve business challenges? Join Pan Shahbazian of Starbucks as she shares three unique use cases that can transform your workflows.

Register

The Perfect Blend: A New Era of Collaboration with AEM and Workfront

Adobe Customer Success Webinars

Wednesday, Apr 2, 5:00 PM UTC

Explore how Adobe Experience Manager and Workfront integrate to help teams move from ideation to delivery without the usual bottlenecks, ensuring content is organized, on-brand, and ready to go live faster.

Register

Unlocking Content at Scale with Havas POP and Adobe GenStudio

In-person | Session | General Audience

In today’s fast-paced market, a brand's relevance is directly linked to its latest content. With a network of over 23,000 professionals...

Tue, Mar 18, 4:00 PM PDT (11:00 PM UTC)

Register

How Adobe Uses GenStudio to Supercharge Its Global Marketing Organization

In-person | Session | General Audience

Get an inside look at how Adobe’s global marketing organization is using Adobe GenStudio to build a world-class content supply chain....

Tue, Mar 18, 4:00 PM PDT (11:00 PM UTC)

Register

Connect with Experience League at Summit!

Get front-row access to top sessions, hands-on activities, and networking—wherever you are!

Learn more

Register now

Register to learn something new

WORKFRONT

Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.

Register