Re: [PEDA] Using Client Spreadsheets to update schematics
Re: [PEDA] Using Client Spreadsheets to update schematics
I think it will work if you cut and paste the CSV file, then do "text to columns", which lets you format the fields on the way in. -dn > -Original Message- > From: Bryn Wolfe [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 20, 2002 07:43 > To: Protel EDA Forum > Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > > The lopping off of leading zeros is a feature of Excel. It > has nothing > to do with Protel IMHO. So unless Protel can export in an > Excel format > and set the nature of the columns for us (now that'd be nice), I say > it's not a bug, but just an unimplemented feature THAT PROTEL SHOULD > SERIOUSLY CONSIDER ADDING! That wasn't yelling, it was > emphasizing with > vigor to the "lurkers" among us. > > And, in case anybody actually reads these messages, I like Protel. > Protel is to OrCAD as SolidWorks is to AutoCAD (for those > mechies among > us). Protel has put more polish on their product to improve the UI > instead of sticking with the often obtuse OrCAD interface. > Unfortunately, polish doesn't make bugs go away. They'll > never get all > the bugs out, it's probabilistically impossible. > > Bryn > > [EMAIL PROTECTED] wrote: > > >In a message dated 2/19/2002 4:14:37 PM Eastern Standard Time, > >[EMAIL PROTECTED] writes: > > > > > >>I tried adding leading apostrophe & zero on footprint > ('0603), in client > >>spreadsheet, and File | Update sets the footprint field > without the leading > >>apostrophe. Or is the problem that there's no automatic > way to know which > >>items had zeros removed? > >> > >>If there are only a couple footprints like this, you could > just do global > >>edit when you're done with update, 805=>0805, etc. > >> > > > >That's what I did. Still, it seems pretty kludgy, for a > "feature" which > >Protel touts in their marketing literature. > > > >Steve Hendrix > > > > > > -- > Name : Bryn Wolfe > Title : Robotics Engineer > Dept : Texas Robotics & Automation Center (TRACLabs) > Company: Metrica, Inc > Addr : 1012 Hercules Drive > Houston, TX 77058-2722 > Voice : 281-461-7886 > NASA : n/a > FAX: 281-461-9550 > Web: http://www.traclabs.com > Email : mailto:[EMAIL PROTECTED] or > mailto:[EMAIL PROTECTED] > > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
The lopping off of leading zeros is a feature of Excel. It has nothing to do with Protel IMHO. So unless Protel can export in an Excel format and set the nature of the columns for us (now that'd be nice), I say it's not a bug, but just an unimplemented feature THAT PROTEL SHOULD SERIOUSLY CONSIDER ADDING! That wasn't yelling, it was emphasizing with vigor to the "lurkers" among us. And, in case anybody actually reads these messages, I like Protel. Protel is to OrCAD as SolidWorks is to AutoCAD (for those mechies among us). Protel has put more polish on their product to improve the UI instead of sticking with the often obtuse OrCAD interface. Unfortunately, polish doesn't make bugs go away. They'll never get all the bugs out, it's probabilistically impossible. Bryn [EMAIL PROTECTED] wrote: >In a message dated 2/19/2002 4:14:37 PM Eastern Standard Time, >[EMAIL PROTECTED] writes: > > >>I tried adding leading apostrophe & zero on footprint ('0603), in client >>spreadsheet, and File | Update sets the footprint field without the leading >>apostrophe. Or is the problem that there's no automatic way to know which >>items had zeros removed? >> >>If there are only a couple footprints like this, you could just do global >>edit when you're done with update, 805=>0805, etc. >> > >That's what I did. Still, it seems pretty kludgy, for a "feature" which >Protel touts in their marketing literature. > >Steve Hendrix > > -- Name : Bryn Wolfe Title : Robotics Engineer Dept : Texas Robotics & Automation Center (TRACLabs) Company: Metrica, Inc Addr : 1012 Hercules Drive Houston, TX 77058-2722 Voice : 281-461-7886 NASA : n/a FAX: 281-461-9550 Web: http://www.traclabs.com Email : mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
Re: [PEDA] Using Client Spreadsheets to update schematics
I tried adding leading apostrophe & zero on footprint ('0603), in client spreadsheet, and File | Update sets the footprint field without the leading apostrophe. Or is the problem that there's no automatic way to know which items had zeros removed? If there are only a couple footprints like this, you could just do global edit when you're done with update, 805=>0805, etc. > -Original Message- > From: [EMAIL PROTECTED] > Sent: Tuesday, February 19, 2002 8:24 AM > For the part numbers, I can add a leading apostrophe to force treatment as a > string. However, for the footprint fields, I have to stay exactly with the > footprint names in my PCB library. Is there any way to beat the spreadsheet > export into submission? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
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/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
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 Quoting [EMAIL PROTECTED]: > of a mess right now. When exporting to spread, numbers with leading zeros > like 0402 get treated as numbers rather than strings, and the leading zero > gets chopped off; also, hyphenated part numbers are treated as dates and > totally butchered. i was assuming that only fields which I edited would be > exported back to the schematic, but such is not the case. > - This mail sent through IMP: http://horde.org/imp/ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
I just finished a big session of updating all the part info using the spreadsheet export, which is too powerful to live without, now that I know it's there. I've managed to find ways to work around most of its limitations, but I've encountered one fairly serious problem that has my database in a bit of a mess right now. When exporting to spread, numbers with leading zeros like 0402 get treated as numbers rather than strings, and the leading zero gets chopped off; also, hyphenated part numbers are treated as dates and totally butchered. i was assuming that only fields which I edited would be exported back to the schematic, but such is not the case. For the part numbers, I can add a leading apostrophe to force treatment as a string. However, for the footprint fields, I have to stay exactly with the footprint names in my PCB library. Is there any way to beat the spreadsheet export into submission? Steve Hendrix * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
More on the subject of export to Client Spreadsheet/Excel for tabular edit/update. Hopefully this will clarify for all. 1. Open the schematic (top level sheet if hierarchical). 2. Export to spreadsheet--this runs the client spreadsheet creation wizard. 3. Choose All Off, Part, OK, then check the Part fields you want to edit. Note that read-only fields (Description and Library fields) cannot be edited, so you may as well not select them. (If this isn't so please educate me) 4. The wizard finishes and opens the Client SS. Disable cell protection by unchecking the box in Options|Preferences. Do not close the Client SS or modify the sch from this point forward. SS column B, titled ObjectHandle, is the "hidden" link back to the sch objects. You can view it by increasing the width of column B. It's just a bunch of 64-bit hex values (from GUIDs or perhaps memory pointers?). The column headings are the object names. 5. Edit the SS as needed. You can freely sort the rows and columns to make editing/copying more convenient, as long as the ObjectHandle and column heading relationships to the data are preserved. To use Excel, click in the upper left corner of the Client SS to select all. Ctrl-C to copy to clipboard. Run Excel (with an empty sheet). Click on cell A1. Ctrl-V to paste. Select all and paste back into the Client SS. Again, rows and columns do not matter as long as the handles and column headings are preserved. 6. Choose File|Update. Sch is automagically updated with your edits. You can now save/close the Client SS. My only beef is that you have to regenerate the Client SS each time--no way to re-sync the SS to the database objects. Or is their? >-Original Message- >From: Brooks,Bill [mailto:[EMAIL PROTECTED]] >Sent: Monday, October 08, 2001 11:06 >To: 'Protel EDA Forum' >Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > >*** >Todays forums are sponsored by Ian Martin Limited >Engineering/Technical Placement Specialists >www.ianmartin.com >*** > >Thank you Doug... that actually sounds like a good >work-around. I will try >it. >- Bill Brooks > > >-Original Message- >From: Douglas McDonald [mailto:[EMAIL PROTECTED]] >Sent: Monday, October 08, 2001 2:33 AM >To: Protel EDA Forum >Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > >If you're using the CSV format in conjunction with Microsoft >excel, then >there's a solution which avoids the need to modify numeric fields: > >If you rename the .CSV file to .TXT and then open the .TXT >file in Excel, it > >presents a range of options which includes an option to control the >interpretation of each column. If you select "Text" instead of >the default >"General" then Excel performs no interpretation on the column >and "0805" >reads in as "0805" rather than "805". With CSV files, there >doesn't appear >to be an interpretation option. > > >Doug > > >>From: "Abd ul-Rahman Lomax" <[EMAIL PROTECTED]> >>Reply-To: "Protel EDA Forum" <[EMAIL PROTECTED]> >>To: "Protel EDA Forum" <[EMAIL PROTECTED]> >>Subject: Re: [PEDA] Using Client Spreadsheets to update schematics >>Date: Fri, 05 Oct 2001 14:15:50 -0700 >> >>At 08:25 AM 10/5/01 -0700, Brooks,Bill wrote: >>>I have had trouble with the spreadsheet tools - they always >drop leading >>>zeros... which is a bother, because we use part numbers with leading >>>zeros... Guess there's always a fly in the ointment... It >makes the tool >>>useless to me. >>>- Bill Brooks >> >>A common problem with spreadsheet programs >> >>Edit all your part numbers to prefix a non-numeric, non-arithmetic >>operation character to them. You should be able to do this >globally. An >>apostrophe might do fine, check it out; you could take it out >later if you >>must. >> >>[EMAIL PROTECTED] >>Abdulrahman Lomax >>Easthampton, Massachusetts USA > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
More on the subject of export to Client Spreadsheet/Excel for tabular edit/update. Hopefully this will clarify for all. 1. Open the schematic (top level sheet if hierarchical). 2. Export to spreadsheet--this runs the client spreadsheet creation wizard. 3. Choose All Off, Part, OK, then check the Part fields you want to edit. Note that read-only fields (Description and Library fields) cannot be edited, so you may as well not select them. (If this isn't so please educate me) 4. The wizard finishes and opens the Client SS. Disable cell protection by unchecking the box in Options|Preferences. Do not close the Client SS or modify the sch from this point forward. SS column B, titled ObjectHandle, is the "hidden" link back to the sch objects. You can view it by increasing the width of column B. It's just a bunch of 64-bit hex values (from GUIDs or perhaps memory pointers?). The column headings are the object names. 5. Edit the SS as needed. You can freely sort the rows and columns to make editing/copying more convenient, as long as the ObjectHandle and column heading relationships to the data are preserved. To use Excel, click in the upper left corner of the Client SS to select all. Ctrl-C to copy to clipboard. Run Excel (with an empty sheet). Click on cell A1. Ctrl-V to paste. Select all and paste back into the Client SS. Again, rows and columns do not matter as long as the handles and column headings are preserved. 6. Choose File|Update. Sch is automagically updated with your edits. You can now save/close the Client SS. My only beef is that you have to regenerate the Client SS each time--no way to re-sync the SS to the database objects. Or is their? >-Original Message- >From: Brooks,Bill [mailto:[EMAIL PROTECTED]] >Sent: Monday, October 08, 2001 11:06 >To: 'Protel EDA Forum' >Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > >*** >Todays forums are sponsored by Ian Martin Limited >Engineering/Technical Placement Specialists >www.ianmartin.com >*** > >Thank you Doug... that actually sounds like a good >work-around. I will try >it. >- Bill Brooks > > >-Original Message- >From: Douglas McDonald [mailto:[EMAIL PROTECTED]] >Sent: Monday, October 08, 2001 2:33 AM >To: Protel EDA Forum >Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > >If you're using the CSV format in conjunction with Microsoft >excel, then >there's a solution which avoids the need to modify numeric fields: > >If you rename the .CSV file to .TXT and then open the .TXT >file in Excel, it > >presents a range of options which includes an option to control the >interpretation of each column. If you select "Text" instead of >the default >"General" then Excel performs no interpretation on the column >and "0805" >reads in as "0805" rather than "805". With CSV files, there >doesn't appear >to be an interpretation option. > > >Doug > > >>From: "Abd ul-Rahman Lomax" <[EMAIL PROTECTED]> >>Reply-To: "Protel EDA Forum" <[EMAIL PROTECTED]> >>To: "Protel EDA Forum" <[EMAIL PROTECTED]> >>Subject: Re: [PEDA] Using Client Spreadsheets to update schematics >>Date: Fri, 05 Oct 2001 14:15:50 -0700 >> >>At 08:25 AM 10/5/01 -0700, Brooks,Bill wrote: >>>I have had trouble with the spreadsheet tools - they always >drop leading >>>zeros... which is a bother, because we use part numbers with leading >>>zeros... Guess there's always a fly in the ointment... It >makes the tool >>>useless to me. >>>- Bill Brooks >> >>A common problem with spreadsheet programs >> >>Edit all your part numbers to prefix a non-numeric, non-arithmetic >>operation character to them. You should be able to do this >globally. An >>apostrophe might do fine, check it out; you could take it out >later if you >>must. >> >>[EMAIL PROTECTED] >>Abdulrahman Lomax >>Easthampton, Massachusetts USA > > >_ >Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** At 08:25 AM 10/5/01 -0700, Brooks,Bill wrote: >I have had trouble with the spreadsheet tools - they always drop leading >zeros... which is a bother, because we use part numbers with leading >zeros... Guess there's always a fly in the ointment... It makes the tool >useless to me. >- Bill Brooks A common problem with spreadsheet programs Edit all your part numbers to prefix a non-numeric, non-arithmetic operation character to them. You should be able to do this globally. An apostrophe might do fine, check it out; you could take it out later if you must. [EMAIL PROTECTED] Abdulrahman Lomax Easthampton, Massachusetts USA * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** I have had trouble with the spreadsheet tools - they always drop leading zeros... which is a bother, because we use part numbers with leading zeros... Guess there's always a fly in the ointment... It makes the tool useless to me. - Bill Brooks -Original Message- From: Richard Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 5:57 AM To: Protel EDA Forum Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > Do you have Dbase on your system? I have tried to export to export to > database without any luck. I do have MS Access but the Protel reference > manual says that only Dbase III and IV are supported. Please tell me I do > > not need to by Dbase to work with that function. > > Bob Cook > > Just use MS Excel, that will import/export in Dbase format. Rich * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** > Do you have Dbase on your system? I have tried to export to export to > database without any luck. I do have MS Access but the Protel reference > manual says that only Dbase III and IV are supported. Please tell me I do > > not need to by Dbase to work with that function. > > Bob Cook > > Just use MS Excel, that will import/export in Dbase format. Rich * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** John Do you have Dbase on your system? I have tried to export to export to database without any luck. I do have MS Access but the Protel reference manual says that only Dbase III and IV are supported. Please tell me I do not need to by Dbase to work with that function. Bob Cook At 12:21 PM 10/5/2001 +1000, you wrote: >Stephen, > >While you're experimenting, you might like to play with the >processes ExportSchematicToDatabase and ImportSchematicFromDatabase. > >Although the import function takes nearly forever, I've found these >two processes to be ideal when I want to make large scale changes to >part fields. > >I use part fields to hold information like: manufacturer part numbers, >distributor order codes, common footprint name (while the actual PCB >footprint might be MO-187-AA, I keep a common name of MSOP-8 in order >to assist the prototype assemblers), etc. I find it much easier to >add all this stuff in Excel, before reimporting to Protel using the >designator as a key (obviously the project needs to be fully annotated >before the export). > >Cheers, > >John Haddy > > > -Original Message- > > From: Abd ul-Rahman Lomax [mailto:[EMAIL PROTECTED]] > > Sent: Friday, 5 October 2001 2:52 PM > > To: Protel EDA Forum > > Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > > > > > At 12:42 AM 10/5/01 +0100, Stephen Casey wrote: > > >Thanks for the fast response. Indeed, to change one part it > > would be easier > > >to double-click it and edit it. I'm just experimenting with the > > software at > > >the moment, and the update from spreadsheet facility could make > > my life much > > >easier when I need to make lots of changes, so I figured that I'd try it > > >out, to see how it worked. I'll investigate the use of processes > > now (only > > >bought the package on Monday!) > > > > Try Edit/Export to Spreadsheet > > > > [EMAIL PROTECTED] > > Abdulrahman Lomax > > Easthampton, Massachusetts USA > > > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** Stephen, While you're experimenting, you might like to play with the processes ExportSchematicToDatabase and ImportSchematicFromDatabase. Although the import function takes nearly forever, I've found these two processes to be ideal when I want to make large scale changes to part fields. I use part fields to hold information like: manufacturer part numbers, distributor order codes, common footprint name (while the actual PCB footprint might be MO-187-AA, I keep a common name of MSOP-8 in order to assist the prototype assemblers), etc. I find it much easier to add all this stuff in Excel, before reimporting to Protel using the designator as a key (obviously the project needs to be fully annotated before the export). Cheers, John Haddy > -Original Message- > From: Abd ul-Rahman Lomax [mailto:[EMAIL PROTECTED]] > Sent: Friday, 5 October 2001 2:52 PM > To: Protel EDA Forum > Subject: Re: [PEDA] Using Client Spreadsheets to update schematics > > > At 12:42 AM 10/5/01 +0100, Stephen Casey wrote: > >Thanks for the fast response. Indeed, to change one part it > would be easier > >to double-click it and edit it. I'm just experimenting with the > software at > >the moment, and the update from spreadsheet facility could make > my life much > >easier when I need to make lots of changes, so I figured that I'd try it > >out, to see how it worked. I'll investigate the use of processes > now (only > >bought the package on Monday!) > > Try Edit/Export to Spreadsheet > > [EMAIL PROTECTED] > Abdulrahman Lomax > Easthampton, Massachusetts USA > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** At 12:42 AM 10/5/01 +0100, Stephen Casey wrote: >Thanks for the fast response. Indeed, to change one part it would be easier >to double-click it and edit it. I'm just experimenting with the software at >the moment, and the update from spreadsheet facility could make my life much >easier when I need to make lots of changes, so I figured that I'd try it >out, to see how it worked. I'll investigate the use of processes now (only >bought the package on Monday!) Try Edit/Export to Spreadsheet [EMAIL PROTECTED] Abdulrahman Lomax Easthampton, Massachusetts USA * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** On 12:42 AM 5/10/2001 +0100, Stephen Casey said: >Hello Ian, > >Thanks for the fast response. Indeed, to change one part it would be easier >to double-click it and edit it. I'm just experimenting with the software at >the moment, and the update from spreadsheet facility could make my life much >easier when I need to make lots of changes, so I figured that I'd try it >out, to see how it worked. I'll investigate the use of processes now (only >bought the package on Monday!) > >Thanks again. > >Steve. Yes I thought that the example you gave was just that. I think you should find the ExportToSpread function at the bottom of the Edit menu in the Sch editor. If not maybe I added it there a long time ago in some frenzy of customization. That is something worth looking into as well - customization. Explore the Client menu (the down arrow to the left of the File menu). Getting to know the quirks of the spreadsheet export is well worthwhile. One thing to remember is that the special hidden handles are not preserved between editing sessions. So keep everything open as you do the changes. One technique I have used is to export to spread and then copy all of the spreadsheet to the clipboard and paste into a more capable spreadsheet program, do macros and fancy edits and then copy and paste back again into the Client Spread window and then update. The other method of getting odd bulk edits done is to use the ASCII form of the Sch and PCBs - and then use a text editor with pattern matching to do quite wonderful changes. This usually requires a manual export from the DDB and then re-importing on completion, if you are using the Access DDB format (we use the Access DDB format for the convenience but some others complain it upsets their auto-version control systems). Also, if you are new to Protel - make a big effort to learn and understand fully the Global search and replace options and fully understand the implications of the match by fields and then think how through careful selection operations (possibly using the global operations to create selections) and other matching you can really speed up your work. Also, the query manager is an under-utilised resource when working in Schematics. All the best, Ian Wilson * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** Hello Ian, Thanks for the fast response. Indeed, to change one part it would be easier to double-click it and edit it. I'm just experimenting with the software at the moment, and the update from spreadsheet facility could make my life much easier when I need to make lots of changes, so I figured that I'd try it out, to see how it worked. I'll investigate the use of processes now (only bought the package on Monday!) Thanks again. Steve. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ian Wilson Sent: 05 October 2001 00:20 To: Protel EDA Forum Subject: Re: [PEDA] Using Client Spreadsheets to update schematics On 11:30 PM 4/10/2001 +0100, Stephen Casey said: >Hello, > >How can edits made in a spreadsheet be updated to a schematic/PCB? If I >modify fields in the generated BOM xls file (I just wanted to change the >'comment' for a part from 'PIC16F872' to 'PIC16F873'), and then select >'Update' from the 'File' menu, I get a message saying: > >'No other document is associated with this spreadsheet. Do not close and >reopen a spreadsheet before performing an Update.' > >But I didn't close and open it - I generated it, opened it, edited it, then >tried to 'Update', without success. > >Thanks for your time. > >Steve. Steve, To update from a spreadsheet you need to use the Sch:ExportToSpread or PCB:ExportToSpread processes - not the BOM generation tools. The ExportToSpread functions export a hidden handle that allows the Spread Update process to identify which part/entity/track/whatever has changed (even if designators have changed in the case of parts). The update *only* works if the spread sheet was created by the ExportToSpread processes. But, to change one comment - surely just double-clicking the part and making the change is easier. All the best, Ian Wilson * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** On 11:30 PM 4/10/2001 +0100, Stephen Casey said: >Hello, > >How can edits made in a spreadsheet be updated to a schematic/PCB? If I >modify fields in the generated BOM xls file (I just wanted to change the >'comment' for a part from 'PIC16F872' to 'PIC16F873'), and then select >'Update' from the 'File' menu, I get a message saying: > >'No other document is associated with this spreadsheet. Do not close and >reopen a spreadsheet before performing an Update.' > >But I didn't close and open it - I generated it, opened it, edited it, then >tried to 'Update', without success. > >Thanks for your time. > >Steve. Steve, To update from a spreadsheet you need to use the Sch:ExportToSpread or PCB:ExportToSpread processes - not the BOM generation tools. The ExportToSpread functions export a hidden handle that allows the Spread Update process to identify which part/entity/track/whatever has changed (even if designators have changed in the case of parts). The update *only* works if the spread sheet was created by the ExportToSpread processes. But, to change one comment - surely just double-clicking the part and making the change is easier. All the best, Ian Wilson * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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] Using Client Spreadsheets to update schematics
*** Todays forums are sponsored by Ian Martin Limited Engineering/Technical Placement Specialists www.ianmartin.com *** Hello, How can edits made in a spreadsheet be updated to a schematic/PCB? If I modify fields in the generated BOM xls file (I just wanted to change the 'comment' for a part from 'PIC16F872' to 'PIC16F873'), and then select 'Update' from the 'File' menu, I get a message saying: 'No other document is associated with this spreadsheet. Do not close and reopen a spreadsheet before performing an Update.' But I didn't close and open it - I generated it, opened it, edited it, then tried to 'Update', without success. Thanks for your time. Steve. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *