This article explains the pros and cons of 4 options you can use to export historical data from Workfront.
AtAppStore, a Workfront certified partner, has an easy-to-use app that allows you to download your data. This app also includes a viewer that allows you to easily view your data.
Pros: All your Workfront objects are exported, including the custom fields. The interface of the Viewer is easy to use and read, and it’s easily importable in a MS Access Database.
Cons: Documents are not exported. You will have to download them separately. For more information, go to http://www.atappstore.com/App/snapshot-to-msaccess/Default.aspx.
Your Account Executive can 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 AOS 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 AOS 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.
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.
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.