CSV export

Permission: Settings management

CSV export setting is used to set which node attributes and relationship attributes are exported when user uses the CSV export options in Graphlytic.

Configuration

  1. Left menu - settings

  2. In panel "Settings list" use icon "Update" for setting "CSV_EXPORT".

  3. Enter JSON configuration and confirm by pressing "Save" button.

Default configuration

Default configuration contains several default attributes to see how configuration should looks like. Probably this configuration doesn't match model of your data but can serve as example of short configuration.

  1. Left menu - settings

  2. In panel "Settings list" use icon "Update" for setting "CSV_EXPORT".

  3. Press button "Default" and store by pressing button "Save".

Automatic configuration

Automatic configuration is used to generate configuration which contains all existing node attributes and all existing relationship attributes.

This automatically generated configuration can be used as good starting point to create own configuration.

  1. Left menu - settings

  2. In panel "Settings list" use icon "Update" for setting "CSV_EXPORT".

  3. Press button "Automatic", wait for generator to generate JSON and store by pressing button "Save".

Description of configuration

Configuration is entered as JSON. Example of JSON:

{
"nodeProperties" : ["TYPE", "SUBTYPE", "_dbId"],
"relProperties" : ["TYPE", "SUBTYPE", "_dbId"],
"useSchemaTitles" : true
}

Explanation of JSON properties:

JSON property names used prior to version 1.12 are listed in parentheeses after the current name

Property

Values

Default

Description

Usage

nodeProperties

(nodeExportAttributes)

MANDATORY

Array of strings

 

Array of node DB properties which are exported. If set to null then all nodeProperties from Data schema are exported.

CSV export

relProperties

(edgeExportAttributes)

MANDATORY

Array of strings

 

Array of relationship attributes which are exported. If set to null then all relProperties from Data schema are exported.

CSV export

useSchemaTitles

(exportWithSchemaLabels)

MANDATORY

true, false

 

If set to true then title values from Data schema are used as column titles in exported CSV.

If set to false then property values from Data schema are used as column titles in exported CSV.

CSV export