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/[email protected]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
