Change Part & Document Numbers for ~2K Existing Items

Hi All,
 
We have an org that wants to change the part/doc numbers/format for over 2K existing parts and docs. Is there a way to do this systematically? Possibly with the Import function? Any suggestions would be appreciated.
 
 
Thanks,
 
Kraig
Add Comment
3 Answer(s)

Hi Kraig,

I don’t believe you`ll find a way to change part’s number systematically based that the import tool uses the part number as an unique identifier for items, I don’t recommend you update database tables as well. So, I`d suggest you proceed this way:
– create an attribute called, let`s say, legacy code, and using export/import tool update all new attribute with the old part number, just for audit and traceability purposes.
– Build some sort of robot, perhaps using DataLoader tool, to change “manually” all the part numbers as required, it`ll take some time but is low cost and secure.

Though, you always can write a process extension to do so, I didn’t mentioned it before because you asked for a systemic approach.

My best
Carlos

Agile Angel Answered on March 6, 2019.
Add Comment

Try just renaming a part that is a BOM item (component). I had done it with SQL way back when because it was the only way to take care of an issue with the BOM

Agile Angel Answered on March 7, 2019.
Add Comment

Hi Kraig

   One other option I have tried in the past

  a) Create a new role that allows to Modify Title Block.Item number even for released items
  b) Create a new user and assign this role
  c) Develop a simple SDK process using this new user that accepts input for old and new item numbers and do the update

Hope this helps

Raj

Agile Angel Answered on March 7, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.