Protel: Part management question

R

RA

Guest
I'm working with Protel99SE sp6. I would like to know
how could I connect the BOM created by Protel with a
database containing the information about the parts
usually in use. Let's say if I got in the BOM resistors
of 100R, I would like to have automaticaly attached in
the BOM the distributor ordering no., manufacturer, price
etc. I know that there are part fields one can fill in
but then I'd have to create a symbol for each part or
type in the fields every time I use such a part. For ICs
and single stuff, thats ok, but for every resistor and
capacitor is a pain. I found a paper on the web talking
about relational databases but it got me nearly a headache.
Is it so that protel doesn't have anything like it as
standard?
Thanks for your time
Reinaldo Alvares
 
Reinaldo,
Within the schematic take a look at "Tools", "Database Links..". This
function will link and stuff values into your partfields from an external
database. In the manual it is not absolutely clearly stated but the linking
will only work to a DB3 or DB4 format database so you may have to convert
your existing database to one of these formats for the linking function.
Afterward you can generate a BOM that contains any fields that you want to
include on your BOM.

--
Sincerely,
Brad Velander

"RA" <reinaldoalvares????@telia.com> wrote in message
news:WOrUb.47970$mU6.184652@newsb.telia.net...
I'm working with Protel99SE sp6. I would like to know
how could I connect the BOM created by Protel with a
database containing the information about the parts
usually in use. Let's say if I got in the BOM resistors
of 100R, I would like to have automaticaly attached in
the BOM the distributor ordering no., manufacturer, price
etc. I know that there are part fields one can fill in
but then I'd have to create a symbol for each part or
type in the fields every time I use such a part. For ICs
and single stuff, thats ok, but for every resistor and
capacitor is a pain. I found a paper on the web talking
about relational databases but it got me nearly a headache.
Is it so that protel doesn't have anything like it as
standard?
Thanks for your time
Reinaldo Alvares
Click to expand...
 
Brad,
Thanks a million! It didn't work for me with the DB4 for some
obscure reasons. But it worked like a charm for the DB3! And
frankly, I don't care about DB3 or DB4 as long as it works.
Now I can save lots of time, thanks again.
Best regards
Reinaldo Alvares

"Brad Velander" <spamthis@nowhere.com> wrote in message
news:mevUb.7978$213.1070@edtnps89...
Reinaldo,
Within the schematic take a look at "Tools", "Database Links..". This
function will link and stuff values into your partfields from an external
database. In the manual it is not absolutely clearly stated but the
linking
will only work to a DB3 or DB4 format database so you may have to convert
your existing database to one of these formats for the linking function.
Afterward you can generate a BOM that contains any fields that you want to
include on your BOM.

--
Sincerely,
Brad Velander

"RA" <reinaldoalvares????@telia.com> wrote in message
news:WOrUb.47970$mU6.184652@newsb.telia.net...
I'm working with Protel99SE sp6. I would like to know
how could I connect the BOM created by Protel with a
database containing the information about the parts
usually in use. Let's say if I got in the BOM resistors
of 100R, I would like to have automaticaly attached in
the BOM the distributor ordering no., manufacturer, price
etc. I know that there are part fields one can fill in
but then I'd have to create a symbol for each part or
type in the fields every time I use such a part. For ICs
and single stuff, thats ok, but for every resistor and
capacitor is a pain. I found a paper on the web talking
about relational databases but it got me nearly a headache.
Is it so that protel doesn't have anything like it as
standard?
Thanks for your time
Reinaldo Alvares
Click to expand...
 
Reinaldo,
Glad to have been of help. I am not sure why your attempt using the DB4
format was unsuccessful, I previously used the DB4 format exclusively when I
was using the database links. Possibly there was some other error that was
interfering with the operation.

--
Sincerely,
Brad Velander

"RA" <reinaldoalvares????@telia.com> wrote in message
news:pqHUb.48078$mU6.185185@newsb.telia.net...
Brad,
Thanks a million! It didn't work for me with the DB4 for some
obscure reasons. But it worked like a charm for the DB3! And
frankly, I don't care about DB3 or DB4 as long as it works.
Now I can save lots of time, thanks again.
Best regards
Reinaldo Alvares
Click to expand...
 
You must log in or register to reply here.

Welcome to EDABoard.com

Sponsor

Back
Top