CSV export
Required Permission: Settings management (Read more about Permissions)
Table of Contents
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
In the "Application menu" (top right) choose page "Settings"
In the "Application Settings" panel click on the "CSV_EXPORT" row.
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.
Main menu (top right) - Page Settings
In panel "Settings list" use icon "Update" for setting "CSV_EXPORT".
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.
Main menu (top right) - Page Settings
In panel "Settings list" use icon "Update" for setting "CSV_EXPORT".
Press button "Automatic", wait for generator to generate JSON and store by pressing button "Save".
Description of configuration
Configuration is entered in JSON format. Example:
{
"nodeProperties" : ["TYPE", "SUBTYPE", "_dbId"],
"relProperties" : ["TYPE", "SUBTYPE", "_dbId"],
"useSchemaTitles" : true,
"maxExportedRows" : 2000
}
Explanation of JSON properties:
Property |
Values |
Default |
Description |
Usage |
nodeProperties 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 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 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 |
|
maxExportedRows |
Integer |
10000 |
Maximal number of exported rows in any CSV export service. |
CSV export |