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)