You could amend the cteate issue stored procedure to auto assign a resource (if none specified).

Hmm... OK, what if I tried this? (1) Add an additional column onto the Issue Type table, something like AutoUser, which would contain the ID/key of the user to autoassign. (2) In the Create Issue stored proc, I check to see if no resource was specified - if so, then I retrieve this AutoUser value (based upon the issue type) and then assign that user to the issue.

Of course, I would have to save this proc, and everytime that CounterSoft updated Gemini I would have to re-add the code, but I suppose I could do that.

BTW, this could be a very useful feature to add to Gemini in the future.

Anyway, do you think this would work?

Tom

Yes, that is exactly what we have said.

I know there is another customer who posted similar solution here.

Cool, and I did try it and it did work.... HOWEVER, the one thing that is lacking is that, once I auto-assign the user (resource) to a newly created issue in the proc, there seems to be no way of getting that user a 'created' email. I.E. They are assigned to the project, but are not getting a created/assigned email so they have no way of knowing that they have been assigned to the issue until they actually go into Gemini and pull up 'My Work'.

Is there any way, in the proc, to 'force' an email to be sent? Or some other means? Thanks in advance.

Tom

You can amend the mail plugin code.

OK, so where is this email plugin code? And how can I 'amend' it? Is it not .NET code and I have no access to that?

Tom (Chimp)

OK, one thing I do see is that I can write a 'plugin' so that I can do things whenever a Create Issue is done (I'm a VB.NET programmer). Therefore, in my plugin, how can I (1) Get the data from the issue just created, and (2) Based on that, can I 'send' an email at that time? If so, which interface/reference do I use? Thanks.

Tom (Chimp)

The code for the mail plugin is in the Code Samples directory of the Gemini zip you have downloaded.

You get the issue data passed into the event.

This would be a great feature to have for a future release. I too have asked about this. Here is a description of the solution that I came up with.

First, I created a new table in the Gemini database to hold the values for a Custom Field. Here are the field names I used: DetailID,DetailDescription, SortOrder, compid, AssignToUserID

The AssignToUserID field maps to Users.userid.

I created a VB.NET application that is scheduled to run every 15 minutes. This application returns all unassigned tasks and makes a call to the Gemini Web Services to assign the appropriate User.userid to the task with this methodl "GeminiWS.UpdateIssue".

By using the Web Service method, Gemini automatically takes care of sending out the e-mails when a task is assigned to the appropriate user.

This solution also allowed me to avoid modifying any existing Gemini tables and stored procedures so I do not need to worry about future upgrade issues.

The VB.NET code was actually very simple; less then 10 lines of code.