Skip to main content
J
josepsb1-Visitor
1-Visitor
July 9, 2020
Solved

Massive STATE value change in Windchill

  • July 9, 2020
  • 2 replies
  • 3570 views

Is there any way to update in a massive way STATE value from INWORK to RELEASED for parts in Windchill?

Thanks

Josep

Best answer by BrianToussaint

@josepsb  I did this with a bunch of objects when I was classifying them.  But I just tested this to make sure and I am able to change the state using an importable spreadsheet by changing the state attribute in the spreadsheet.  I am logged in as orgadmin.  Did you export the list as an importable spreadsheet and use this file?

 

export.jpg

2 replies

L
lhoogeveen17-Peridot
17-Peridot
July 9, 2020

How many objects are you talking about? With the correct permissions, you can use 'Set State' to set the state pretty quickly for 1000's of objects. If you are doing 10,000-100,000 you can change the Windchill preference Tables>Size Limit to something like 10,000-50,000 temporarily.

 

Keep in mind if you have Windchill publishing turned on for PDF, STPs, etc., setting the state will likely create a republish event.

    J
    josepsb1-VisitorAuthor
    1-Visitor
    July 9, 2020

    Are 23289 parts that its documentation is in RELEASED State, but Part is in INWORK State, This is due to a bad migration I think, I´ve tried through an excel template but STATE is not updated, it works for description and other fields but not for STATE.

    So I do not know if I´m doing something wrong or STATE cannot be updated using excel templates, even that in this page says STATE is EDITABLE or REIMPORT

    https://support.ptc.com/help/windchill/whc/whc_en/index.html#page/Windchill_Help_Center%2FImExFileFormatParts.html%23https://support.ptc.com/help/windchill/whc/whc_en/index.html#page/Windchill_Help_Center%2FImExFileFormatParts.html%23

    Set State method is very slow to use it for such number of parts, I´ve already tried.

    B
    BrianToussaint19-TanzaniteAnswer
    19-Tanzanite
    July 9, 2020

    @josepsb  I did this with a bunch of objects when I was classifying them.  But I just tested this to make sure and I am able to change the state using an importable spreadsheet by changing the state attribute in the spreadsheet.  I am logged in as orgadmin.  Did you export the list as an importable spreadsheet and use this file?

     

    export.jpg

      M
      22-Sapphire I
      MikeLockwood22-Sapphire I
      22-Sapphire I
      July 9, 2020

      Two options:

      1. Use the lifecycle reassign utility from a windchill shell.  In multiple companies, I've been involved in using this several times.  Have to be careful but works.  Back up the database before executing.

      https://www.ptc.com/en/support/article/CS111553?&language=en&posno=2&q=lifecycle%20reassign%20utility&source=search

       

      2. Assuming the current lifecycle has a Promotion transition from the current state to the desired state, massively add all objects to a single Promotion Request and let it process thru the state change.

        J
        josepsb1-VisitorAuthor
        1-Visitor
        July 10, 2020

        Thanks for your reply, previous conversation gave me the solution!!! less risky than yours I think, 😅, Thanks anyway!!!

        Terms & ConditionsCookie settingsAccessibility statement