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.
When exporting reports to a CSV-format file, note the following:
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.
With a Dataplane Customizer Script, you can customize the CSV export on a report-by-report basis.
If you're not yet familiar with using Customizer Scripts in your reports, read through Customizing Reports with Scripts for some background and then return back here to get going.
Here's the general syntax for a Customizer Script that sets a property of the CSV export:
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.
format "csv" separator ";" // export the file using semi-colons to separate values
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:
Specifies the character to use as a field separator on each line of the file.
Any single character in quotes may be used. Common options are:
Use the following special notation to indicate a tab character:
Copyright © 2017 Arsenale Systems, Inc. · All rights reserved · Contact Us · Powered by Atlassian Confluence