Skip to main content
B
Ben_A10-Marble
10-Marble
January 3, 2024
Solved

Need to change Library's Creator

  • January 3, 2024
  • 4 replies
  • 1721 views

Windchill 12.0.2.12, pdmlink 12.0.2.7

I have a requirement to update the creator name of a bunch of libraries in Windchill. The person that created the libraries is no longer with the company and automated emails/Library Details clearly show their name as a potential point of contact. Our users are confused by this and wonder why they never get responses to their emails (i.e. creator != librarian).

 

Ideally, I want to change the name of the creator to a Windchill Admin Group participant, but just another current employee on that team will suffice - assuming we can change it again later.

 

Of course, I can't simply edit that attribute, even after adding it to the layout. So, I'm guessing some code will be needed. Any advise is greatly appreciated.

Best answer by avillanueva

If its not something in the UI, you might have to resort to a database edit. The creator for the Library is stored in the WTLibrary Table. Modeled Object info shows this as the ida3b3containerinfo column.

avillanueva_0-1704371103358.png

You need to get the ida2a2 value of the user you want to change it to and copy that number for that library's row. I also think it has to be a real user account, not a group.

avillanueva_1-1704371167381.png

 

4 replies

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
January 4, 2024

Hi @Ben_A 

Use a delegate calendar and delegate all work to an another user

HelesicPetr_0-1704351965480.png

Emails could go to delegated person. 

Also if the user is not part of the company you should follow recommended process to disable that user.

For example change users email, name for example add a disabled prefix to a name. fullname atc....

How to deactivate/disable inactive users - CS136420

 

PetrH 

 

avillanueva
23-Emerald I
avillanueva23-Emerald IAnswer
23-Emerald I
January 4, 2024

If its not something in the UI, you might have to resort to a database edit. The creator for the Library is stored in the WTLibrary Table. Modeled Object info shows this as the ida3b3containerinfo column.

avillanueva_0-1704371103358.png

You need to get the ida2a2 value of the user you want to change it to and copy that number for that library's row. I also think it has to be a real user account, not a group.

avillanueva_1-1704371167381.png

 

    B
    Ben_A10-MarbleAuthor
    10-Marble
    January 4, 2024

    Hello @avillanueva 

    I like your approach best. It addresses the requirement I've been given.

     

    First question, how did you get to the Column Descriptors (like the image shown). That could be a very useful tool.

     

    As for changing the database, can that be done from something like Windchill Shell? Or, would I need direct access and permission in Oracle/SQL?

    avillanueva
    23-Emerald I
    avillanueva23-Emerald I
    23-Emerald I
    January 4, 2024

    https://<your  server name here>/Windchill/app/#ptc1/carambola/tools/list

    then go to Modeled Objects.

    You would need direct access to the DB. I was using SQL Developer to browse the tables and you can make edits. Careful careful careful with DB edits. 

      Fadel
      Fadel23-Emerald I
      23-Emerald I
      January 5, 2024

      Not Part OOTB , you can give a try and change it using SQL after taking a backup of given table  , the IDA3B2CONTAINERINFO column ,stores the ida2a2 of the product/library creator .

      Buiꓘa
      Terms & ConditionsAccessibility statement