You were an excellent partner in every way. You delivered your commitments on time, you provided clear guidance on what you needed from me, why you needed it, and when my communication was not sufficient you asked for clarification.

919-341-5170

help@ideacode.com

 

Blazing a trail to better facilities management.

Blog

800 Scam Alert

The good folks over at the Better Business Bureau recently reached out to us, sadly, to inform us that our former 800 number was being used by a scammer.

If you're that scammer, shame on you!

Everyone else, be advised two things:

  1. ideacode's phone number is (919) 341-5170
  2. Whoever answers 800-813-1316 is scamming you.

Split PDF into pages, by bookmark

You've got a PDF with bookmarks. You want one PDF file per book mark. Here's a quick way to accomplish that.

GIS inside buildings

Recently I saw this comment on the CFTA mailing list:

None of the CAFM/IWMS vendors go inside the building with their GIS modules, nor do they provide the ability to do true GIS spatial analytics on your data. Typically they go down only as far as the building location level, represented by a point on the map

AERES takes GIS inside the building and lets you perform spatial analysis as well.  AERES got this ability over two years ago in what I think is a classic example of our philosophy of "listen to your customers, not your competition."  And so, here are examples of this functionality in action today:

MySQL CSV load-fu

Here's the setup.  I have a MySQL table of existing data and a CSV file holding new data that I want to import.  The file and database are not on the same server.  The file has not been cleaned up.  I expect this to be an ad-hoc, one off operation.

What I need is some way to put the data in the table and clean it up.  If this were to be done on a regular basis, I'd write some production code.  But since this is just some throw away code, I want to be as simple and direct as possible.  Fortunately, the MySQL LOAD DATA statement is industrial strength and can get me where I need to be.

Configuring Zend_Layout pluginClass

The Zend 1 approved way to switch the layout renderer is the pass the pluginClass parameter to Zend_Layout.  Internally, Zend instantiates the class and passes only the layout to it.  But what if you want your renderer to be configurable?  There's no built-in way to pass configuration options to the plugin class, so the class has to roll its own.

Syndicate content