Converting CSV Files to XML Format Files

Before converting the CSV files, you may need to update the CSV file to match the definitions in the csvmapfile.txt file. The files must contain all of the data required (for example, containers) before they are converted with the CSV2XML utility.

Your installed Windchill environment consists of a set of containers that hold all of the administrative areas (known as domains), rules, and data that make up the context from which Windchill users work. Throughout the user interface, Context is used to identify where specific rules, domains, and data reside in the framework. However, to create this environment, you load containers. Because container is the label you see in the code, this topic collection uses the term container (rather than context).

PTC recommends that you create your test data using the CSV file format and then use the conversion utility to convert it to XML as it is easier to create the data and less error-prone in the CSV format.

The syntax for the CSV2XML utility is as follows:

windchill wt.load.util.CSV2XML -input<input file or directory>
-output<output directory> -root<specifies the root directory>
-help -encoding<encoding of the source CSV file> -mapfile <absolute
path of the csvmapfile.txt> -delimiter <user specified delimiter>
-preservespace [specifies if spaces should be preserved]

For more information, see CSV2XML Arguments.

The data load utilities expect to find the data files in the <Windchill>/src/loadFiles directory. If you use all the defaults, then the command is: