Preferred method of batch updating objects?

[Aaronm87]

Version: Windchill 12.1

Use Case: I have thousands of WTParts that need to be renamed and their part subtyped updated.

Description:

I have thousands of WTParts that need to be renamed. The CAD parts cannot contain a "/", but their P/N in windchill needs a "/". Is there a way to batch associate part numbers using loader or queryspec? Is it possible to rename the WTParts after checkin?

[d_graham]

The short answer is yes.

Rename (do you mean rename or renumber or both) can be done in SQL or just write a class to do it as long as you have the logic.

Part to CAD association can be done too. I’d use a class to do this but again you’d need some logic or a file specifying which part is to be associated to which cad doc.

Either way all is very doable. 

Are renaming or associating or both ?

 BTW, Your post is ambiguous. Please be precise when posting. If someone has to ask what you really mean, well, no one should have to ask. Agreed?

[Aaronm87]

Just renaming and whatever is easiest for the associativity. I don't have a preference on importing the WTParts from a spreadsheet and associating or generating new WTParts. Basically, I have a large amount of files (probably over 3000 in total) that the CAD document is named "test123" and I need the windchill part number to be "test/123". 

We have software engineers on staff, but they don't know anything about Windchill. I've tried to looked up documentation and the Windchill Help  guide was the best starting point i could find.

[d_graham]

You’re going to need custom code to insert a forwardslash into the name. Doable for sure but not OOTB.

As for associating Cad to WTParts this is also very doable. What’s the logic for which cad needs to be linked to which WTPart? If the cad and WTPart numbers and revisions are the same doing this is no problem.