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.

New Icon for ZP SQL

Among the recent changes to ZP SQL is a change in the program icon. Previously ZP SQL shared the same program icon used by ZP 32: the venerable house and car. This caused some confusion for customers converting from one to the other. So now ZP SQL has its own icon. Yes, another house. But this one has a red roof.