Export to CSV
XML is the default format for export. To be able to export Planon ProCenter data to CSV, data transformation is required.
Planon ProCenter features a default CSVWriterWorker that can read and transform XML into CSV.
| The export process comes with a default FileXMLWriterWorker that transforms a POJO to XML. However, to be able to further transform the XML to CSV, you must replace the default FileXMLWriterWorker with the POJOToXMLStringWorker. |
Typically, the order in the XML is used for displaying the fields. If you want a specific order, in the Additional parameters box, specify the order by using the “columns=” parameter followed by the field names.
When running this export definition, the Planon ProCenter data is written to a CSV output file: