This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

APPLICATION - PRODUCT ENGINEERING - How to update STATE from preliminary to released after bulk upload using NASH

rdb1536 - Saturday, September 25, 2010 7:52 PM:

Is there a suggested method for changing all parts to "released" from "preliminary" after using NASH tool for bulk upload? Or do I have to apply ECR to each and every part to release?

Thanks in advance!

Rick



fli - Tuesday, January 11, 2011 10:34 AM:

Hi,

You should be able to use AML to call a Server-side method which can premote your Items.

BR/ Christoffer



Ron - Friday, January 14, 2011 2:10 PM:

An easy way would be to use SQL to change the state of the  parts. You will need to change

State, Release Date and Current State

State = Released

RELEASE_DATE=  

 use what ever date you want (2011-01-14) must be in the correct format.

Current_State = Part LifeCycle map, Released ID # (42BB3B183A7748C3B4AA9D33F7BF70AC)

 

UPDATE INNOVATOR.PART SET STATE = 'Released', RELEASE_DATE = '2011-01-14', CURRENT_STATE = '42BB3B183A7748C3B4AA9D33F7BF70AC' WHERE  (ITEM_NUMBER = part 1234' AND IS_CURRENT = '1');

Something like this should work, it is easy to setup in a spread sheet where you can have all your items listed, the copy and paste into your SQL management tool and excute the script.

Always use a test enviroment to verify your code

Ron



xueron564 - Sunday, August 14, 2011 8:59 PM:

888xuerong-4:

With the rapid development of the society of mankind, many people feel rather strained by the quick pace of things around them. As a result, searching for ways to relax oneself has become a main trend and growing fast these years. The Fingers Shoes? is one of the newest creations introduced to the world and has been welcomed by people as the shoe is very comfortable and offers a great way to relax the soles of our feet. Besides this new creation, the other shoe brands are also trying to make their new shoes fit the tastes of the crowd. The Asics Running Shoes is the shoe made by the Japanese. Such shoes are received with warm arms especially in the Asian countries because the shoes suit the tastes of the Asians better than others. Of course, the Nike Shoes Online would not be disheartened. They have also been trying to combine Asian culture with the shoes they design. Supra Shoes UK is a pair of skateboarding shoes and is especially welcomed by the young, the active and playful young generation. North Face Canada are clothes that people from all age groups can fit in when they go on an outing in the fields, or in the forests.

145