I confess that I gave up on Protel's BOM generation a while back.
Now, I use the ExportSchematicToDatabase process to generate a
DBF file (exporting all fields related to PARTs).
I then open the DBF in Excel then save as an Excel workbook. I do
this because I've had problems with getting MS Access to open a
Protel generated DBF reliably - I don't know whether it's Protel's
or Access' fault (and I don't care, since I have a method that
works with the saved XLS workbook).
I have an Access database with the required parsing queries and a
suitable report format. All I do is link to the XLS file then hit
the report generator.
Finally, I print the report to a PDF - done!
A bit long winded, perhaps - but I can generate any report in whatever
format I need by creating new queries and making a report template to
suit.
Cheers,
John Haddy
-Original Message-
From: Colin Weber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 18 July 2001 8:01 AM
To: Protel EDA Forum
Subject: Re: [PEDA] BOM generation with part numbers
Afshin,
I looked into this problem a few years ago and couldn't find a
reasonable,
clean method of doing this type of filtering.
After migrating from one CAD system to another, more than once,
we decided
a better approach was to manage the
part numbers and data in an external database and look to what was needed
to integrate this data with Protel. At least
then our data remains independent of what CAD software your using. Let's
face it most people have external methods
of managing their data anyway. Most often, it is maintained in
spreadsheets.
I have had great success with our newer approach for the last couple of
years. This includes a lot of varied designs
including through hole, surface mount and mixed technologies. I'd rather
not mention particular products on the forum
but you can contact me offline at [EMAIL PROTECTED], for further
information if you like.
At 02:16 PM 17/07/2001 -0700, you wrote:
Hello all,
I would like to have protel alter its BOM output from the schematic
editor depending on what footprint I have
selected for a part. I have company part numbers in two of the eight
fields that are read only. If I select a Surface
Mount footprint I would like it to use the second part number when
generating the BOM and if I select a DIP part I
would like it to use the first part number. From the BOM menu
I do not
see an option for any kind of parsing. Has
anyone done this and is there a better way of managing parts so that a
BOM can be easily created from the output?
I created a library for the values of resistors we have to aid in the
output of a near complete BOM but I would rather
not have a surface mount AND through hole library.
Afshin Salehi
DPS Telecom
Regards,
Colin Weber
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To leave this list visit:
* http://www.techservinc.com/protelusers/leave.html
* - or email -
* mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
*
* Browse or Search previous postings:
* http://www.mail-archive.com/proteledaforum@techservinc.com
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
