CODEWITHSUNDEEP
emailredmineredmine-pluginsredmine-api
Undefined Variable
Undefined Variable

Reputation: 4267

redmine: sending alert if user does not enter hours

So we have this distributed team who are working on a project and whose hours/progress is being monitored using redmine. All the guys are really talented and hardworking but pretty bad when it comes to updating their daily tasks/progress using redmine. This makes it very difficult for our project managers to understand and steer the progress as well as the upper management to get a quick overview of where we stand with various development initiatives.

Things have become so bad that I have been tasked to setup an email alert such that every night say 12:00 midnight, an email goes out to everyone on an email list with the date and names of users who have not updated their hours for that day. The management hopes that this exercise will instil in them the discipline to update their tickets on a daily basis.

My question is: Is this possible in redmine? Any API, or adhoc way of send out emails based on a custom Query? I have not worked with redmine before and have no idea how to go about this.

If there are anyone with prior experience I would be very grateful to get some directions!

Upvotes: 2

Views: 745

Answers (1)

joecullin
joecullin

Reputation: 706

I send some daily reminders to our redmine users, to help ensure that issues don't slip through the cracks in our workflow. I skip the API and just write perl scripts that connect directly to the database, scheduled via cron. The database is well designed and easy to understand: my SQL skills are very basic, and I've always been able to pretty easily hack out a query that gets what I need.

Some thoughts:

The end of "today" might be a relative concept if your team is worldwide. You could run your script hourly and base the reminders on users' time zones.

You might want to handle holidays and vacations, so that your users don't get nagged on their days off.

We use custom roles in redmine to control some of the emails. (We have a "new issue watcher" who gets triage mails in each project.) You could do the same thing to let certain users opt in or out of the time-tracking nag mails.

If you're interested, here's a link to one of my reminder scripts: http://joecullin.com/redmine_scripts/redmine_reminders

Upvotes: 2

Related Questions