About Data Loading Utilities
In addition to the demonstration data that PTC provides, you may also have legacy data that you would like to add to the Windchill database. PTC provides two utilities to load legacy data:
• LoadFromFile—A command-line utility used to load a single, customized data file into the Windchill database
• LoadFileSet—A command-line utility used to load multiple, customized data files into the Windchill database
In both cases, the data files must reside on the Windchill server.
When performing a large bulk load of data, performance can sometimes be inhibited by queries and updates to the RecentUpdate table. In this situation, updates to this table may not be desirable. You can improve performance by disabling updates to the RecentUpdate table during a bulk load. To do so, set the following property in the wt.properties file:
wt.recent.disableRecentUpdateCreation=true
For information about which object types require the use of the import/export framework, see When to Use LoadFromFile and Import/Export.
 |
The load utilities only process XML files. The CSV2XML utility is used to convert CSV files to XML-formatted files. If your data is CSV-formatted, you can reformat it to XML using the CSV2XML utility before loading the data into the database. For more information, see Converting CSV Files to XML Format Files.
|