I have the dilemma of having a few thousand different transistors on hand and finding a sub within my collection is time consuming. I had an idea of potentially writing a winforms (windows) application which would:
1) function to import what transistors i have via single column excel document into the winforms application. Once submitted, have the app loop thru the rows, parse alltransistors.com (emulating a browser) and return scraped results of parameters, save to local db or excel file.
2) textbox to enter in the transistor to be subbed.
3) once a value is entered in textbox, have a routine emulate a browser to parse alltransistors.com and scrape the results and parameters to the application and save in a local database or excel file. Display results in a grid.
4) if returned results show you have one onhand, highlight those transistors in a grid within the app. If not, show possible subs, giving fairchild subs higher priority maybe.
5) perhaps have a list of known good subs collected on AK pre imported into the app, if no matches, proceed to alltransistors parsing routine.
6) an update routine to grab latest excel list of good known subs from the web into the application, maybe a server of an AK member
7) perhaps a reverse lookup method based on selectable transistor parameters to help compare against onhand devices.
This could be made into a webapp eventually. Waste of time or useful? Alltransistors.com reliable enuf for data? Sometimes i find misinformation on that site comparing to manufacturer datasheets.
