Windows Phone Thoughts - Daily News, Views, Rants and Raves

Check out the hottest Windows Mobile devices at our Expansys store!

Digital Home Thoughts

Loading feed...

Laptop Thoughts

Loading feed...

Android Thoughts

Loading feed...

Go Back   Thoughts Media Forums > WINDOWS PHONE THOUGHTS > Windows Phone Thoughts Sponsored Articles

Thread Tools Display Modes
Old 03-10-2004, 06:00 AM
Join Date: Dec 2002
Posts: 26
Default Texas Agency Monitors Air Quality with Handhelds and New Wireless Synchronization Tools

<div class='os_post_top_link'><a href='' target='_blank'></a><br /><br /></div>The Texas Natural Resource Conservation Commission (TNRCC) is the lead environmental agency for the state. One of its main responsibilities is analyzing air quality for smog and other contaminants.<br /><br />The process involves collecting air samples from various locations around the state, using canisters designed for that purpose. The canisters are then returned to the agency’s laboratory where chemists analyze the contents using specialized test equipment. The canisters are then cleaned using other machines and sent out again to collect new samples. In addition to keeping accurate records of air sample analysis, the agency also has to carefully track the canisters themselves to ensure the validity of test data. <br /><br />The TNRCC contracted with SyntegraTech to develop a system that would automate the data collection activities associated with analyzing and tracking air quality. <a href="">SyntegraTech</a> develops specialized data collection solutions that include customized applications and its own line of ruggedized Windows CE handheld devices. <br /><br />The new solution allows the agency’s chemists to efficiently record air quality data while making the process of tracking canisters nearly effortless. Drop-down lists speed data entry, while extensive use of bar codes allows chemists to perform large numbers of transactions quickly and accurately. Data collected on the handhelds is transmitted wirelessly at the click to an icon to a database application running on a host PC. <br /><br /><b><span>Streamlined Data Collection</span></b><br />The main menu is used to collect operator details and other data that does not change when performing multiple operations or servicing a number of canisters. Users then select from four process screens based on the activity being performed:<br /><br /><i>Receiving:</i> The chemist receives the canister into the laboratory from wherever the sampling occurred.<br /><br /><i>Sample Analysis:</i> The contents are analyzed for possible contaminants. <br /><br /><i>Cleaning: </i>The chemist evacuates the canister.<br /><br /><i>Shipping:</i> The canister is sent back out to collect additional samples.<br /><br /><img src="" /> <br /><i>Figure 1. Handheld Main Menu for Air Quality Data (created using Visual CE)</i><br /><br />The handheld forms make extensive use of drop-down tables that list possible results from lab tests, allowing chemists to record test data quickly and accurately. Values in the drop-down lists are based on validation tables created in Access and downloaded to the handheld. These validation tables specify values for locations, pressures, operators, and the validation codes themselves.<br /><br />The process typically begins when the chemist performs a Receive transaction. Starting at the main menu, the chemist identifies himself or herself and enters other standard information such as the handheld number and the date. The chemist then taps to access the Receiving form and repetitively scans the bar codes to identify each canister being received. As each canister is scanned, the system automatically picks up the static identifying information from the initial screen, saving time and ensuring accuracy.<br /><br /><img src="" /> <br /><i>Figure 2. Receiving Screen</i><br /><br /><img src="" /> <br />Figure 3. Analysis Screen <br /><br />Bar codes are also placed throughout the lab area to identify testing and cleaning systems, machines within each system, and the individual ports where canisters are connected. For example, when a chemist analyzes an air sample from a canister, he scans the sampling system number, the machine number, the port number, and the canister number to create a transaction based on bar code data. He then taps to enter the measured values from the Visual CE drop-down lists. The application also includes the information from the initial screen to provide a complete record. <br /><br /><img src="" /> <i>Figure 4. Cleaning Screen</i><br /><br /><img src="" /> <br /><i>Figure 5. Shipping Screen</i><br /><br />SyntegraTech created the handheld application using Visual CE from SYWARE (<a href=""></a>) and the desktop application using MS Access 2000. Visual CE is a Windows CE database development tool that interoperates with Access as well as any other ODBC-enabled program, and accepts bar code data as input into data collection fields. A second SYWARE product, mEnable, provides wireless synchronization between the handhelds and the desktop server. <br /><br />The Windows CE application runs on SyntegraTech’s PAT PT-900 data collection device, a rugged yet lightweight unit with integrated keypad, touch screen, and laser scanner. A Proxim RF wireless network card is sealed inside the handheld unit to prevent it from being accidentally unplugged or broken off. The units replace outmoded data collection devices that were based on proprietary technology that was difficult to upgrade or maintain. There were also limitations to the previous data collection software, such as the inability to carry previously entered data forward into new records, requiring repetitive data entry. <br /><br /><span><b>Wireless Synchronization</b></span><br />After data is collected, it is transmitted over a Proxim wireless LAN to an MS Access application running on a desktop host PC. The mEnable communications software allows Windows CE handhelds to wirelessly exchange data with any Windows server (including NT/2000/XP) over a local or wide area network using the standard TCP/IP protocol. <br /><br />The handheld application includes an mEnable icon on every screen, which chemists can tap at any time to instantly send handheld data to the Access application on the server. The system keeps track of each handheld device and its assigned user, recognizing where each transaction came from and who performed it. <br /><br />Records uploaded to the PC are automatically deleted from the handheld device, keeping the handhelds lean and fast, while preventing old records from overwriting new records on the desktop. Also during the wireless synchronization, new validation data, such as operators and regions, is automatically moved to the handheld. <br /><br /><span><b>Desktop Application in MS Access</b></span><br />The Access application manages administrative, processing, and reporting functions on a host PC. This desktop application serves as a holding area for current lab data, allowing chemists to examine it, make corrections, and detect any unusual findings. The Access program also generates a “Chain of Custody” form that accompanies each canister. This form contains all relevant details about the canister (location history, gas analysis, chemist responsible, etc.) as well as a bar code that includes the canister serial number and number of times the canister has gone through the testing process. (This number is automatically incremented during cleaning.)<br /><br /><img src="" /> <br /><i>Figure 6. Desktop Main Menu (MS Access)</i><br /><br /><img src="" /><br /><i>Figure 7. Chain of Custody Form (accompanies each canister)</i><br /><br />Once a day, data is communicated from the Access-based desktop system to the main reporting system, which is written in Visual FoxPro. This process occurs automatically as part of the desktop application, using ODBC. The data then becomes part of a central data repository for use by investigators to monitor and analyze long-term air quality trends. In addition to the increased efficiency, any sudden changes can be detected immediately. <br /><br /><b>For further information, contact: </b><br /><br />Frank Yacano, Director of Business Development <br />SYWARE, Inc. <br />PO Box 425091, Kendall <br />Cambridge, MA 02142 USA <br />Phone: +1 617.497.1300 <br />Fax: +1 617.497.8729<br />Email: <br />Web: <a href=""></a><br /><br />- - - - - - - - - - <br /><span>The above article is a paid advertisement for SYWARE and does not necessarily represent the views of Pocket PC Thoughts.</span>
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT +1. The time now is 03:21 PM.