XML <-> CSV conversion
The programs converting XML files to CSV files and vice-versa are placed in a subdirectory bin in the installation directory of D2000 System.
The conversion programs are following:
- xmltocsv.exe - converts the directory of XML files (or single XML file) to directory of CSV files
- csvtoxml.exe - converts the directory of CSV files (or single CSV file) to directory of XML files
The CSV files may be imported through Import from CNF.
| Kotva | ||||
|---|---|---|---|---|
|
...
Syntax: xmltocsv <xml_dir_or_file> <csv_dir>
The characteristics:
- number of CSV files depends on number of object types represented by XML files (by value of <Type> element in XML file)
- name of CSV file consists of the name of object type (CSV file contains its configuration), and a suffix csv (e.g. USER.csv)
- binary files are copied from XML directory into CSV directory under the name <object_name>_<nesting>.bin
| Kotva | ||||
|---|---|---|---|---|
|
...
Syntax: csvtoxml <csv_dir_or_file> <xml_dir> [ UTF8_ENC = TRUE | FALSE ]
The characteristics:
- number of XML files depends on number of objects existing in CSV files of CSV directory
- name of XML file consists of the object name and suffix xml (e.g. Admin.xml)
- binary files are copied from CVS directory into XML file under the name ObjectName_ValueOfAttributeOfRawDataVcsvType.bin
- the conversion to XML can be in utf-8 or windows-1250 encoding (default UTF8_ENC = TRUE)
...