Change Part & Document Numbers for ~2K Existing Items
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.
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