Pocket PC Solutions for Waste Management

In the last few months my team has been involved in a number of different Waste Management projects using Pocket PC computers. I would not have predicted this industry as a niche market for mobile solutions. Let me briefly outline the problem and solution.

The European Community has passed a series of laws regulating the handling and disposal of waste and recyclable materials. I also read in the newspaper last week that the state of Maine has recently passed similar laws. Waste producers must have an audit trail or documented "chain of custody" of their waste from origin to disposal. They must maintain records of the amount, and type of waste, when it was picked up by a trucking company and delivered to a collection facility, and ultimately delivered to the final disposal company. This audit trail involves a lot of paper and must be available for access by government agencies that audit this process.

The waste collecting trucking companies need to collect data at the site of the waste pick-up, and they have been seeking a good solution to this paper headache.

The solution involves handheld PDAs using MobileDataforce's PointSync that are integrated to a Waste Management applications in the office. This Waste Management application is often web enabled to allow the waste producer to view their "pick-up reports" for auditing purposes in near real-time.

The value of this applications goes beyond just data collection efficiencies provided to the waste collecting trucking companies. The value is in keeping an electronic chain of custody record that is accessible to all participants in near real time.

Route Delivery - PDAs & Handheld Computers

My team is just wrapping up the implementation of an interesting project that involves route sales and delivery. This project involves the usual features on their PDA software such as:

1. Delivery person login/password, time/date stamp
2. Store look-up query
3. Review of store inventory data
4. Product delivery update
5. Inventory update
6. Sign-off

The unique part of this software application developed in PointSync is the "planogram". This PointSync micro-application predicts how much product the specific store usually requires between deliveries. For example - store 104 averages 6 boxes of widgets number 97 between deliveries. The delivery driver/sales person does not have to determine the appropriate number, the application predicts it based upon historic data in the database on the handheld computer.

This kind of application is interesting because rather than simply displaying data, it uses this data to "think" on behalf of the user and to provide instructions to the user. This is true business process automation at work on a PDA.

New PDA Website

Conrad, a software developer and web guy on our team, has created our first PDA formatted website. This website will allow PDA and handheld computer users with WiFi or mobile phone connections to view information on our software solutions, download applications, view screen shots of applications in our library and much more - all formatted for PDA screens. This new website is small now, but we have ambitious plans that will keep it growing into an import resource for companies researching our mobile software solutions.

PDAs, Elk, RFID & Geospatial Data Collection

This last week I had the opportunity to meet with 2 different state government agencies here in the USA. We discussed many different business processes that lended themselves to mobilization, but one stood out for its uniqueness.

In Idaho people farm elk, not all people, some farm potatoes. These elk farmers need to protect their herds against disease, and document the fact that their herds are disease free. These farmers must register the locations of their herds using GPS coordinates, and then collect geospatial data concerning the details of the herd, their immunizations, history, etc. This is becoming increasingly important, since if one herd has a disease, it could impact the sales of all meat in that region. Farmers must not only protect their animals, but effectively market and promote the health status of their herd in order to continue selling during times of disease.

It is not enough to document the location and health of your herd, one must document the location and health of each individual animal. RFID ear tags are often a good solution to this. In my discussions last week concerning the elk farmers, these farmers created collection zones where all animals walk through a specific location, whether a water trough, feedlot, or salt lick. These locations funnel the animals through narrow paths where RFID readers can collect and inventory the details of the herds and individual animals. This information allows these large animals to be effectively managed and documented without trauma and risk of injuring the animals through large round-ups and corral lock-ups. Elk are strong, wild and flighty and it is dangerous to handle them. Therefore, the less you need to confine and handle them, the better.

PDAs are used through-out this process to document information on herds, pastures, health, births, injuries, deaths, GPS coordinates and much more. MobileDataforce's PointSync solution can effectively be used to develop and customize these mobile applications.

PDAs in the Automotive Industry

Recently our team has been working on numerous projects and proposals in the automotive industry sector. I am impressed by the broad range of applications that are being brought to our attention.

1. Marketing and consumer input - PDAs are being used to gather consumer feedback and information after a person test drives a new car
2. Automobile Inspections - PDAs are being used to automate the process of inspecting automobiles at auctions
3. Work Orders, Part 1 - detailers at automobile dealerships are tracking work completed on PDAs
4. Work Orders, Part 2 - third party mobile auto body shops are using PDAs to track windshield repair, dent removal, spot painting, and headlight repair on used cars. The PDA based work orders are used to document work and to invoice for the work.
5. Banking in the Automotive Industry - PDAs are being used by banks to verify automobile inventory at a dealership
6. Location based applications - PDAs with RFID readers are being used to identify the location of a specific car in a large lot. Some of these are using a triangulation of long range RFID signals.
7. Industrial trucks - RFID applications are being used to track all portable equipment in the back of service trucks. Items such as ladders, generators, tools, etc. are each given an RFID tag. If the service truck drives away from the tools, the RFID signals will be lost and a warning is sent to the driver's PDA that identifies the tools left behind. This requires an RFID reader in the service truck, and tags on all appropriate tools.

These are all very interesting projects that have come across our desks recently. It is amazing how many business processes can benefit from the use of appropriate mobile technology in the field.

Fleet Management - Handhelds and Satellites

Yesterday Wireless Matrix and Psion Teklogix published press releases concerning a project they both did using MobileDataforce's PointSync that involved some interesting technology in the transportation of rail crews. Here is an excerpt:

The new rugged system enables RailCrewXpress to record the location and transportation activity of the company's vehicle fleet in real-time. RailCrewXpress handles the majority of the U.S. Class 1 railway crew transportation needs, including crew pick ups, transport to trains, shuttling crew to hotels for overnight stays and in-yard crew transport. With its new mobile computing solution, RailCrewXpress has complete visibility into the cargo and location of its fleet at all times.

This was a fun project that my team delivered. It involved a combination of GPRS and Satellite uplink technologies and our PointSync software solution on Psion Teklogix handheld computers mounted to the dashboard of the vehicles. When a vehicle in the fleet could not communicate using GPRS(mobile phone communication) then it would roll over to a satellite uplink. When using the satellite uplink, a different kind of synchronization is initiated that sends a smaller data set. Lot's of fun and pushing the envelope.

PointSync 3.0 Released

My engineering team has put over 12 man years into PointSync 3.0, and they are both thrilled and relieved to have it finished. I think we should give them the afternoon off before we start on version 4.0. In all seriousness, our engineers deserve a big congratulations! MobileDataforce's successes are the result of their amazing skills.

I am going to advertise a bit. PointSync is the culmination of all that we have learned about mobile software development tools since 2000. We wanted a comprehensive rapid application development environment that gives both novices and coders the ability to develop powerful end-to-end turnkey mobile solutions and PointSync accomplishes that.

You can download the PointSync Developer, and sample PointSync applications to view on your handheld computer. Let me know your thoughts!

Business PDA users a 'dream segment' for mobile operators

This article is interesting and reinforces what I learned in several discussions with wireless carriers in 2005-

Business PDA users a 'dream segment' for mobile operators

The latest Wireless Enterprise Strategies service report from Strategy Analytics, "Profiling the PDA User: Strategies for Generating Network Traffic," affirms that business PDA users represent a prime segment which mobile operators and OEMs should actively identify and target for wireless solution sales. Device set-up, email synchronization and content creation must be dramatically reengineered.Cliff Raskind, Director of the Wireless Enterprise Strategies service commented, "When mobile operators survey their base of business customers, PDA users potentially represent a `dream segment' of users that is tailor-made for upselling many wireless data solutions enabled by next generation networks. While over half of the PDA users remain unconnected beyond simple text messaging, operators, device OEMs and solutions providers have failed to bridge a number of critical performance deficits relating to set-up and ease of use." David Kerr, Vice President of the Global Wireless Practice, noted, "PDA users spend more on mobility, experience much greater frustration when disconnected. They report strong interest in a basket of value added services. So far, however, a combination of device-centric and network-resident barriers have conspired to suppress attachment rates beyond the initial corner office inbox junkies. While improved data economics coupled with expanding device portfolios from Microsoft Mobile partners, Symbian camp evangelists and aspiring Asian vendors all augur well for the future, no dominant paradigm has yet emerged to transition these PDA users into true converged device solutions customers." This report provides a snapshot of the potentially lucrative PDA segment, revealing why they should be in the crosshairs of all mobile operators and device OEMs wishing to succeed in the business market.Other key findings from the report include: · At 105 Euros per month, PDA users spend 53 percent more than non-PDA users on mobile services; · PDA users average 34 percent more minutes of use than non-PDA users; · PDA users are better educated and more likely to buy premium products; · PDA users require more frequent access to email, CRM and other network-based applications.

PDAs and Engineers

Engineers need PDAs more than most. Especially those engineers walking the job site collecting data on paper forms and clipboards for their clients. Common tasks are:

• Phase 1 Site Assessments
• Nuclear Density Tests
• Soil samples
• Ground Water
• Concrete testing
• Many more

In addition to these field tests, often samples need to be documented and sent to a lab for analysis. This involves a "chain of custody". A chain of custody is when a sample is collected by a field technician, labeled and sent to a lab. The lab needs to document their receipt of the sample, analyze it, and report the results back to the engineering firm which passes this information back to their client. This process involves a chain of participants that all need to document their relationship to the test sample and test results from beginning to end.

This brief explanation of a simple process, identifies the necessity for documentation. Since the process starts in the field, it is appropriate to begin thinking about how data collection in the field could be automated. This is where handheld PDAs come in.

PDAs with customized engineering software can do the following:

• Capture GPS readings of the job site and the test site
• Digital signature of the person collecting the test data and samples
• Date, Time of test
• Identification of the client and project this test is billed to
• Weather conditions at the time of the test
• Physical description of the job and test site
• Documentation of the test performed

This information can all be documented on the PDA and wirelessly synchronized to the office database from the field. This saves both the engineer and the administration staff the work of re-typing the data again in the office.

Enterprise Mobility Framework

A large utility in the NW of the USA contacted us a few months back with an interesting problem. They had 7 enteprise applications that their field services teams needed to access from the field with handheld computers. Each of these enterprise applications had their own mobile client (software that runs on a handheld computer). The problem is the utility company did not want to support the following:

• 7 different synchronization methodologies
• 7 different mobile data security architectures
• 7 different ways of customizing mobile applications
• 7 different integration methodologies
• 7 different applications with different handheld computer support
• 7 different technical support centers
• 7 dfferent mobile software application vendors

The request they brought to my sales team was, "Can MobileDataforce help us develop a standardized mobility framework that can integrate 7 different enterprise applications with 1 mobile enterprise framework?" They wanted to purchase 1 solution that could provide all their requirements, which would save them a great deal of time, money and headaches.

That is exactly what my engineering team has been developing since 2000. The result is the new PointSync 3.0.

Handheld Inspections at Government Agencies

I had the privilege of meeting with a state agency yesterday to discuss field data collection and inspections. This team of government employed IT professionals was tasked with automating many different kinds of inspections. I was amazed at the large number of inspections one team must manage. Today it is nearly all done on paper. The more we discussed the various projects and inspection responsibilities, the greater the ROI was for automating them.

Here are some of the inspections identified:

• Boxed and shipped fresh produce
• Sugar content of produce
• Ground water quality
• Registered cattle pastures
• Certified immunization of cattle
• RFID cattle tracking
• Inspecting and certifying fertilizers
• Dairy farm inspections
• Dairy processing plant inspections
• Nitrogen levels on fields
• Insect and pest control
• much more....

The list was enormous and I was impressed with how mobilizing these inspections could save this government agency a considerable amount of money. I've got some work to do!

Mobilizing Facilities Management and CMMS

FM or facilities management is an industry that utilizes our mobility software solutions for handheld PDAs in large numbers. This industry has over 18,000 members registered with the IFMA, International Facilities Management Association alone. The business processes and tasks that FM users most often want to mobilize are the following:

• Inventory
• Work Orders/service orders
• Preventative maintenance orders
• CMMS - computerized maintenance management systems - custodial/janitorial services
• Hazardous material tracking
• Server room management
• Inspections of all kinds
• Asset Management
• Health & Safety inspections
• Contractor Quality Assurance
• Moving instructions and details
• Office leasing information
• Fire extinguisher and emergency medical equipment inspections
• Much more...

FM professionals often are responsible for the operations of large buildings, campuses, warehouses, and remote properties. Their work consists of gathering all kinds of data from remote areas and entering this data into a central database where it can be managed by any number of FM software applications.

The challenge is not so much managing the data once it is in their FM software application, it is collecting the data and getting in entered into the FM software. This is where MobileDataforce comes in. Our software solutions for PDAs and handheld computers enable you to quickly create electronic forms and mobile applications that can be used in the field to collect data and then synchronize it directly into the FM software application. Our integration technology makes it a relatively simple process to integrate with most FM software applications.

Remote data collection is a big need, but also the ability to look up information on a building, maintenance project, business process or piece of equipment while you are inspecting the facilities. This requires your handheld PDA to have a RDBMS (relational database management system) on your PDA. Our PointSync solution enables you to replicate your FM application database on your handheld, so you can query information, and update information in the field. Any changes that you make in the field, will be updated to your FM application upon synchronization.

Adding Value to Your PDA

Once you have jumped into the world of PDAs and learned how to check your email, contacts, calendar, etc., what can you do with your PDA that can add to the bottom-line of your business? The following list contains some ideas:

1. Replace paper forms that you use in the field, with electronic forms on your PDA. These can be automatically synchronized with your back-office database applications.
2. Load your product catalogs to your handheld PDA with price and product attributes
3. Load work order/service orders onto your PDA so you can fill them out and synchronize remotely.
4. Develop an inventory update application so you can check inventory levels and update them from the field.
5. If you are an inspector, or dabble in filling out inspection forms, create electronic versions that automatically load to your database or spreadsheet.
6. Add a bar code scanner to your PDA so you can scan product barcodes and see inventory levels.
7. Add GPS to your PDA so you can quickly find your next job site or customer location.
8. Are you filling out time sheets in the field? If you are a supervisor, you can enter the timesheets of your entire crew and synchronize this information to your office remotely.
9. Do you need to compute a lot of numbers in the field? Do the results of these numbers change what you should be doing in the field? Create a mobile application that can compute your input data and direct your actions based upon results. We work with a lot of inspection processes where the result of the inspect impacts the next step in the business process.
10. Print forms while in the field. Once your electronic form or mobile database application in your PDA has data in it, you can print it to a mobile printer. You can look up historic information and print this for your customers as well.
11. Quality Assurance forms - we have a lot of large companies that send out Quality Assurance auditors to inspect their facilities and processes. You can easily replace these paper processes with mobile applications on your PDA. The value? Quick input of field data so you can immediate analyze the data and implement Q&A improvements.

This list identifies a few of the most common uses for PDAs in the field. All of these applications add value to your PDAs and handheld computers.

MobileDataforce, http://www.mobiledataforce.com provides software solutions for quickly and affordably developing and implementing these kinds of solutions.

Implementing Mobile Projects

Now that you have decided to mobilize one or more business processes, how do you choose a system integrator or consultant that can implement it? There are a few basic details that all consultants who develop and implement mobile solutions should ask you. If they don't ask you these questions, you may want to look for a more experience implementation team.

Here are some sample questions:

• What handheld hardware will you be using(make and model)?
• What add-on accessories will you be using (GPS, RFID, Digital Imager, Barcode, etc)?
• Where and how will the user be synchronizing their handheld(at home, office, shop, WiFi, GPRS, cradle, bluetooth, Satellite)?
• What operating system does your handheld computer have (Win CE.Net, Pocket PC, Palm)?
• Do the users have working conditions that will impact our solution design (users wear gloves and need big touch screen buttons)?
• What business process will be mobilized (work order, invoice, time sheet, project status, etc.)?
• What database do we need to connect to? How do we access it? Can you provide a data model?
• Do you need mobile printing?
• Do you need formatted reports? Will they be printed in the field, or in the office?
• Do you need internet access to this data? If so, who will design the website?
• Are you going to conduct a "proof-of-concept" first? If so, how many users? What is included in the POC. How do we measure success?
• Concerning roll-outs - how are we going to roll out this solution to your billion mobile users? How many at a time?
• How are you going to train the users?
• When are you going to have the handheld computers delivered?
• Who will install the software and document how to use them in the field?

These are a few of the questions that an experienced team of consultants and systems integrators will ask you before they provide you with a quote. If a consultant does not ask these questions upfront, it does not mean they are bad, just inexperienced and will likely not meet their timelines and cost projections.

Paper Forms or Electronic Forms on PDAs?

Many companies that contact my sales teams are seeking to replace their paper and clipboard processes with electronic forms on PDAs. Let's take a few minutes to understand why this is most often a good idea, but not always.

What is the downside to using a paper form with a clipboard?

1. Paper forms are often submitted with missing information. This lack of completeness wastes considerable time in the office as staff try to contact the original author and gather the missing data.
2. Paper forms can often be left on the clipboard for days or weeks, so there is a delay in getting the information transferred from the paper form into a computer software application for processing.
3. Handwriting on the paper forms is often hard to interpret. This allows for bad data entry into the computer system. Bad data in - bad data out.
4. Paper forms can not validate the information entered on them. So invalid information can be written on the paper forms.
5. Paper forms are easily misplaced, lost or damaged by environmental factors and irresponsibility.
6. Paper forms can not effectively provide you with a list of all possible correct answers. Electronic forms can provide you with "pick lists" or "drop down" menus that limit your answers to only valid ones.
7. Paper forms do not provide you with the ability to query all "products" in a catalog. Electronic forms that are tied to a database on your handheld PDA, can enable you to "look-up" lists and databases with product listings and product attributes that will automatically fill in the electronic form.
8. Paper forms do not compute. Electronic forms can compute math, invoice totals, elasped time on a projects, milage, square feet, and much more.
9. Paper forms can not link to many other applications that can provide GPS coordinates, RFID reading, bar code scanning, digital images, CAD drawings, etc.

The above list identifies some of the deficiencies of a paper form, however, there are times when either a paper form or a full sized laptop is simply more efficient. I find that when there are a great deal of notes to be taken, it is not efficient to attempt this on the limited screens that PDAs provide. If you have 3 pages of observations and notes to be entered, you need to either handwrite on paper, or use a full sized keyboard connected to a laptop or desktop. Another case is when you have large maps or CAD drawings to view. A PDA screen can be used for specific views, but PDAs are not practical for viewing large areas. In this case either a laptop, Tablet PC or paper version is more efficient and saves your eyes.

Working with a Budget, Part 4

In segments 1-3 we discussed the various parts of a mobility project, and the different options within these parts. Now let's bring all these together and discuss how they impact the price of a mobility project and our strategy.

1. Someone needs to develop the "mobile client" software that synchronizes with your Work Order Management software in the office. Is this going to be your cousin Bob, or a professional IT developer or consultant? If you are going to use a professional, get a quote on the project costs.
2. Are you going to develop your own mobile software from scratch, or purchase a "software development kit" for mobile solutions from a company like MobileDataforce, http://www.mobiledataforce.com? Get a quote from the software vendor.
3. Are you going to buy a $300 consumer grade PDA that can be easily broken when dropped, or are you going to spend $1,500 on a water resistant and dust resistant handheld that can be dropped to concrete from 6 feet. Search on ruggedized handhelds or call MobileDataforce for referrals.
4. Do you want to call your field service technicians on their mobile phones and read them their next work order, or do you want to have it synchronized out to their handheld device in the field? Contact your wireless service provider for data connection quotes using PDAs or handheld computers with data cards.

Once you have made up your mind about these various issues and received quotes, it is time to set project schedules, implementation and test plans.

Working with a Budget, Part 3

In the previous 2 segments of this discussion we covered:

• Work order management systems
• "Mobile client" software that runs on the handheld computer and synchronizes with your work order management system
• How to determine the kind of handheld computer to purchase

Now we are going to explore some of the options for dispatching work orders to your teams in the field.

Handheld computers can now be PDA phones. You can buy a Pocket PC Phone from just about any mobile wireless carrier now days. Palm is even coming out with a Treo 700 Pocket PC Phone this Quarter. The challenge with these devices are their lack of durability when Fumble Finger Fred is using them.

Ruggedized handheld computers can also come with wireless data cards built-in. These allow you to send and receive data using the mobile wirless carriers networks, but often do not include "voice" communications. This capabilitiy enables your field work crews to both send and receive work order data at the push of a button on their "mobile client" software. So the office can write up "service orders" and when the field crew pushes a synchronization button on their handheld, any new service orders will be dispatched, and completed service orders would be uploaded to the office.

A number of handheld computer manufacturers are also adding VoIP to their handhelds. VoIP is "voice over IP or internet protocals". What does this mean? It means you can talk to your office through the microphone in your handheld computer using the internet connection, rather than the phone connection. The vision here is the following - a junior service technician can call the office asking for advice on a repair job. The supervisor asks junior for a digital photo of the object under repair. Junior holds up the handheld computer and snaps a photo. The photo is uploaded through the data connection to the office. The supervior reviews the photo and talks him through the repair over the VoIP connection. Mission accomplished.

...more in Part 4

Working with a Budget, Part 2

In the last segment we assumed you already had a functioning "work order management system" in the office. As a first step you needed to find a "mobile client" software package that would synchronize with your "work order management system". MobileDataforce has a "software development kit" for PointSync http://www.mobiledataforce.com/pointsync/pointsync_developer.asp that would resolve this issue. So the next step is determining which handheld computers to use.

Here are a few thoughts on determining which handheld computers to use:

• Do you need a numeric, or alpha numeric keyboard on your handheld? If not you can save money by simply writing on the touch screen with your stylus, or using touch screen buttons.
• Do you need add-ons like a bar code scanner, RFID reader, digital camera, GPS or electric chainsaw? These can be very useful, but add costs to your handheld.
• How rugged does your handheld need to be? If you are repairing desktop tape despensers, you could probably get buy with a $300 consumer grade handheld, but if you are climbing fences, wading through sewage ponds, or immitating a crash test dummy, you may want to seriously considering investing in a ruggedized device that is in the range of $1,500.
• Handheld computers have a standardized rating system that identifies how "rugged" they are. So when considering which handheld device you need, read up on the ruggedized ratings. This will tell you how many times Fumble Fingered Fred can drop the handheld while washing the outside of the windows on the 19th floor.

...more in Part 3

Working with a Budget, Part 1

OK, so you want to know how much it will cost to get your 10 field service technicians set-up with handheld computers so they can be dispatched work/service orders in the field. Let's explore the issues?

What are the major pieces to this mobility solution/project?

-Work order management software in the office (hopefully this is already in place)
-Mobile client software (software on your handheld computer) that synchronizes with your work order management software in the office
-Handheld computers
-Data network through your favorite wireless carrier (e.g. Verizon, Sprint, Cingular, Vodaphone, Orange, etc.)

The first task is to find a "mobile client" software package that will synchronize with your work order management application. The problem is your cousin Bob developed your work order management system 4 years ago for a high school project and he is now back in prison. What next? You may want to find a company like MobileDataforce, http://www.mobiledataforce.com that provides software that you can use to rapidly develop and configure a mobile client that can synchronize with your office software. If you have enough in your budget, it is usually a faster and easier process to involve my professional services team, or to get one of your local talented IT consultant, assuming they are out on probation, to do this for you.

...more in Part 2

Mobile Solutions a Consultant's Nightmare

The first time is not always your best. Consultants and integrators get better the 2nd, 3rd and 4th time they have implemented the same mobile solutions. The problem is- nearly every mobility project has unique and different requires.

-different handheld computers
-different add-on hardware accessories
-integration to different backend database applications
-different business logic needed on the mobile application
-different ways of doing the same business
-different screen layouts
-different data requirements
-different synchronization methodologies

How can a consultant or an integrator profitably and successfully implement these mobility projects? The answer - find what is common about all of these projects and productize a solution that can be flexible and powerful enough to be used over and over again to implement mobility projects. All of us involved in consulting know that reusing previously made code, and leveraging your expereince is how you gain the efficiencies that make your projects profitable.

My Engineering team has been studying mobility projects since 2000, and productizing the results of their studies. The result is our PointSync and Intercue Mobility Suite solutions. Both of these platforms allow you to consistently produce high quality solutions on standardized mobility platforms. Once your team is familiar with using these "rapid application development solutions for mobile environments" (RADs-ME), they can rapidly develop, edit and customize mobile solutions for new customers.

Secret ROIs from Mobilizing Business Solutions

There are many obvious advantages and cost savings that come from mobilizing paper processes. You enter the data once in the field and wirelessly synchronize with your database application. You avoid the office staff needing to re-type all the information, you avoid introducing typos during data entry, and you speed up the process of making the data available for other mission critical business applications and business analytics. Yet there are many not so obvious advantages to replacing paper processes. Here are a few for your consideration:

-Mobile field workers don't have to drive to the office just to deliver their paper forms
-Mobile field workers don't have to drive to the office just to pick-up their paper forms and assignments
-Invoicing can be completed much quicker since work can be updated from the field for immediate processing (better cash management)
-When using handheld computers you can avoid issues with bad handwriting
-Mobile software applications can validate the data entered at the time of entry
-You can attach digital photos directly to your data on the handheld
-You can push data out to the handheld so the field user has continuously updated information
-Field users can preform their own database queries on their handheld, thus avoiding the need to use office staff
-Handheld computers that have GPS functionality with mapping software can help the field worker find their next job site without asking office staff for directions
-Handheld computers with GPS functionality can report the location of the field worker to help managers better organize service responses
-Handheld computers can be used not only to collect data, but to compute the data and show results in the field
-Buttons on the screen of your mobile application can be configured to perform all kinds of queries, computations, analytics and many more time consuming features (recently we created a mobile solution that would provide a route delivery driver with predictive product re-stocking numbers at the push of a button based upon the past 12 months stocking numbers)
-Disciplined business processes - mobile software solutions can be configured to ensure the field user follows the appropriate business processes based upon the data entered (a specific answer can force a separate business process - for example - the geiger counter attached to your handheld shows dangerous levels of radiation - a message pops-up warning you to cover your private parts with a lead fig leaf)

These are just a few of the not so obvious benefits of mobilizing. Please email me any additions that you want me to add to this list.

Mobilizing Business Solutions

Over the past decade companies have invested heavily into ERPs and other enterprise software applications only to realize that a sizable portion of their employees are mobile and do not have access to these expensive investments. Managers are now asking their IT departments for ways to "mobilize" these existing enterprise software applications. Let's spend a few minutes discussing what it means to "mobilize" a business solution.

Mobile application development at a high level involves providing the field user with either a connected, or a disconnected mobile application on a handheld computer or laptop. Connected applications are dependent on a "live" connection using WiFi or mobile phone networks to access the enterprise software application. Disconnected applications have the ability to continue functioning whether there is a "live" connection or not. Most experts in mobility today recommend developing applications that can be connected or disconnected so as not to interrupt the productivity of a mobile workforce.

A disconnected mobile application needs to be able to store data on the handheld computer (i.e. in a mobile database or XML file), and then be able to synchronize all the changed data when a connection to the enterprise database application is again available. This allows the mobile field force to continue adding, editing, querying and printing data in a disconnected mode while working remotely in the field.

The software components that are necessary to develop a disconnected database centric mobile application are:

-Mobile application (GUI Interface) created for the screen size of your handheld or laptop computer
-Navigation on the screens and between screens
-Customizable business logic under the GUI interface
-Mobile database technology to store all required data on the handheld computer
-Synchronization technology to synchronize changed or edited data between the handheld computer and the enterprise database
-Server component to keep both the backend databases and the handheld computers synchronized with each other
-Device and user administration component

I realize I have over simplified, but at the very highest level, these are the components of a mobilized business solution. So in order to "mobilize" your existing in-house database applications, you either need some very smart developers and a lot of development time, or you find a software company like MobileDataforce that has already developed these tools.

Reusable Mobile Frameworks

It is easy for an IT developer, working hard in their cubicle, to feel that the technology requirements of their business are unique and special, although in truth many companies may share similar business processes and requirements, even companies in different industries. Let me provide you with an example of similarities:

-a mobile software solution needs screens designed for use on handheld computers
-a mobile software solution needs graphical buttons, labels, fields and functions on their screen
-a mobile software solution needs to be able to validate the data inputted
-a mobile software solution needs a database on the handheld to store information
-a mobile software solution needs mobile middleware that enables synchronization between the mobile device database and the enterprise database.
-a mobile software solution needs to be able to add custom business rules
-a mobile software solution needs to be flexible enough to handle many different kinds of handheld computers and add-on accessories.

The features described above are needed by every developer of mobile applications. They are required, but are not cost effective to develop from scratch each time. My team of engineers have spent over 12 man years productizing the features and functions listed above so that you don't have to. Often I hear comments from customers that 80% of their project requirements are already completed, productized and proven in PointSync.

More on Convergence and Handheld Computers

In an earlier posting I discussed the converging technologies available on handheld computers. However, convergence is not only happening in the hardware arena. When you design a mobile software solution for use on a handheld computer, you have the opportunity of converging multiple databases and database applications into one mobile application on the handheld. Let me explain:

You may have a "work order" application that you want available on your field service team's handhelds. In this single mobile application you may want to include data from several different internal database applications.

-a work order management application
-an inventory application
-a shipping application
-time sheets
-CRM system
-GIS system
-Accounting application for invoicing
-product catalogs

This is "convergence" at the software level. Mobile solutions can be as simple, or as powerful as you want them to be.

Buy vs. Building Mobile Software Solutions

Regularly companies that need mobile software solutions for their field force are confronted by the choice of whether they should buy a mobile solution or build their own custom solution. This is a fair question, and I am sure there are times when your requirements may be so specialized that custom building is the only way, but this is rare. In most cases your needs are very similar to other companies, and the ability to reuse solution templates and proven frameworks is the better choice.

MobileDataforce invested over 12 man years into the development of PointSync. Our goal, which we have now achieved, was to provide a rapid application development solution for mobile environments. We invested in the grunt work so you would not have to. Most of our customers find that their solution is over 80% completed before they even start. They can configure a database connection, instead of coding it. They can configure their mobile application interface, rather than code it. They can configure synchronizations, rather than code it. They can use one of the 130 pre-built functions from our library, rather than code it. One of the biggest advantages is we have been debugging, documenting and improving PointSync through 3 versions. This is a time consuming and often tedious process, but it reaps rewards for our customers. I would not wish this process on anyone.

Using PointSync, you can focus on perfecting your mobile business processes rather than on perfecting your code. The value and ROI from your mobile application comes from the business efficiencies it brings to your field force. The faster you can deliver it, and the smoother the implementation, the happier your field force and management will be.

Although building it yourself may be necessary in rare cases, most often if you can configure a proven application to enable you to rapidly implement a mobile solution, you, your CFO and your field force will be much happier.