Dynamic Data

Managing data is tough.  Every business operates differently and no matter which application you select to manage your assets and infrastructure, it’s likely that right out of the box the application will not be configured to suit your specific needs.

In this example, let’s say you want to track the General Contractor on a Work Order.  Easy enough, right?  Well, sort of.  The problem here is that your software application does not have a “General Contractor” field on the Work Order input form.  Now you’re thinking “…Rats.  Now what.  I spent all this money on this dang thing and I can’t even track the General Contractor on my Work Order – I swear they said we could do that when I sat through their demo…”

Don’t worry; you’re not out of luck just yet.  Chances are, you just need to spend some time configuring the application.

A common practice among software developers involves pre-filling the application database with “extra” fields and allowing users to use these fields as necessary (in this example, using one of the extra fields as the “General Contractor” field).

Another common practice involves pre-filling the database with common fields that the software publisher thinks you may need.  Hopefully they thought you would need a “General Contractor” field, in this example.

The key fault with these methods is that the application database will never truly line up with your needs.

Using the above methods to manage data, you’re likely to end up in one of these situations:

  1. You’ll have a bunch of unused (and unnecessary) “extra” fields in your database, or
  2. You’ll have to make do with pre-determined data fields that may or may not be what you’re looking for, or
  3. You simply won’t have enough fields to track the necessary data.

The solution?  We use what we refer to as “Dynamic Data”.  We call it dynamic because it’s not pre-determined, and there are no extra, unnecessary, or unused fields in the application database.

Here’s how it works.

Again, let’s say that you want to track the “General Contractor” on your work order.  In the Elements application settings, you use the dynamic data feature to simply create a new “General Contractor” field, determine the type of field that you prefer (drop down list, for example), and define where you want the newly created field to be tracked.  Voila.  You now have your “General Contractor” field, it’s in the right place, it works according to your needs, and you’re not stuck with a bunch of unnecessary fields in your database.

Now, let’s take that one step further.  Maybe you’ve got an entire data form that you’d like to track, a specific “Flow Test” for example. Well, how in the world are you supposed to track your flow tests if the application doesn’t have a “Flow Test” data input form? Unfortunately using pre-built “extra” database fields provided by the vendor won’t work in this situation.

The answer?  Dynamic data.  In this case we can create an unlimited number of custom fields (specific to our “Flow Test”) and we can assign those fields to a Flow Test data input form.  Voila (love that word), we’ve done it again.

The dynamic data engine in Elements also allows users to define dynamic page layouts, grid layouts, and much more.  Check back to learn more about the dynamic data in functionality in Elements.

The Calculator Watch

The other day I saw a guy wearing one of these and I thought “Really?  I thought they stopped making those things in the 80’s.”

Did you ever have a calculator watch?  I did.  Ask me how many times I used the calculator function – probably about 3 or 4 times – each of which was to show off the watch to my buddies.  Not once did I actually find myself wishing that I had a calculator on my wrist – much less a calculator that was hard to read and required microscopic finger tips to push the correct buttons.  However, there were plenty of times when I wished that the numbers displaying the time of day were larger.

Then it hit me – a lot of cities and utilities looking for GIS based asset and work management software are shopping for calculator watches.   No, they’re not shopping for real calculator watches – but when I look at the extensive lists of features and requirements some of these organizations are looking for I wonder if they realize that they’re trying to cram a calculator into a watch – and although it might seem like a great idea at first, when it comes right down to it the solution is just not practical.

What happens when you cram a calculator into a watch? Both devices are crippled.  So when you’re out looking for new GIS-based asset and work order management software try to find the right software for the right job – and remember that mixing too many things together may result in a calculator watch.

iPads, Lattes, and the ESRI 2010 Conference

Most of the people who read this blog are conference attendees who faithfully tweeted about conference happenings.  Since I did not attend the conference this year, I thought it would be great to share a few things that I learned about the conference while sitting at my desk miles away.

Here’s what the conference looked like on Twitter:

  1. According to the t-shirt, it’s pronounced ez-ree.
  2. Thanks to the iPad, booth traffic was through the roof.
  3. Also thanks to the iPad, nobody knew what the vendors actually had to offer (other than free iPads).
  4. Judging by the number of tweets about waiting in line for caffeine and lattes, the real winner at this conference may have been Starbucks, not ESRI.
  5. Apparently vendors can tell what kind of budget you have by looking at your exhibit badge, and they give you attention accordingly.
  6. Yes, it’s true.  Another product called ArcGIS.  Map Store, App Store, something like that.
  7. 19, 20, 21 = 19 Cities with populations of 20 Million plus in the 21st Century.
  8. There’s a reason the presenters don’t explain which extensions are required to do the cool stuff shown in the sessions.
  9. The bigger the vendor booth, the bigger the chance you’ll never afford whatever it is they’ve got.
  10. Don’t worry, Apple will be giving away free cases and bumpers.

Got something to add?  Leave it in the comments!

GIS in Asset & Infrastructure Management: New LinkedIn Group

We’ve started a new LinkedIn Group for utilities and governments to share resources and information related to GIS and technologies for:

  • Asset & Infrastructure Management
  • Facilities Management
  • Work Orders
  • Permits
  • Licenses
  • Inspections
  • Other GIS technologies for utilities and government

So if you’re interested, join the group and help us promote industry news, software and hardware solutions, blogs, resources, and the like.  Have fun!

You can join the new LinkedIn group, GIS in Asset & Infrastructure Management for Government and Utilities by clicking here.

GIS, Asset & Work Management Software, and the Nintendo Wii

Pop Quiz:  How many Wii consoles have been sold compared to PS3s and Xbox 360s? (And what does that have to do with GIS & asset management?)

Nintendo Wii

Simple, affordable, and easy to understand, the Nintendo Wii has outsold both the Xbox 360 and PS3.

Feature for feature both the Xbox 360 and PS3 blow the Wii out of the water.  Far better graphics, faster processors, more storage, you name it.  The Wii doesn’t compare.  However, the Wii has proven a couple of things:

  1. People like simple stuff.
  2. People like stuff they can afford.

To illustrate the point: Remember back in the fall of 2006 when the only way to get a Wii was to pay two times the retail price?  Remember how you had to buy it from some punk kid who was making a killing that year selling Wiis? …so you gladly let him rip you off while you gritted your teeth and paid like $500 for the stupid thing so your kid could have a one for Christmas?  Remember one year later at Christmas time when Wii’s were still hard to find?

Nintendo could not manufacture the things fast enough.

Well, they’ve done it again.  This time it’s a 3D video game console (handheld) that works without 3D glasses.

So what does this have to do with GIS and asset management software?  More than you might think.

You see, you’ve got Microsoft (Xbox 360), Sony (PS3), and Nintendo (Wii) all playing in the same space here.  Microsoft and Sony have been focusing their efforts on making super-powered-all-in-one entertainment hubs while Nintendo has been doing nothing of the sort.  Nintendo’s strategy?  Stick to what they do best – video games.

And their strategy seems to be working.

Nintendo has sold at least 70.9 million Wiis – compared to only 35.7 million PS3s and 40 million Xbox 360s (even though the 360 has been on the market for almost a full year longer than the Wii).

At novotX, we like Nintendo’s strategy.  For those of you who’ve seen our GIS-based asset and work management software you know it’s much like the Wii – simple, affordable, and easy to understand.

For those interested in reading more Nintendo’s 3D device, here’s the source article:

http://www.google.com/hostednews/ap/article/ALeqM5hOgruq-9nbyzLje-SdR7w1KKI2hQD9GCELNG1

For anyone interested in checking out Elements, our GIS-based asset and work management software, you can contact us here:

http://www.novotx.com/Contact.aspx