Changes

Jump to navigation Jump to search
339 bytes added ,  01:43, 20 October 2013
CSV is converted to XML as follows:
# * The resulting XML document has a {{Code|<csv>}} root element.# * Rows are represented via {{Code|<record>}} elements.# * Fields are represented via {{Code|<entry>}} elements. The value of a field is represented as text node.# * If the {{Code|header}} option is set to {{Code|true}}, the first text line is parsed as table header, and the {{Code|<entry>}} elements are replaced with the field names:## ** Empty names are represented by a single underscore ({{Code|_}}), and characters that are not valid in element names are replaced with underscores.## ** If the {{Code|lax}} option is set to {{Code|false}}, invalid characters will be rewritten to an underscore and the character’s four-digit Unicode, and underscores will be represented as two underscores ({{Code|__}}). The resulting element names may be less readable, but can always be converted back to the original field names.# * If {{Code|format}} is set to {{Code|attributes}}, field names will be stored in name attributes.
In the Database Creation dialog of the GUI, when the CSV parser is selected, the ''Parsing'' tab demonstrates the conversion of CSV to XML and the effects of the single conversion options.
 
If {{Code|format}} is set to {{Code|map}}, the CSV data will be converted to an XQuery map:
 
* All records are enumerated with positive integers.
* By default, all entries of a records are represented in a sequence.
* If the {{Code|header}} option is set to {{Code|true}}, a map is created, which contains all field names and its values.
==Options==
Bureaucrats, editor, reviewer, Administrators
13,550

edits

Navigation menu