Ian: How terribly interesting it this thread, for this is precisely what I have been considering over the past couple of days. We are considering revamping our whole library databases and as a result I have been thinking carefully about how to better integrate Protel with our own internal parts inventory database. I envision being able to use a "place component" command that would allow for dynamic access to our inventory database which would then be able to fill in the footprint field, the value field, the internal part number according to the listed items in our internal database. The key attribute for selection would be the internal part number by which all other information could be extracted from the database and added to the part attributes. Please feel free to call me @ (250) 763-2329 ext. 225 and we can discuss your time and costs for development. This would be a very valuable tool to our company !
Daniel Webster Northern Airborne Technology Kelowna, BC, Canada -----Original Message----- From: Ian Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 1:45 AM To: Protel EDA Forum Subject: Re: [PEDA] CSExtractFromExcel Server @ Ian Wilson On 10:16 AM 2/05/2002 +0200, Schmitt Michael said: >Hello Ian, > >i had just looked into your server and it looks like that what i was >searching but i cannot use it as it is. > >the reason ist simple. as far as i understand your server it does only check >ONE object in the schemtic with ONE object in the excel spreadsheet. >but i need to check : > >1. is the footprint like 0805 the same > >AND > >2. is the value (parttype) 10k the same > >then if, and only if, both fields are matched i need to copy the stuff from >the selected colums to the fileds in the schematic. Michael, I'll think about it. The server is really designed to facilitate the import into the sch of all the fields based on a company part number that is either entered at Sch design time into a part field or at Sch Lib design time into a read-only (library) field. There is a possible problem with extending the search across multiple fields - it may complicate the access into Excel slightly. I have three ways of going here: 1) add one or two possible match fields 2) be very general and allow the user to add as many match fields as they wish 3) say tough luck - it does what it does. 1) is probably simple enough but no doubt someone will find a limitation with it. 2) is more time to program. 3) is not really like me so, as I said, I will think about it. The extra money I would get from an extension like this is very unlikely to cover my time in doing it but I will consider it. (These servers are by no means big money spinners, more a loss-making hobby that others may find useful.) Anyone else with a desire to be able to fill in all the Sch part attributes from an external source, where there is matching required on more than one field? How many matches would suffice? 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://email@example.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *