Skip to content

Export form

Marius Agur edited this page Nov 23, 2018 · 2 revisions

Export form

The export form lets you copy the subscriber selection in JSON format, with configurable fields and hierarchy. By default all boxes are checked. Selection change instantly updates the output. Use the JSON and CSV buttons at the bottom of the form to switch between JSON and CSV output.

JSON format

Picture of the export form

Hierarchy settings

Include entities

If include entities is checked the export format will have entities as the top level of the hierarchy. If messages are included they will be listed as children of their respective messages. If messages aren't included then all subscribers from the selection will be listed as children of their respective entities.

Include messages

If include messages is checked then messages will be included in the hierarchy. Selecting only this will make messages the top level of the hierarchy, subscribers are listed as children of their respective messages.

Subscriber attributes

Check boxes to include the different subscriber attributes.

Message attributes

Check boxes to include the different message attributes.

CSV format

Picture of the export form

In CSV format the default separator is tabulator, which can be pasted directly into Microsoft Excel without having to use the text-to-columns function. Attribute filters are comma separated by default, but will change to semicolon if comma is chosen as the main separator.

Include headers

Toggle to include or exclude a header row

Subscriber attributes

Select and deselect the attributes you want to include in the export format. Selection instantly updates the output window.

Separator

Chose the separator for the CSV format. Tabulator is default and will allow pasting into excel with automatic column and cell separation.

Tab

Tabulator separator allows automatic paste into columns. Attribute filter is separated by comma.

Semicolon

Semicolon separator, commonly used, can be transformed to columns in excel using the text-to-columns function. Attribute filter is separated by comma.

Colon

Colon separator, commonly used, can be transformed to columns in excel using the text-to-columns function. Attribute filter is separated by comma.

Comma

Comma separator, traditionally used, can be transformed to columns in excel using the text-to-columns function. Attribute filter is separated by semicolon.

Data export area

Multiple lines of text, no text wrapping. Choice between indented JSON or CSV representation of the subscribers according to the current checkbox selection.