Export data from related objects

Using the enhanced data export functionality to customize the data you extract from Skedulo.

Overview

The enhanced data export page offers the functionality available in the previous data export workflow, but also includes:

  • The ability to export data from objects related to the object being exported.

  • Improved user experience and performance.

  • Limits on the amount of data that can be exported in a single task. This helps with performance and interoperability with tools where the data may be viewed. Limits can be changed by contacting your Customer Service Representative, but by default, each export task is limited to:

    • Number of records to export: 200,000
    • Number of fields: 200
    • Number of filters: 10
    • Number of sort orders: 5

Export data without using a template

To export data from an object and its related objects using the new export page, do the following:

  1. In Settings, navigate to Data management > Data import/export.
  2. Click Create Task > Export.
  3. Under What object would you like to export data from?, click the drop-down menu and then click the object from which to export data.
  4. Under What field(s) would you like to export data from?, click + Add fields.
  5. Select the fields from which you want to export data. Note that the list of fields is grouped by object, with the object you selected listed first, followed by related objects. You can scroll down to expand related objects and select fields from them to include in your exported file. A screenshot showing the expandable sections for selecting fields to export.
  6. Click Save.
  7. Optionally select fields by which to filter and order your data. By default, you can configure up to ten filters and five sort orders for each export task. You cannot use the same field to configure multiple sort orders in one task.
  8. Click Create task.