Viewing All Building Inspection Notes

Yesterday I spoke with a former ZP 32 customer who is now using ZP SQL. She expressed concern about keeping track of all the inspection notes for a Building Permit now that each Inspection Detail has its own Notes field. In ZP 32 the inspection notes were added to the permit notes fields so there was one screen you could go to to see all of the inspection notes entered. In ZP SQL each Inspection Detail has its own notes which are each viewed independently. There was no one screen you could go to to see all the accumulated inspections notes at once. I solved this problem by adding a View All Notes button to the Inspection Details Screen. Clicking on this icon button brings up another screen which shows you all the inspection notes entered for the current permit. This new feature is available for download using the automated update feature.

SQL Permit Mover Available

I just finished translating the Permit Mover tool in the Toolbox Module of ZP 32 for use in ZP SQL. To refresh, this tool allows you to easily move a permit that was entered under the wrong property record to a new property record. Without it, your only recourse is to delete the errant record and re-enter the permit under the correct property. With this tool you only have to supply the ID Code of the permit you wish to move and the Property ID of the new property you wish to move it to and it takes care of the rest. I'll have the updated Toolbox Module available for download soon.

Fire Hydrant Inventory

I'm working on a really interesting project right now that spun out of the mapping options in the Staff web interface for ZP SQL. I have a customer who wanted to know if we could add a database for fire hydrants and then map those as well. The prototype pages are in testing right now but the site allows you to enter any address and then shows a map of the closest fire hydrants to that property. The fire hydrant database contains Latitude and Longitude fields just like our property database does. In this case though, the customer has to supply the values for those fields because we can't geocode them the way we can an address. Fortunately, inexpensive GPS units make it fairly easy to construct your own database of positional coordinates. One of the bits of code I had to develop for this exercise is a way to determine distance between two geocoded points. This is used to find the nearest fire hydrants in this site but will be very useful for distance calculations in other web-based scenarios too.

Chat Room Option on Staff Web Site

This past week I added a chat room option to the staff web page interface for ZP SQL. You have to log in to see the link (use "zpdemo" twice to try it at the demo site). The "Chat Room" link is available from the main page. You can open the chat room in the current tab,  or open a new browser tab or window for it. The chat room itself is very basic, allowing you to exchange real-time messages with anyone else who logs into the same site. It's fun to use but I'm not sure yet how practical it will prove to be. This is one of those features I'm throwing out there and hoping customers can tell me how it can be used to their benefit. If you've got ideas for using this feature, let us hear them.

Customer Web Site Maintenance

I am slowly doing some maintenance to our Customer Support Web Site. One of the changes I am attempting to incorporate along the way is a tag that tells users which version of ZonePro a given item is relevant to. I'm adding (ZP32) to those items that only apply to ZonePro 32, or (ZP32 & ZPSQL) to items that apply to both ZonePro 32 and ZonePro SQL users. You get the idea. You can look at the Scripts page or Training Videos page to see it in action.

Web Interface Milestone

I just finished a revision of the "Staff" web interface for ZP SQL. The Staff pages now allow users to log in and edit any of the ZP SQL modules. The next step will be to include "Add" and "Delete" options via the web interface. The edit feature is still rudimentary, lacking most of the bells and whistles you get with the Window's interface to ZP SQL, but it works. You'll also find that all the pages have been revised to use a window-blind style control that let you selectively show or hide different categories of fields for any database. I think this feature makes the web page more fun to use but you can judge for yourself by trying our demo site at www.zpsql.com.

Contractor Request Web Site Update

I've made some changes to the Contractor Inspection Request web site. It now requires a log-in before you can view anything. You can see the demo of this site at www.zpsql.com by logging on with the ID "ct001003" and the password "zpdemo". I have also updated the tutorial that walks through using this service. That tutorial is listed under the Sql Documents section of the Tutorias page.