1 / 18

Web Development Projects

Web Development Projects. Presented by Mark McDonald. Introduction. Three projects for Rittal-CSM QBase – Quality Assurance data – ASP.NET SFDC – Shopfloor Data Collection – Java EE ECN – coordinates electronic change notifications – Lotus Notes and XPages

callum
Download Presentation

Web Development Projects

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web Development Projects Presented by Mark McDonald

  2. Introduction • Three projects for Rittal-CSM • QBase – Quality Assurance data – ASP.NET • SFDC – Shopfloor Data Collection – Java EE • ECN – coordinates electronic change notifications – Lotus Notes and XPages • Miscellaneous projects • Summary

  3. QBase – Original situation • Used to record results of Quality Inspection plans • Results were being recorded on bits of paper on the shop floor. • Data was not being entered until the inspector returned to the office. • Inefficient – especially if the wrong information was written down.

  4. QBase - Solution • Upgrade existing Access database to MS SQL server database • ASP.NET suite of pages to replicate data entry process • OLE DB access • Data bound components • HP iPAQs , using Windows CE connected to the local Wi-Fi network

  5. QBase – Example Page

  6. QBase – Main Page

  7. QBase – Deployed to HP iPaq

  8. SFDC – Original Situation • Initially used to record Overall Equipment Efficiency • Original system comprised of a large number of spreadsheets • Large degree of hard coding • Inflexible • Time consuming to update each year

  9. SFDC - Solution • Developed from scratch after a lot of research • Classic 3 tier architecture • Visual web faces application – implements JSF standards • Glassfish Java EE application server • MS SQL server backend accessed via JDBC and Toplink • Reports developed and deployed via MS SQL Reporting Services

  10. SFDC – Database Diagram

  11. SFDC – Layout within Netbeans

  12. SFDC – Data Entry screen

  13. ECN – Original Situation • Process governing engineering changes was poorly defined • Paper based • Intermittent communication between OEM plants

  14. ECN - Solution • Process defined with stakeholders • Initially implemented as a Lotus Notes database due to workflow capabilities • XPages allowed the database to be web enabled - combination of Javascript and Lotusscript • OEM plants can access the database • Lotus Notes databases are document oriented(document-based, schema-less, loosely structured) as opposed to relational.

  15. ECN – Detail Information

  16. Miscellaneous projects • Wordpress for my personal site - http://www.markmcdonald.co.uk • Joomla for a local cricket site and CSM intranet • Set up an OSCommerce website as a University project - selling women’s underwear! • Dabbled a bit with Flash for my old website - http://www.markmcdonald.co.uk/Flash/McDonald.swf

  17. Summary • 3 projects utilising different technology • 3 different ways of providing the same thing - dynamic database driven web applications that get the job done • I’m lucky because I enjoy application development

  18. THANK YOU Any Questions?

More Related