The export data dialog allows users to export the data from a table or from a SQL SELECT query as a text/XML/Html document. It also allows users to export the schema of one or more tables (and their associated data) as an xml document (*.schema)
Shown below is an example of the export data dialog :
If the data is exported as a text document, empty strings and null values will be treated equally without any distinction. So when you are importing these values, they will be imported as null.
Exporting the data as html will allow users to generate a html document showing the data formatted in html. This option is generally used only for display purposes, and is not supported for importing data using goat.
If the data is exported as an XML Document, the data will be exported using an xml schema.
Exporting as XML has several advantages :