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

[AA_13953438]

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.

[avillanueva]

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. 

[AA_13953438]

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]

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.

[AA_13953438]

From Load from file option is there any option to load IBA attributes along with other attributes.

I want to load Design parts (Upstream Parts), View part(Downstream parts) to connect upstream to downstream, need to load the equivalence link as well.

[avillanueva]

https://www.ptc.com/en/support/article/CS195189?source=search

It complex to create files but doable. Order matters in that you load the part, then its attributes, end the part and move on to next one. 

For equivalence links, follow this:

https://www.ptc.com/en/support/article/CS390538?source=search

[AA_13953438]

I have data in table formats why you are not suggesting WBM any problem with this. I need to migrate different versions for BOM as well. File creation itself is a big task  it gives many errors. initial setup it is okay, but for the bulk data I am not sure

[avillanueva]

I personally have no experience with WBM. I would let other chime in on that but from what little I know, this would be recommended if you are migrating from one PLM system to Windchill. It still is an option for you.

[AA_13953438]

Also I need to create new view version(Downstream Part) for that, attributes are different from the design view. So I need to migrate different attribute values for IBA attribute and the BOM structure is that possible with load from file

[Catalina]

Hi @AA_13953438 

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.

Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,