Did this, and more. Offered to open-source on this forum if someone would be admin. No takers. Codebase now belongs to employer.
Synopsis of what was done and tools used. 0. Python and SQLite 1. Webcrawler using Spyder 2. RSS feed using Google Reader API and pyrfeed 3. Data parser using BeautifulSoup 4. Data output as CSV, which the engineers use excel to view 5. 'sanitized' product data output via static HTML pages for the rest of company Due to JIG/RoHS/REACH/DoE/ErP/NRCan and others pulling me too many directions, then the updates required for 3d ed 60601 and 2d ed 60950, I played with the various data models intermittently for several years starting in late 2007, than a formal project authorized and started 1Q2011. Components tested by engineering staff during 2Q2011, sales people during 3Q2011, then released to all other employees 4Q2011. Bulk of work was done by me in 3 weekends. Testing and integration by staff about 8 weeks. Note that I said 'components'. Write small independent code units that stand alone and do a single data task well. Of course this assumes that you already have a hi-quality body of company product data available with a well-defined schema. If you do not want to do a big code project - use existing tools such as excel or access if you are windoze shop. KISS principle and control data like you would control the BoM for one of your products. Brian -----Original Message----- From: [email protected] [mailto:[email protected]]On Behalf Of Goedderz, Jim Sent: Friday, June 29, 2012 8:16 AM To: [email protected] Subject: database Group, We've been discussing getting a database that would include all our products, and their status as pertains to safety, emc, etc. The object is to be able to sort and see which products have missing certifications, all certifications, etc. and can also store the documents. Can anyone suggest a program that is off the shelf for this use? Thank you. James Goedderz Sr. Principal Engineer-Product Safety Sensormatic Electronics, LLC 561.912.6378 - ---------------------------------------------------------------- This message is from the IEEE Product Safety Engineering Society emc-pstc discussion list. To post a message to the list, send your e-mail to <[email protected]> All emc-pstc postings are archived and searchable on the web at: http://www.ieee-pses.org/emc-pstc.html Attachments are not permitted but the IEEE PSES Online Communities site at http://product-compliance.oc.ieee.org/ can be used for graphics (in well-used formats), large files, etc. Website: http://www.ieee-pses.org/ Instructions: http://listserv.ieee.org/request/user-guide.html List rules: http://www.ieee-pses.org/listrules.html For help, send mail to the list administrators: Scott Douglas <[email protected]> Mike Cantwell <[email protected]> For policy questions, send mail to: Jim Bacher: <[email protected]> David Heald: <[email protected]>
