Skip to main content
D
DonKrause12-Amethyst
12-Amethyst
December 2, 2015
Solved

How to change ref doc to describe by

  • December 2, 2015
  • 4 replies
  • 2308 views

How can I change a Reference Document to a describe by document

Best answer by DonKrause

What we finally ended up doing, in this rough order:

Disassociated all "Attached" parts/Documents.

Used PTC's ChangeTypeSql to get a general idea what columns need to be updated, and to what values.

Queried Oracle to located the correct document in the WTDOCUMENT table.

Stopped the MethodServers.

Backup up the database.

Changed those columns, limited to all iterations of the Document in question.

Restarted the MethodServers

Returned to service.

This appears to have successfully changed a "Reference Document" type object into a "WTDocument" type without any ill effects.

Thanks for the help!

=Don=

4 replies

R
RobertDowns1-Visitor
1-Visitor
December 2, 2015

Can you give a little bit more detail? I assume you have a WTPart associated to a WTDocument as a reference doc and would like to remove that link and associate it as a describe by document. Is that correct? Is it just one or are you looking to do that in mass?

D
DonKrause12-AmethystAuthor
12-Amethyst
December 2, 2015

We currently have a document, (Reference Doc type) that is related to a bunch of parts.

Ideally, we'd like to have this document converted to a Described By type, hopefully retaining it's existing number.

Then we'd create a new part, and set the newly changed existing document would be the "described by" document for the new part.

Thanks!

M
MikeLockwood22-Sapphire I
22-Sapphire I
December 2, 2015

Alcon has a home-grown utility and has been using it for ~ 10 years. Windchill shell command.  Input Number and type to change to.  Works like a charm. PTC's utility on this produces a SQL to be run directly against the database.

    D
    DonKrause12-AmethystAuthorAnswer
    12-Amethyst
    December 4, 2015

    What we finally ended up doing, in this rough order:

    Disassociated all "Attached" parts/Documents.

    Used PTC's ChangeTypeSql to get a general idea what columns need to be updated, and to what values.

    Queried Oracle to located the correct document in the WTDOCUMENT table.

    Stopped the MethodServers.

    Backup up the database.

    Changed those columns, limited to all iterations of the Document in question.

    Restarted the MethodServers

    Returned to service.

    This appears to have successfully changed a "Reference Document" type object into a "WTDocument" type without any ill effects.

    Thanks for the help!

    =Don=

    Terms & ConditionsAccessibility statement