Searching \ for '[EE]: Protel Part Numbers' in subject line. ()
Make payments with PayPal - it's fast, free and secure! Help us get a faster server
FAQ page: www.piclist.com/techref/index.htm?key=protel+part+numbers
Search entire site for: 'Protel Part Numbers'.

Exact match. Not showing close matches.
PICList Thread
'[EE]: Protel Part Numbers'
2003\08\07@191340 by David Huisman

flavicon
face
Anyone know if the placed components in Protel scehmatic can be allocated a Part Number ?

I want to be able to export the Bill of Materials to an Access application that will allocate stock
to a build based on the schematic.

Kind Regards

David Huisman

--
http://www.piclist.com hint: The PICList is archived three different
ways.  See http://www.piclist.com/#archives for details.

2003\08\08@115134 by Paul Hutchinson

flavicon
face
Good timing on this question, I just finished doing this for my latest
design!

Yes, Protel contains user definable fields for schematic components. In P98
there are 8 user fields that can only be changed in the library and 16 user
defined fields that can be changed in the schematic, later versions of
Protel may have more of both types.

Paul

> {Original Message removed}

2003\08\08@140055 by Vincent Vega

picon face
>
> Anyone know if the placed components in Protel scehmatic can be
> allocated a Part Number ?

In Protel99SE:

Right click the part of interest>Properties>Part Field

There you have 16 fields to put whatever you want. Based on that, you can

later go to "Reports" and generate a bill of material.

Thanks, VV





---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

--
http://www.piclist.com#nomail Going offline? Don't AutoReply us!
email spam_OUTlistservTakeThisOuTspammitvma.mit.edu with SET PICList DIGEST in the body

2003\08\08@173644 by Orbit Communications

flavicon
face
I suppose that this could help semi-automat the process that we manually
look up the appropriate part number and enter it into the schematic part
field as we place the component.

Many of the components that are unique (IC's for example), could have the
part number allocated within the library component itself ?)

Maybe we just have an access database that takes the prtoel BOM output and
looks at the value field and brings up a list of available part numbers from
our inventory that match the value.
To automate this within Protel (we do use SE99), we would need to create a
schematic component for each value resistor.



Kind Regards

David Huisman (CEO)
-----------------------------------------------------------------------
ORBIT COMMUNICATIONS - Wireless Solutions that Work
(Telemetry, Control, Monitoring, Security, HVAC ...)

Website : http://www.orbitcoms.com
PO Box 4474 Lakehaven
NSW 2259, AUSTRALIA
Phone: 61-2-4393-3627
Fax  : 61-2-4393-3685
Mobile: 61-413-715-986
{Original Message removed}

2003\08\08@194010 by Tal

flavicon
face
Few months ago I started to write a program that will read Protel BOM
and will add it automatically to a DigiKey order or part list. I had
some progress with the program and it can already
create/add/rename/delete DigiKey part lists, add Protel BOM to part
list, etc. However, there is still work to be done and I am busy with
our stuff.

If anybody want to take care this project, please let me know. It is a
console application written in Java and is compiled into a single .exe
file.

Tal

> {Original Message removed}

2003\08\08@194012 by Tal

flavicon
face
I think that Orcad had something like that. A connection to a back end
data base where components can be looked up. Can anybody has more
information how to use it ?

Thanks,

Tal

> {Original Message removed}

2003\08\08@210208 by Dave Tweed

face
flavicon
face
Tal <.....talKILLspamspam@spam@ZAPTA.COM> wrote:
> David Huisman (CEO) wrote:
> > I suppose that this could help semi-automat the process that
> > we manually look up the appropriate part number and enter it
> > into the schematic part field as we place the component.
> >
> > Many of the components that are unique (IC's for example),
> > could have the part number allocated within the library
> > component itself ?)
> >
> > Maybe we just have an access database that takes the prtoel
> > BOM output and looks at the value field and brings up a list
> > of available part numbers from our inventory that match the
> > value. To automate this within Protel (we do use SE99), we
> > would need to create a schematic component for each value resistor.
>
> I think that Orcad had something like that. A connection to a back
> end data base where components can be looked up. Can anybody has more
> information how to use it ?

You set up a file (conventionally ending in ".UPD") that contains two
columns of information. The first column contains one or more fields match
on each part, and the second gives the value of the field to change.
(Anything after that on the line is treated as a comment.) The first line
of the file is special; it gives the field name(s) for both columns. For
example, you might have a file that looks something like this:

=========================================================================
"{Value} {PCB Footprint}"       "1ST PART FIELD"        ; comment
"100nF 0603"                    "1101-6100"             ; capacitor
"100pF 0603"                    "1101-3100"             ; capacitor
"10K 0603"                      "1001-5100"             ; resistor
"10nF 0603"                     "1101-5100"             ; capacitor
"10uF 1206"                     "1103-8100"             ; capacitor nonpol?
"10uF-16V ALUM-B"               "1111-4010"             ; capacitor SMT?
"13K 0603"                      "1001-5130"             ; resistor
"150 0603"                      "1001-3150"             ; resistor
"150,1% 0603"                   "1001-3150"             ; resistor
  .                               .                       .
  .                               .                       .
  .                               .                       .
=========================================================================

The first line specifies that you're matching on the existing values of
both the part value and PCB footprint fields, and you're updating the first
user-defined field (which contains an internal part number in this case).
The remaining lines are specific values to match and replace with.

You use this by highlighting the design (project.dsn) entry in the project
window, then selecting Tools --> Update Properties ... in the menu. Enter
the path to the .UPD file, and select other options as desired (such as
changing the visibility of the updated property). A report is generated
that indicates any problems with specfic part instances.

In theory, you could have a single master .UPD file that covers your entire
parts catalog, but in practice, I tend to produce a custom .UPD file for
each project. The part value fields, in particular, tend to be somewhat
cryptic and ambiguous.

-- Dave Tweed

--
http://www.piclist.com#nomail Going offline? Don't AutoReply us!
email listservspamKILLspammitvma.mit.edu with SET PICList DIGEST in the body

2003\08\08@213808 by Orbit Communications

flavicon
face
My version of Protel 99SE does not have TOOLS -> Update Properties but it
does have "Database Linking".

This may be what I am looking for as it seems to indicate that we can link
fields in a component to a database file.

I'll check this out and see what I can come up with.

Thanks

Kind Regards

David Huisman (CEO)
-----------------------------------------------------------------------
ORBIT COMMUNICATIONS - Wireless Solutions that Work
(Telemetry, Control, Monitoring, Security, HVAC ...)

Website : http://www.orbitcoms.com
PO Box 4474 Lakehaven
NSW 2259, AUSTRALIA
Phone: 61-2-4393-3627
Fax  : 61-2-4393-3685
Mobile: 61-413-715-986
{Original Message removed}

2003\08\09@091222 by Vincent Vega

picon face
>Many of the components that are unique (IC's for example), could have the
>part number allocated within the library component itself ?)


That's what I do with many "unique" components.


>To automate this within Protel (we do use SE99), we would need to create a
>schematic component for each value resistor.


I enter the order codes, suppliers, etc for resistors and caps while drawing the schematic. I seldom put more that 100 components in one sheet. I use multi-sheet schematics and link them together. I my opinion is easier to read, manage and mantain them later.

Thanks,VV






---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

--
http://www.piclist.com hint: To leave the PICList
.....piclist-unsubscribe-requestKILLspamspam.....mitvma.mit.edu

2003\08\09@091223 by Dave Tweed

face
flavicon
face
Orbit Communications - David Huisman (CEO) <EraseMEinfospam_OUTspamTakeThisOuTORBITCOMS.COM> wrote:
> My version of Protel 99SE does not have TOOLS -> Update Properties but it
> does have "Database Linking".

Sorry, I was replying to Tal, who was asking for the instructions for
Orcad. I can't help you with Protel.

-- Dave Tweed

--
http://www.piclist.com hint: To leave the PICList
piclist-unsubscribe-requestspamspam_OUTmitvma.mit.edu

2003\08\09@175143 by Tal

flavicon
face
Thanks Dave.

This looks like a real time saving feature.  Orcad commands have also
references to 'Databases'. For example, open a schematic, select a part
select the menu command Edit | Link Database Part. Note also the tab
called Internet Component Assistant (ICA). Is this support for
'databases' related to the Update Properties feature you described or is
it a completely different feature.

Thanks,

Tal

> {Original Message removed}

2003\08\09@203912 by Dave Tweed

face
flavicon
face
Tal <@spam@talKILLspamspamZAPTA.COM> wrote:
> Orcad commands have also references to 'Databases'. For example, open a
> schematic, select a part select the menu command Edit | Link Database
> Part. Note also the tab called Internet Component Assistant (ICA). Is
> this support for 'databases' related to the Update Properties feature you
> described or is it a completely different feature.

Not in my version of Orcad (Capture 7.20.170)...

From browsing their website, I would think that Databases are related
to the CIS version of the product and/or a linkage to Orcad Layout.

Sorry I can't be more helpful.

-- Dave Tweed

--
http://www.piclist.com hint: To leave the PICList
KILLspampiclist-unsubscribe-requestKILLspamspammitvma.mit.edu

2003\08\11@062913 by Alan B. Pearce

face picon face
>I think that Orcad had something like that. A connection to a back
>end data base where components can be looked up. Can anybody has
>more information how to use it ?

Yes, Capture CIS has a connection to SQL, and you can set up a database
which is then queried if you run a CIS report. Note that Capture (without
the CIS moniker) does not have this SQL connection. Also when in Capture CIS
it is still possible to generate a non-CIS report.

However there are some peculiarities with the CIS database when having user
defined fields. While there are a whole range of fields which come
predefined in the CIS, we wanted some fields which had information peculiar
to the way we work, and these get checked when the report is run, and if
they are not all the same for a given part, then errors get reported.

--
http://www.piclist.com hint: The list server can filter out subtopics
(like ads or off topics) for you. See http://www.piclist.com/#topics

More... (looser matching)
- Last day of these posts
- In 2003 , 2004 only
- Today
- New search...