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-----
> From: pic microcontroller discussion list
> [mailto:PICLIST@MITVMA.MIT.EDU] On Behalf Of Dave Tweed
> Sent: Friday, August 08, 2003 6:02 PM
> To: PICLIST@MITVMA.MIT.EDU
> Subject: Re: [EE]: Protel Part Numbers
>
>
> Tal <tal@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 listserv@mitvma.mit.edu with SET PICList DIGEST in the body
>

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