I need to reserve a block of part numbers. My naming convention is "PT"NNNNNNNN and I want to reserve or create all at one time PT00002000 - PT000030000. Any ideas?
You can reserve the part number block by incrementing the database counter to 30001. Anyone creating a new Item will get 30001 or above. Lets say that your counter name is PT_ITEM (its not but for this example it is). Then the sql to reset the counter is:
select PNEXT_ID from PIMANNEXTID where PNAME = 'PT_ITEM'; PNEXT_ID ---------------- 1999 update PIMANNEXTID set PNEXT_ID = 30001 where PNAME = 'PT_ITEM'; select PNEXT_ID from PIMANNEXTID where PNAME = 'PT_ITEM'; PNEXT_ID ---------------- 30001
Creating mass Items is a different story and there are many tools to help you do that. Live Excel is one example, ps_upload is another, then you have a host of programming tools, ITK, SOA, etc.
NX 11.0.1.mp01 | SW 2016 | TcUA 11.2.3
Keep in mind that once you reserve the block of numbers, like Randy suggested, you will have to enter part number manually if you you want to use number(s) from the reserved block.