How can I export my data?
Updated
You have multiple ways to download your data:
- Data Dump file (available only for paying customers). ControlHub provides one full data dump per customer, prepared manually by our technical team. The data dump is in form of a zip file containing data in three potential formats (upon request): JSON format, CSV format, and Excel format. To schedule this data dump, please email our Support team before December 10th with your preferred extraction date . We recommend scheduling it after you stop using ControlHub, as any activity after that date will not appear in the data dump. Since this data dump requires manual intervention from a member of our tech team, data extractions need to be scheduled and requested before December 10th. Only one data dump is provided per customer with the following data:
- Company Requests report in Excel format. This report includes all of the Requests in your company, all the POs related to those Requests, all the Items related to those POs, and all the Bills/Invoices related to those POs. Please note that although this Report does not include detailed information about Budgets or Card Transactions, those additional reports are available for direct download by the user in ControlHub.
- PO raw data. A data dump in JSON and CSV format of your company's POs. Please note that this report is not user friendly, instead, it contains raw data that a technical person (i.e. Software Developer or IT professional) in your company can use for multiple purposes, such as exporting the data to another system.
- Receiving raw data. A data dump in JSON and CSV format of your company's Receiving Events (related to POs). Please note that this report is not user friendly, instead, it contains raw data that a technical person (i.e. Software Developer or IT professional) in your company can use for multiple purposes, such as exporting the data to another system.
- Excel Reports. You can use ControlHub’s built-in Reports and Export tools at any time to generate custom reports or download all purchasing data in CSV/Excel format. See this article for details: How do I download a report of all the purchasing activity in my company? and How can I see a report of my Card Transactions?
- API Pull. If your company already has our API feature enabled, your technical or IT team can extract purchasing data directly via API calls. This method requires code-based access, as there’s no user interface for API exports.
None of this reports include attachments, PDFs or Images. You can always download your attachments, PDFs and Images directly from ControlHub, one by one.
All data related to your company account (i.e. Purchasing Requests, POs, Audit Logs, Users, etc) will be permanently deleted after the ControlHub is sunset on December 15th.
