WindchillLoader is a command line utility that can load data for any of the installed Windchill solutions. It can load base and or demonstration data for the selected solution either in interactive or unattended mode.

When you run the data load utility, you are prompted to log on as a user from the Administrators Group. If the user name you enter is not an administrator, then you are prompted to create an administrator user.

During the installation of Windchill Services, you defined a Windchill administrative user to the Web server. In this process, you will use this user name and its password for authentication.

If you are loading localized data into the database, then you must first set the date format to the server locale and then execute WindchillLoader. If you are not loading localized data, then you can skip this step (in which case the locale defaults to English).

By PTC convention, localized files include a locale extension. The locale extension is appended to the file name, but precedes the file type extension, for example, lifecycleInitRule_ja.xml. In this example, _ja is the locale extension. The table below lists the locale extensions:

Refer to the wt.load.WindchillLoader Class Arguments table in the section WindchillLoader Syntax for further details on the “-Locale” argument of WindchillLoader.

Prior to loading the database, the data files provided with this installation may require modification to set the date fields to match the locale setting of the server.

The default date format used in the data files is EN_US (MM/DD/YYYY). If the server locale is something other than this format, then all date fields must be modified to fit your locale. The data files are contained in the XML files which are located in the <Windchill>/loadFiles directory. You only need to consider the XML files relevant to your installation.

To locate the dates that require modification, use an editor that can perform expression matching on the data files. Using this editor, execute the following expression to find the dates that require modification:

[0-3]?[0-9]/[0-3]?[0-9]/[12][90][0-9][0-9]

This expression will find all entries that match the default MM/DD/YYYY pattern. This expression will also find all entries that match the DD/MM/YYYY pattern.

Review the information in this section to familiarize yourself with the syntax of the WindchillLoader and the examples. After you have reviewed the material, you should be ready to load the Windchill database.

You may have installed only one Windchill solution or multiple solutions consecutively. Perhaps you installed one solution and then at a later date installed another solution. The WindchillLoader will support all of these scenarios. In other words, you can load the database to support the solution you initially installed, install another solution, and then load the database for the second solution.

The WindchillLoader is run from the command line under the direction of the windchill command.The WindchillLoader command syntax is:

Where [class args] represents the required and optional executable options.

The following information provides an example of how to use the WindchillLoader command during a Windchill installation:

The following data load scenarios could exist:

This section describes how to manually load the base data for the first time if you opted not to allow the PTC Solution Installer to load it automatically:

On Windows: