Project Open 3.5.x

Project Open Custom E-Mail Notifications – Part 5

In Parts 1-4, I presented the concepts that I could exploit to build a Project Open e-mail notification system. In Part 5, I’ll present the actual application, which I’ve affectionately called PONotificationsBuddy. You can download version 1.0.0 here. Or you can visit the SourceForge project page here. I used Netbeans 7.0 to build the application, and I […]

Project Open 3.5.x

Project Open Custom E-Mail Notifications – Part 4

Now that we have the queries to extract the workflow items and the table to track what e-mails we’ve already sent, it’s time to think about the application to actually generate the e-mails. The application should have the following characteristics: Portability: The application should run wherever Project Open runs. That means at a minimum it […]

Project Open 3.5.x

Project Open Custom E-Mail Notifications – Part 3

In parts 1 and 2, I presented the queries to pull individual workflow steps and closed items out of Project Open. The results of those queries represented the raw data we’d need to send e-mails. Trouble is, every time we’d run the queries, we’d run the risk of sending and resending and resending e-mails. That […]

Project Open 3.5.x

Project Open Custom E-Mail Notifications – Part 2

In the first part of this series, I talked about building a query that will show all of the workflow tasks that are in-process. That is to say, I demonstrated a query that shows every step that represents a non-closed step in a workflow. That query, with a few modifications, will let us send an e-mail […]

Project Open 3.5.x

Project Open Custom E-Mail Notifications – Part 1

Project Open has a powerful, intricate, full-featured e-mail notification system, complete with opt-out functionality. I hate to admit it, but I could not understand how to make it work. True, I figured out how to tweak the e-mails Project Open sends when you open a new help desk ticket — a technique, by the way, which also […]