Andrew,
we all probably suffer from similar problems. One work-around that I
use is to import the BOMs into Excel as text files. This allows you to
specify each column as Text and you don't loose those leading "0"s, nor any
other special characters.
Typically my imports are brought in as fixed width text files and in
the import wizard I specify each column as text. The only massaging that
this requires is to get all the reference designators into the same cell
when the BOM export wraps designators onto multiple lines.
Sincerely,
Brad Velander.
Lead PCB Designer
Norsat International Inc.
Microwave Products
Tel (604) 292-9089 (direct line)
Fax (604) 292-9010
email: [EMAIL PROTECTED]
http://www.norsat.com
See us at Booth 323 at Satellite 2002 in Washington, DC March 6-8.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 9:05 AM
To: Protel EDA Forum
Subject: Re: [PEDA] Using Client Spreadsheets to update schematics
We have a related problem. BoMs loaded into Excel always strip leading
zeroes.
I'm afraid we cheat, and don't have 0402, 0603 0805 etc. as footprints, but
instead append the name of our company e.g. ART_0805. Our libraries match
with
this.
AAMOI - I think sticking with 0805, 0603, 0402 for footprint names is a bit
bush league because there is no such thing as an 0805 footprint. Our
footprints
vary slowly over time following the advice of our board manufacturer(s) and
assembly house(s). We take the manufacturer's footprint as advice only,
albeit
good advice. ART_0805 immediately tells me this footprint has had some
attention paid to solder expansion, silkscreen definition and pad size. 0805
doesn't, and could have come from some old default Protel library. AFAICR
0805
as a footprint varies between manufacturers, even if the component size
doesn't.
Andrew Ircha
ART
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* To post a message: mailto:[EMAIL PROTECTED]
*
* To leave this list visit:
* http://www.techservinc.com/protelusers/leave.html
*
* Contact the list manager:
* mailto:[EMAIL PROTECTED]
*
* Forum Guidelines Rules:
* http://www.techservinc.com/protelusers/forumrules.html
*
* Browse or Search previous postings:
* http://www.mail-archive.com/[email protected]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
