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.
Conversion of XML
files directory to CSV files directory
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
Conversion of CSV
files directory to XML files directory
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)