Date: Thu, 26 May 2011 12:13:36 -0400
Reply-To: DCHAS-L Discussion List <DCHAS-L**At_Symbol_Here**LIST.UVM.EDU>
Sender: DCHAS-L Discussion List <DCHAS-L**At_Symbol_Here**LIST.UVM.EDU>
From: ILPI <info**At_Symbol_Here**ILPI.COM>
Subject: Re: automated audit system?
In-Reply-To: <OFCBAA2AA7.DF1271AF-ON8525789C.0052FB6D-8525789C.00533CED**At_Symbol_Here**>

I haven't done what you're talking about, but it is straightforward to build your own system that runs on *any* portable device.  Simply create your inspection form as an HTML web page and have the Submit button send the results to your server or email in-box.   This gives you the advantages of being platform-agnostic (as much as I love my iPad 2 and the shares of AAPL that I bought back in 1997 at $4 each) and being able to customize/tweak for your specific needs.  And if you aren't HTML-saavy, this is a project a competent work study could pound out in a day or two.

If you want data collection/analysis, back-end processing can be tied to a database if you are sending the data to a server.  If you are emailing it to yourself (or others), you can use an AppleScript that will fire up automatically when the report hits your inbox and dump the data into a database or Excel.   Again, this is something that is really not that hard to do in-house.  For example, I describe how you can take email data into QuickBooks and do all sorts of stuff with it here: http: // and it would be even easier in your case because you can tag the data before it gets to your inbox.  Heck, you could have the script set up an iCal reminder for the next inspection date.

Of course, if you are looking for something that has bells and whistles  then a commercial system is probably better.  Depends on your size and needs, obviously.

Rob Toreki

Safety Emporium - Lab & Safety Supplies featuring brand names
you know and trust.  Visit us at
esales**At_Symbol_Here**  or toll-free: (866) 326-5412
Fax: (856) 553-6154, PO Box 1003, Blackwood, NJ 08012

On May 26, 2011, at 11:09 AM, Kim Auletta wrote:

Our department is looking to start automating our inspections/audits and collect data in the field using ipads. I did a web demo for Q5 Systems & thought it was interesting
 ( Is anyone using it? Do you like it or not?

Is anyone else using a different automated system for inspections?


Kim Auletta
Lab Safety Specialist
EH&S    Z=6200
Stony Brook University
kauletta**At_Symbol_Here**< /a>
FAX: 631-632-9683
EH&S Web site:

Remember to wash your hands!

Previous post   |  Top of Page   |   Next post

The content of this page reflects the personal opinion(s) of the author(s) only, not the American Chemical Society, ILPI, Safety Emporium, or any other party. Use of any information on this page is at the reader's own risk. Unauthorized reproduction of these materials is prohibited. Send questions/comments about the archive to
The maintenance and hosting of the DCHAS-L archive is provided through the generous support of Safety Emporium.