Export historical data from Adobe Workfront: Pros and cons
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.