Transfer data from the phone to the database and map release locations on the phone.

Start by recording some simulated data on the phone:

1) On the phone open "My Files" and delete any files from the DCIM/Camera, gps and osmtracker folders (in the role of the "supervisor").

2) Open OSMTracker, delete any existing tracks and tap "New track"

3) If GPS is not currently enabled you will be transferred to a screen to enable it and when the receiver has located sufficient satellites the buttons on the OSMTracker display will change from grey to white (hand the phone to the dog catchers).

4) Tap any of the five lower buttons to simulate seeing dogs of those types on transit to the capture/collection area. The app will display a short message after each button press. If a button is pressed a number of times that number of records will be stored.

5) Tap the "Take picture" button to simulate having just captured/collected a dog and taking a photo of it in the vehicle. If the photo is unsatisfactory it can be discarded instead of being saved and another photo taken.

6) Tap the "Voice record" button to record audio for up to 30 seconds, e.g. "small tan female, lame on left foreleg".

7) Take a number of photos of imaginary dogs, with or without following audio recordings.

8) Tap Stop & save (and the dog catchers return the phone to the supervisor)

9) Tap/hold the title of the newly created track and select the "Export as GPX" option

Next connect the phone to the PC and open the "ABCdatebase_SmartPhone.mdb" database:

1) Select "Go to Data Entry" from the Main Switchboard

2) Select "import data from phone" (if an error message concerning comdlg32.ocx appears download , open the zip file, click on setup.exe and accept all defaults)

3) Check the location on the PC of the folder unzipped from

4) Click "browse to gpx file" and locate the gpx file in the phone's osmtracker folder

5) Double-click that file and click on the "read from gpx file" button. The number of transit sightings and capture records saved to the database will be displayed.

6) Close the "read values from phone" form on the red cross

7) Disconnect the phone from the PC.

Next select "edit data imported from phone to register". This will display a form listing the photos that were taken. Moving from row to row will display the photo and play the associated audio recording, if any. The other fields are for recording additional information about each dog in the row displaying the photo of that dog. The release map will show the capture location of each dog that's ready for release as an icon displaying the photo name so at some stage prior to release the dogs need to be fitted with a temporary collar or tag displaying that photo name. For example, if the dogs are kept in separate kennels the tag or collar could be attached to the kennel and fitted to the dog following the operation.

Most fields have drop-down lists which currently display a few example values. New values can be typed in or added via the "go to Additions" option on the Main Switchboard.  Single letters can be entered in the "description" field  to denote the colour of the dog, e.g. "bw" will expand to "black white" denoting a black dog with white markings.  Text typed following a space will be displayed as typed e.g. "bw paws" will expand to "black white paws". Click here tattoos for information about the "tattoo" and "existing tattoo" fields. When the initial information about each dog has been entered click the red "append identified records to register table" button to transfer all that information and the locations of dogs seen in transit to the database.

Next select "enter/edit register data". The information about all dogs currently held in the shelter will be listed, including the information about the new dogs imported from the phone.  Additional fields will be displayed relating to the condition and treatment of each dog. Using this information the "make operations schedule" option on the Main Switchboard will generate a report that can be printed out listing the dogs in the shelter for which the operation date is still blank. The "go to Summaries/Reports" option will display options for calculating monthly or annual summaries of the shelter's work and generating reports of those latest summaries, which can be printed and distributed. Click maps for a description of the maps that can be displayed.

Following the "operation_date" and "surgeon" fields the "fate" field lists the possible reasons for the dog leaving the shelter. Following successful surgery and treatment the fate is "release". To generate a map showing the capture location of each dog for which the value in the "fate" field is "release" select the "go to Maps" option from the Main Switchboard and then select "map where to release each dog". Then open your Internet browser, go to, select "Maps" > "My places" and log in to your Gmail account. Select "CREATE MAP" and then import the "replace.kml" file from your SmartPhone_files folder. The capture locations will appear on a street map as blue marker icons. Enter a map title and click "Done".

On the phone open the "Maps" application, select "More" > "My places" and under the "recent" page select the map created on the PC. The capture locations will now appear on the phone's display, again as blue marker icons, and tapping any of those icons will display the name of the photo of the dog captured there, which should match the value on the collar or tag attached to the dog.

Once the dogs have been released the release date is recorded via "enter/edit register data" as "date_out".  If a dog has to be euthanised ("fate": PTS)  or dies, escapes, is claimed etc. that date is also recorded in the "date_out" field.  Those records will not appear subsequently in the "enter/editeregister" form, which is for dogs currently in the shelter, but can be viewed via "all register data".