Exporting Results to CSV

Exporting Results to CSV

Dataplane report exports in Comma Separated Value (CSV) format are suitable for batch processing or for importing into other applications that only accept CSV-format files.

To export the currently viewed Dataplane report, click the Export toolbar dropdown and select CSV Format. A version of the report results in the desired file format will then begin downloading.

CSV Format Details

When exporting reports to a CSV-format file, note the following:

• only tabular results data is included. The plain-text CSV file format does not support graphic charts or any other richly-formatted data.

• by default a comma (,) is used to separate the individual fields on a line.

• character set encoding is always UTF-8.

• all dates are expressed in the ISO date format as "yyyy-mm-dd". For example, 2013-07-01 represents July 1, 2013. 

Customizing the Export

With a Dataplane Customizer Script, you can customize the CSV export on a report-by-report basis.

Here's the general syntax for a Customizer Script that sets a property of the CSV export:

customizeExport {
	format "csv" <property1> <value1> <property2> <value2>
}

The words format "csv" indicate you are customizing the CSV export format, and following that are one or more pairs of properties and their values.

For example:

customizeExport {
	format "csv" separator ";"			// export the file using semi-colons to separate values
}
 
customizeExport {
	format "csv" separator "\t"        	// export the file using tabs to separate values
}

Here's a list of the available properties and values that can be used to customize CSV exports: