mentor.com
Up to Discussions in PADS - Desktop PCB Design
11 Replies Last post: Jul 13, 2009 8:08 AM by hannu.tikkanen  
gprintzis Wannabe
gprintzis
8 posts since
Sep 9, 2008
Reply
Currently Being Moderated

Jul 7, 2009 11:26 AM

PADS parts library.p to excel

Is there a way to import/export PADS parts library.p ro excel in order to edit and then convert back to parts.p library?

Thanks

Reply
jduquette Wannabe
jduquette
5 posts since
Jun 29, 2009
Currently Being Moderated
Jul 7, 2009 7:55 AM in response to: gprintzis
Re: PADS parts library.p ro excel

I doubt you will get this cleanly into Excel.  You are probably better with a scripting language such as PERL.

 

John D

Report Abuse Reply
gprintzis Wannabe
gprintzis
8 posts since
Sep 9, 2008
Currently Being Moderated
Jul 7, 2009 9:00 AM in response to: jduquette
Re: PADS parts library.p ro excel

Unfortunately I’m not familiar with scripting languages I’m just a PCB designer, do you know if there is a script available?

 

Thank you for the quick respond.

Report Abuse Reply
jduquette Wannabe
jduquette
5 posts since
Jun 29, 2009
Currently Being Moderated
Jul 7, 2009 9:02 AM in response to: gprintzis
Re: PADS parts library.p to excel

I don't know of a script to convert to Excel.  What exactly are you trying to do?

Report Abuse Reply
gprintzis Wannabe
gprintzis
8 posts since
Sep 9, 2008
Currently Being Moderated
Jul 7, 2009 9:17 AM in response to: jduquette
Re: PADS parts library.p to excel

Export a few resistors such as 0402,10K import to Excel, edit the excel file to add several values and part numbers from Digikey and import back to parts.p library. Is it Possible?

Report Abuse Reply
jduquette Wannabe
jduquette
5 posts since
Jun 29, 2009
Currently Being Moderated
Jul 7, 2009 9:23 AM in response to: gprintzis
Re: PADS parts library.p to excel

Welcome to PADS!  Each part in PADS only gets one Value and 'Part Number' entry.  Thus you will need a part defined in the library for each value.  Here are some of my parts:

 

CAP_0.1UF_0805_CER_X7R_50V
CAP_0.1UF_0805_CER_Y5V_25V

 

I also have a generic component

 

C0805

 

that defines a generic 0805 footprint on the PCB.  This is for values that aren't defined in my standard library.  I add the other attributes when I place the part in the schematic.

Report Abuse Reply
chuck.tidwell Wannabe
chuck.tidwell
6 posts since
Oct 29, 2008
Currently Being Moderated
Jul 10, 2009 5:25 AM in response to: gprintzis
Re: PADS parts library.p to excel

What schematic tool are you using? I highly recommend using one that can interface to a parts database, like DxDesigner/Databook or even OrCAD CIS. That way all your P/N etc. data is stored in a database where it belongs (and probably already exists). Let the tool transfer the appropriate data from the Db to the schematic and layout as needed. This way you will only need one PartType/Decal for each kind of part (1 0805, 1 SO8, 1 QFP100...), not a different PartType for every value/tolerance/rating...

 

CT

Report Abuse Reply
gprintzis Wannabe
gprintzis
8 posts since
Sep 9, 2008
Currently Being Moderated
Jul 10, 2009 6:14 AM in response to: chuck.tidwell
Re: PADS parts library.p to excel

That sounds like a good idea, unfortunately we are using PADs Logic not capable of connecting to a database. I found a script  http://www.protocadeng.com/gpage10.html  and according the description it should work for 10 parts at the time. Thanks.

Report Abuse Reply
jwheeler Wannabe
jwheeler
6 posts since
Aug 28, 2008
Currently Being Moderated
Jul 10, 2009 10:03 AM in response to: gprintzis
Re: PADS parts library.p to excel

What version are you using. Try this if running PADS 2007.

 

http://www.designsystems.fi/Products/PADSUtilities/pa_e.html

 

I have a free version on the program before this but not sure if it runs on 2007.

Report Abuse Reply
gprintzis Wannabe
gprintzis
8 posts since
Sep 9, 2008
Currently Being Moderated
Jul 10, 2009 10:57 AM in response to: jwheeler
Re: PADS parts library.p to excel

Where can I get the free version?

Report Abuse Reply
jwheeler Wannabe
jwheeler
6 posts since
Aug 28, 2008
Currently Being Moderated
Jul 10, 2009 11:56 AM in response to: gprintzis
Re: PADS parts library.p to excel

Here you go. I don't think this works with 2007. Included is a document I put together to use the program.

 

John W

Attachments:
Report Abuse Reply
hannu.tikkanen Wannabe
hannu.tikkanen
4 posts since
Dec 11, 2008
Currently Being Moderated
Jul 13, 2009 8:09 AM in response to: gprintzis
Re: PADS parts library.p to excel

PADS parttype lib to Excel and back is available as one of the functions of the PowerAccess tool. It works for 2007, a build for 9.0 is about to be released. I can deliver a timed license if you want to try.

Report Abuse Reply

More Like This

  • Retrieving data ...