Skip to main content
P
Prabhu10-Marble
10-Marble
February 12, 2013
Question

Is there a way to change the type of a WTPart?

  • February 12, 2013
  • 5 replies
  • 2813 views

Hi All,

Is there a way to change the type of a WTPart through UI or through any other method? Is there a tool to convery WTParts from one type to another in bulk?

Thanks,

Prabhakaran V.

5 replies

GregoryPERASSO
GregoryPERASSO16-Pearl
16-Pearl
February 12, 2013

unfortunately, only by customization.

And this is not supported by PTC....

S
sderoose13-Aquamarine
13-Aquamarine
February 21, 2013

There is a tool to do this:

https://www.ptc.com/appserver/cs/view/solution.jsp?n=CS7287

The tool will generate a SQL script you'll need to execute. You can change the SQL script so only parts in a certain product/library are converted.

best regards,
Stijn

    P
    Prabhu10-MarbleAuthor
    10-Marble
    February 22, 2013

    You are correct Stijn.. Got the tool from PTC. Looking for ways to manipulate it to our needs.

    This tool would convert all, I mean ALL, parts in the whole system from one type to another. Need a way to do the same selectively on specific parts.

    Will update if we get to succeed.

    Thanks,

    Prabhakaran V.

    B
    BjoernRueegg17-Peridot
    17-Peridot
    March 11, 2015

    You can do it like this:

    Oracle:

    UPDATE WTPart

    SET branchIdA2typeDefinitionRefe = 126962,

    Ida2typedefinitionreference = 126966

    Where Branchida2typedefinitionrefe In (36374)

    AND Ida3masterreference in (select ida2a2 from wtpartmaster where WTPartNumber in ('2000783'.'2000789'));

    MS SQL:

    UPDATE pdmlink.WTPart

    SET branchIdA2typeDefinitionRefe = 61479,

    idA2typeDefinitionReference = 492826

    WHERE branchIdA2typeDefinitionRefe IN (71144)

    AND idA3masterReference IN (select idA2A2 from pdmlink.WTPartMaster where WTPartNumber in ('2000783','2000789'));

      Terms & ConditionsAccessibility statement