Export defines a set of dataset properties, which will be exported to a spreadsheet file along with the values of respective indicators. Each export must be referenced from it's parent view.
Export counts in all active filters and the map selection.
Syntax
This is one of the exports from the Retail Solution Demo. As you can see, a good description is important.
...
Export object syntax
Code Block |
---|
{ "name": "customer_ids_export", "type": "export", "title": "List of Customer IDs", "description": "Returns client IDs, Districts, Wards and indicators available in the view into CSV file.", "content": { "properties": [ "baskets.client_id", "district.districtname", "ward.wardname" ] } } |
Code Block |
Example of a dumped export
collapse | true
---|
Code Block |
{ "url": "/rest/projects/yufqzxkbiecj7jot/md/exports/g3v603i8m3tre30g", "dumpTime": "2018-01-30T13:48:17Z", "version": "8", "content": { "id": "g3v603i8m3tre30g", "name": "customer_ids_export", "type": "export", "title": "List of Customer IDs", "description": "Returns client IDs, Districts, Wards and indicators available in the view into CSV file.", "content": { "properties": [ "baskets.client_id", "district.districtname", "ward.wardname" ] }, "accessInfo": { "createdAt": "2017-11-13T14:12:57Z", "modifiedAt": "2018-01-30T12:48:18Z" }, "links": [ { "rel": "self", "href": "/rest/projects/yufqzxkbiecj7jot/md/exports/g3v603i8m3tre30g" } ] } } |
...
Export allows to set default output settings - output filename, file type, file format and header format.
...
Export with output object
Code Block | ||
---|---|---|
| ||
{ "name": "transaction_ids_export", "type": "export", "title": "List of Transaction IDs", "description": "Returns transactions ID, postcodes, lower super output areas, middle super output areas and value of indicators available in the view into a file.", "content": { "properties": [ "codepoint_plg.msoa11nm", "codepoint_plg.lsoa11nm", "codepoint_plg.postcode", "baskets.basket_id" ], "output": { "type": "file", "format": "xlsx", "filename": "Transaction IDs.csv" "header": "basic" } } } |
Key description
content
Key | Type | Optionality | Description | Constraints | ||||||
---|---|---|---|---|---|---|---|---|---|---|
| array |
| array of dataset properties, which will be present in the exported file |
| ||||||
| object |
| export output settings |
content.output
Key | Type | Optionality | Description | Constraints | ||||||
---|---|---|---|---|---|---|---|---|---|---|
| string |
| output type (at the moment, only |
| ||||||
| string |
| file format |
| ||||||
| string |
| custom filename |
| ||||||
| string |
| header format |
|
Visual representation
All project exports can be viewed in the export dialogoue. This dialogoue can is accessible by clicking the Menu button in the top left corner (), and selecting Export.
...
Exported file in a spreadsheet editor
...
Let's have an example. We have a dataset of branches like this:
branch_id | branch_name | city |
---|---|---|
10 | Branch Prague | Prague |
20 | Branch London | London |
30 | Branch New York | NULL |
The correct definition of the export would look like this:
...
In this case the metric values are correctly joined based on the primary key branches.branch_id.
The result would look like this:
branch_id | branch_name | city | number_of_employees |
---|---|---|---|
10 | Branch Prague | Prague | 100 |
20 | Branch London | London | 250 |
30 | Branch New York | NULL | 300 |
The incorrect definition of the export would look like this:
...
The result would look like this:
branch_id | branch_name | city | number_of_employees |
---|---|---|---|
10 | Branch Prague | Prague | 100 |
20 | Branch London | London | 250 |
30 | Branch New York | NULL | NULL |
NULL | NULL | NULL | 300 |