Skip to main content
A
AA_139534383-Newcomer
3-Newcomer
November 10, 2025
Question

What is best option for Data Migration using load from file or WBM

  • November 10, 2025
  • 1 reply
  • 515 views

Version: Windchill 13.0

 

Use Case: I want to migrate bulk data for part with IBA attributes , equivalence link, and BOM what should be the best option for migrating the data into windchill. What are the limitation of Load from file.


Description:

I want to migrate bulk data for part with IBA attributes , equivalence link, and BOM what should be the best option for migrating the data into windchill. What are the limitation of Load from file.

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
November 10, 2025

Is it just parts? You might consider Import from Spreadsheet as you can load parts, attributes and BOM information in that manner. There are limits to this option but you can break this up into multiple loads. How much data are you looking to load? This has a big factor in which option you choose. There is some complexity with "Load from File" as your Excel files need to be translated to CSV and then to XML. You have to watch out for commas and special characters. These also need to be loaded from the server side so its less flexible to deal with. 

A
AA_139534383-NewcomerAuthor
3-Newcomer
November 10, 2025

No need to migrate around 20k parts along with the attributes and BOM.

Also import from file takes a lot of time I think  that wont work here.

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
November 10, 2025

Importing parts using Import from File will work for lots of hundreds of parts but validation can take some time. Anything too large just spins for a long time and pages can time out. Load from File (CSV to XML) might be your best bet. Remember this by default is all or nothing loads so any little hiccup or error 99% into the load will cause the entire load to undo. Its import to nail down load and ensure there is nothing that will cause a failure. If you break it up into chunks, just make sure you can keep track of where you are. There are also options to allow it to proceed if it finds an error (load what it can).

Best bet is to load all parts first then BOMs. Are you loading versions too or just latest version?

 

You also mentioned equivalence links? Let me know what you mean here.

 Lastly, you mentioned WBM, this would be advisable if you are migrating from and existing database where you want to build out mapping between the two.

Terms & ConditionsCookie settingsAccessibility statement