Transcript 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
 Miscellaneous projects
 Summary
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.
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
QBase – Example Page
QBase – Main Page
QBase – Deployed to HP iPaq
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
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
SFDC – Database Diagram
SFDC – Layout within Netbeans
SFDC – Data Entry screen
ECN – Original Situation
 Process governing engineering changes was poorly
defined
 Paper based
 Intermittent communication between OEM plants
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.
ECN – Detail Information
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
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
Any Questions?