The other day I took a picture of a sign posted at a building near where I work. I was returning from lunch when I noticed the “undry paint” sign. Someone really needs to fire their marketing department.

I have been using AceProject project management system for years. First at LANDesk, and now at McCann Erickson. Though it is a great tool for managing projects and tasks, it’s user management system lacks a vital feature, cascade delete user. That is, delete the user along with all it’s assigned tasks, projects etc.

So after having make various request for this “feature” I have written my own sequel procedure to handle the re-assignment and deletion of user accounts. In a nutshell, this procedure will re-assign all relevant data to a new user account, then delete the actual user record from the database. This then allows you to actually take advantage of your licenses (in our case 50 for now.)

Hopefully this helps someone else that is hosting this application as it did me.

Ace Project User Migration Stored Procedure

I have finally done it! Well, somewhat done it anyway.

Ever since we moved into Daybreak we have had the misfortune of experiencing the foul stench that is (we believe) the Trans Jordan Cities Landfill. As we live directly down wind from the facility, its on a monthly if not weekly cycle that around 6 or 7:00pm the stench permeates the air.

It was the first or second month of having to cover my mouth and nose with my coat sleeve that I decided I would someday build a web application that would allow visitors to submit rankings of the intensity of the stench in the air at any hour of the day. It was not until recently (past few months) that I decided enough was enough. So I came up with a snazzy name, bought the domain, and built the application on a fairly new technology (for me that is), Windows Live Virtual Earth.

Granted this is the .01 release, but at least I finally have something done and tracking submissions. I would eventually like to customize by adding user profiles, custom reports, widgets, etc. But for now, what is there will suffice my ego.

Enjoy!

Scentometer.net

* DNS was just recently setup, so you may or may not be able to access the site