Re: [PEDA] Newbie questions
Jim Hhhm, I did exactly that, made a complete library of our stocked parts then used the (horribly slow) database link feature to update our part numbers into the schematic. The link feature just uses an excel file (good for copy paste) and export it as dbase4. I believe Ian Wilson wrote a better (and faster) version of database linking direct to an excel sheet but I havent gotten around to trying it. I then used a simple vb script with excel (launched from with protel and hidden) to format the BOM to our internal style with or without prices etc. Hope that helps! rich -Original Message- From: Jim Weir [mailto:[EMAIL PROTECTED]] Sent: 20 August 2002 21:08 To: Protel EDA Forum Subject: [PEDA] Newbie questions I have a chance to acquire a legit copy of 99SE in a rather major swap of test equipment and computer supplies with another company. It is a rather minor component of the whole deal, but before I trade for it, I want to make sure that it will do what I want it to do. As yet, perusing the documentation that came with the 30-day trial package hasn't unearthed what I want to know. I am currently using (ptui, yecch) Circuitmaker 2K for my board layouts, which are minimal to say the least. Analog boards, 2 sided, nothing spectacular. However, CM2K is about as unstable a platform as I've ever used...I actually considered going back to tape and donuts there for a while. Anyway, the one thing that CM has going for it is the capability to put a whole family of parts into the design database library and call them up into the schematic individually by value. And, with a little maneuvering, you can put in your own identifiers (like company part number) and the identifiers will ride along with the part. Thus, calling up a bom gives you not only the part name and description, but your own internal stockroom part number as well. Along with that, CM's database is a text file. When putting in a large number of series parts (as, for example, the ¼w 5% resistors), all you have to do is put in the first sequence. Then by cut'n'paste, you can build the whole series quite easily. In addition, once you have the ¼w family done, the ½w family is really trivial to generate by copy and then a search/replace on the differences. If you have a whole bunch of families in your stockroom (electrolytics, mylars, etc.) building the libraries for your entire stockroom of a few thousand parts isn't much more than a week's work. I can't find that capability in 99SE. If it can be done, would somebody please let me know where in the documentation this feature is so that I can reread something that I didn't get the first few times? Many thanks fer yer help. Jim * Tracking #: B0189544F35D254DA51704F4DCE2790DD7E3D428 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Newbie questions
As I understand it you want to have one library part for each part number in your system, and you want the part information in a field. One way to do this is to add component names to the component for every partnumber. So than the library item RESISTOR would also have names equal to all your resistor part numbers. Unfortunately this does not allow you to match the value to the part number unless you put it in the name. The other way is to copy the component, rename it to the part number and add the part number information to the library fields. Some people use the dBase link to pull the part number information into the part fields after the parts are placed on the schematic, but since I use Access not dBase and the link is slow I don't use it. So yes it is do-able with a little work. Hope this helps, Robert D. LaMoreaux MTS Systems Corp. Powertrain Technology Division 4622 Runway Blvd. Ann Arbor, MI 48108 734-822-9696 Fax 734-973-1103 Main Desk 734-973- * Tracking #: D3908DFF0DA2A348A19E59AF7D1B10137E72C240 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Newbie questions
At 11:13 AM 8/21/2002 -0400, you wrote: As I understand it you want to have one library part for each part number in your system, and you want the part information in a field. If you have a company part number for every resistor and you want to be able to place a resistor symbol on to your schematic with the value do the following. Create symbol and give it your company number. Place the company number in one of eight library fields under description(always use same library fields location ie field 1)and add footprint. Under group for that number give the value. In schematic all ways select symbol by value. This will match value to part number and footprint. Never allow anyone to change a resistor by changing the value on the schematic. Always go back to the library for a new resistor. You don't want to explain to your boss how you are going to get that 1 watt resistor in that 0805 space. Use one library to resistor size and tolerance. Can't go wrong. Capacitors are a little tuft but doable. One library with symbol name as value tol type and voltage. Put company part in same location. Use Reports - Bill of Materials to extract info. One way to do this is to add component names to the component for every partnumber. So than the library item RESISTOR would also have names equal to all your resistor part numbers. Unfortunately this does not allow you to match the value to the part number unless you put it in the name. see above The other way is to copy the component, rename it to the part number and add the part number information to the library fields. Some people use the dBase link to pull the part number information into the part fields after the parts are placed on the schematic, but since I use Access not dBase and the link is slow I don't use it. So yes it is do-able with a little work. Hope this helps, Robert D. LaMoreaux MTS Systems Corp. Powertrain Technology Division 4622 Runway Blvd. Ann Arbor, MI 48108 734-822-9696 Fax 734-973-1103 Main Desk 734-973- * Tracking #: D3908DFF0DA2A348A19E59AF7D1B10137E72C240 * Rusty Garfield C. I. D. Development Technician IV Sugar Land Product Center (281) 285-7611 (voice) (281) 285-7619 (fax) [EMAIL PROTECTED] (e-mail) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] Newbie questions
I have a chance to acquire a legit copy of 99SE in a rather major swap of test equipment and computer supplies with another company. It is a rather minor component of the whole deal, but before I trade for it, I want to make sure that it will do what I want it to do. As yet, perusing the documentation that came with the 30-day trial package hasn't unearthed what I want to know. I am currently using (ptui, yecch) Circuitmaker 2K for my board layouts, which are minimal to say the least. Analog boards, 2 sided, nothing spectacular. However, CM2K is about as unstable a platform as I've ever used...I actually considered going back to tape and donuts there for a while. Anyway, the one thing that CM has going for it is the capability to put a whole family of parts into the design database library and call them up into the schematic individually by value. And, with a little maneuvering, you can put in your own identifiers (like company part number) and the identifiers will ride along with the part. Thus, calling up a bom gives you not only the part name and description, but your own internal stockroom part number as well. Along with that, CM's database is a text file. When putting in a large number of series parts (as, for example, the ¼w 5% resistors), all you have to do is put in the first sequence. Then by cut'n'paste, you can build the whole series quite easily. In addition, once you have the ¼w family done, the ½w family is really trivial to generate by copy and then a search/replace on the differences. If you have a whole bunch of families in your stockroom (electrolytics, mylars, etc.) building the libraries for your entire stockroom of a few thousand parts isn't much more than a week's work. I can't find that capability in 99SE. If it can be done, would somebody please let me know where in the documentation this feature is so that I can reread something that I didn't get the first few times? Many thanks fer yer help. Jim * Tracking #: B0189544F35D254DA51704F4DCE2790DD7E3D428 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *