1 Reply Latest reply on Aug 19, 2015 1:58 AM by robert_davies

    How to add new item ( component attributes) from EXCEL import

    robert_davies

      Posted on behalf of hou william

       

       

      PADS LOGIC ,,,how to add new item ( component attributes ) from EXCEL import

       

      how can i do ... ?

      1.  a new schematic ( BOM)  export to TXT or EXCEL , this is ok !!

      2. but , if i want to edit and add new component attributes from EXCEL , then import to PADS LOGIC . how can i do . ?

       

      thanks'

       

      Message was edited by: Robert Davies Moved from Document to Discussion

        • 1. Re: How to add new item ( component attributes) from EXCEL import
          robert_davies

          Posted on behalf of Jim Granville.as we lost all comments in moving this to the discussion forum.

           

           

          Depends on how many you need to do, and how often ?

           

          * For just a few, you can copy/paste one element at a time, from Excel, directly into SCH (or PCB) Attribute editor.

          [ Pair-copy using ^C ^V ^X ^V  can get you two items with one window change ]

           

          * For larger blocks, the Library Part Edit allows Excel Multi-line Paste (tab+CrLf delineated blocks )

          That means you needs to SaveToLib (or have your lib already in Sync), Block-paste modify the Lib parts needed, and then do UpdateFromLib with Update Attributes not in design = Y

           

          * For often, and very large changes, you could look at the PADS ASCII and PADS ECO formats and create your own external script.

          Takes a couple of hours to write and test the Script, but then you can manage frequent and global data set sweeps.

           

          - In Logic ASCII Files,  the Attributes have a Line Counter in the PART heading  and then N lines of Attributes.

          To add new Attr, increase that Count Value, and insert new Attr lines for each part needed.

           

          - or the simpler ECO ASCII import may give enough scope. An example ECO file & ECO commands is

           

          *PADS-ECO-V10.0-INCHES*

          *DELPART*

          R3_1  R1/8W

          *CHGPART*

          D1  LED  LEDAK

          *DEL_ATTRIBUTE*    PART    C8

          "VOLTAGE RATING"

          "Sim.Analog.Model"

          "Sim.Analog.Order"

          "Sim.Analog.Prefix"

          *DEL_ATTRIBUTE*    PART    U5

          "NewU5A"

          "NewU5B"

          *SET_ATTRIBUTE*    PART    U4

          "Geometry.Height"    0.10000"

          "NewA_U4A"    vNewA_U4A

          "NewA_U4B"    vNewA_U4B

           

          You can see the commands for  *DEL_ATTRIBUTE* and *SET_ATTRIBUTE*  and those can add sets of attributes to designated RefDes.

           

          The PADS Logic inbuilt Script engine, also has an example (in the help under Attributes.Add) of adding new Attributes to a given RefDes, and that in-built script can read an external csv file, for a list of what to add where.