AVEVA Community
AVEVA Community
  • Site
  • User
  • Site
  • Search
  • User
Modules
  • AVEVA World
  • PDMS/E3D Forum
  • Modules
  • Cancel
Modules
Specon Module Rename SPCO
  • Forums
  • Resources
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
  • Replies 12 replies
  • Subscribers 3 subscribers
  • Views 41 views
  • Users 0 members are here
Options
  • Share
  • More
  • Cancel
Related

Rename SPCO

reza nami
reza nami over 10 years ago
 
  • Sign in to reply
  • Cancel
  • reza nami
    reza nami over 10 years ago
    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...
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tomas Veleman
    Tomas Veleman over 10 years ago
    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.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • reza nami
    reza nami over 10 years ago
    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?
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Vinod
    Vinod over 10 years ago
    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]
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • reza nami
    reza nami over 10 years ago
    Can you explain more about macro detail for inserting edited text in the spec....?
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tomas Veleman
    Tomas Veleman over 10 years ago
    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
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • reza nami
    reza nami over 10 years ago
    Thank you tomek ..

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

    Please write one example line...
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tomas Veleman
    Tomas Veleman over 10 years ago
    =9653/96542 name \A3A1\AADDBB:15x15

    =9653/96542 is reference of existing SPCO
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • reza nami
    reza nami over 10 years ago
    So Thanks Tomek.......
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Shrivallabha Sharad Redij
    Shrivallabha Sharad Redij over 10 years ago
    [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.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
>