Rename SPCO

Hi friends,

At first of project, we've done wrong and copy each SPEC by Catview, at present when we try to generate ISO, PDMS 11.6 can not find items because they haven't name (SPCO name), (Example : SPCO name is 9653/96542 that need to be  \A3A1\AADDBB:15x15 )

My question is whether we should change items one by one with catview or there is any other way to change the names fast ?

Thank you...

Just make report with name spec catr para[1] and other what you need, then modify within advanced tools of some better txt editor or excel and prepare simple rename txt file:

=9653/96542 name \A3A1\AADDBB:15x15
=9653/96543 name \A3A1\AADDCC:10x10
etc.

Thank you...

we generate report as text file and edit as per spec, at present how to input this text to spec...?

by macro...? can you explain more?

it shall be inserted in SPECON?

yes can be inserted in SPECON ..but for ease PARAGON can be used.

i had same suggestion as above...columns may contain           NAME  'NAM'  SPEC  catr para[1] 'x' para[2] DTXR

taking text output will be good and be modified in a text editor ....
I faced great trouble while taking  report of reference in excel ,get converts to some other value as output comes.
Ex [COLOR=#333333]=9653/96542 get converts to [/COLOR][TABLE="width: 87"]
[TR]
 [TD="class: xl63, width: 87, align: right"]0.09998757[/TD]
[/TR]
[/TABLE]

Can you explain more about macro detail for inserting edited text in the spec....?

syntax is :

REFERENCE name /NEW_NAME

my suggestion was to join some data to SPCO´s name.
In case you will report it to CSV file (i use ";" for separator), you can open output scv at txt editor and replace "= with " = so it will change "=9653/96542";...... to " =9653/96542";...... so you can open it in excel and join the data. Then you can use syntax for renaming above.
After you finish you will have txt file, then start PARAGON module and run it ... e.g. $m %pdmsuser%/renaming.txt

Thank you tomek ..

I try to run your syntax but syntax error appear..

Please write one example line...

=9653/96542 name \A3A1\AADDBB:15x15

=9653/96542 is reference of existing SPCO

So Thanks Tomek.......

[QUOTE=vinurules;90286]
I faced great trouble while taking  report of reference in excel ,get converts to some other value as output comes.
Ex [COLOR=#333333]=9653/96542 get converts to [/COLOR][TABLE="width: 87"]
[TR]
 [TD="class: xl63, width: 87, align: right"]0.09998757[/TD]
[/TR]
[/TABLE]
If the cell formatting in Excel is "General" then Excel assumes it as formula and calculates division. Change cell formatting by Right click | Format | Text to avoid this from happening.

You can also address this while doing text to columns of the *.txt output. In video link the format option comes at the end @1:32

Change the formatting for the Dbref column to text.