Skip to main content

Export query results

Download item data in a standard format​

After creating a query in the Data Explorer app, you can export the results in a standard data format, enabling you to store and process the data in other software.

Before you start, make sure the query includes all the attribute columns you want to export.

Example item data exported as a CSV, viewed in Microsoft Excel
info

To import data into CausewayOne Asset Management, see Gateway in Asset Classic.

Export a query​

To export the results of the active query tab:

  1. Select Export results in the bottom toolbar. If the button is hidden, open the Overflow Menu.

  2. In the window that appears, select Export file type and choose one:

    • CSV - a widely compatible format that stores table data as lines of comma-separated values.

    • SHP - a popular format for storing geospatial data. It describes the location of geographic features as points, lines and polygons, with custom attribute data. To learn more, see Shapefile on Wikipedia.

  3. If CSV is chosen, select Export attribute header type and choose one:

    • Name (default) - attribute columns will be labelled by name, e.g. Installed Date

    • Code - attribute columns will be labelled by code, e.g. attributes_assetsInstalledDate

  4. If the query fetches geometry data, select Coordinate system and choose one:

  5. Export dates/times in system local time - if enabled, dates and times are converted to the time zone of your company project. If disabled, dates and times are exported in UTC+00:00.

  6. Select Save to start the export. When it's ready, your browser will download a zip file containing your exported files.

The Export window showing a chosen file type, attribute header type and coordinate system
info

While exports typically process in minutes, queries with lots of data can take longer. You can work on other things without interrupting the processing. When the export is ready, the download link is emailed to you.

Linked data​

If the exported query fetches values for any join attributes, they are stored in a separate CSV file (one per linked design/interface). Each linked CSV contains Predecessor data to help you reconstruct the relationships between the linked items.

For example, imagine a query that fetches street lights and their defects. For each parent Street Lights item, the query fetches any child items stored in their Defects attribute. For each stored Defects item, the query fetches the value of their Defect Number attribute.

The exported zip file contains two CSV files: one for items of the queried Street Lights design, one for items of the linked Defects interface. Each item in the Defects CSV can be matched to the Item ID of its parent Street Lights item, and vice versa.

Important

Due to the limitations of the shapefile format, exporting to SHP only stores data for attributes on the queried design/interface. Any linked attribute data will be excluded!