Support Forum

[fbourget]

Hello,

We work on 4.0.7.
We use e-mail submission to create task from e-mail.
How can we fill custom field when a task is created by e-mail ?
How can we change assignee when a task is created by e-mail ? Without any customizing, assignee is filled with admin role.

Thanks and regards.

[admin]

You can do this using triggers: you should parse message description, extract field values (as you encode it) and change.

In other words, this is possible, but not too easy task.

[fbourget]

Hello,

Can you, please, give an example for 1 task custom-field.

Thanks and regards

[mvasenkov]

ChangeHandlerByEmail.java

Code: Select all

package scripts.before_add_message;

import com.trackstudio.exception.GranException;
import com.trackstudio.external.OperationTrigger;
import com.trackstudio.kernel.manager.KernelManager;
import com.trackstudio.secured.SecuredMessageTriggerBean;
import com.trackstudio.secured.SecuredTaskBean;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
* This class changes a handler in task by email submission
*/
public class ChangeHandlerByEmail implements OperationTrigger {

    public SecuredMessageTriggerBean execute(SecuredMessageTriggerBean message) throws GranException {
        String text  = message.getDescription();
        SecuredTaskBean task = message.getTask();
if (text != null && text.length() > 0) {
            String emailPattern = "To:\\s*\\\"?(\\S+\\s*\\S+[^\\\"])?\\\"?\\s+(<|&lt;)?(([-a-z0-9!#$%&'*+/=?^_`{|}~]+(\\.[-a-z0-9!#$%&'*+/=?^_`{|}~]+)*)@([a-z0-9.]+))(&gt;|>)?";
            // From: max.vasenkov@gmail.com
            // From: Maxim Vasenkov <max.vasenkov@gmail.com>
            // From: Maxim Vasenkov &lt;max.vasenkov@gmail.com&gt;
            // From: Winzard <i@winzard.ru>
            // From: Admin <admin@localhost>
            // From: "Максим Васенков" <vasenkov@any.place.com>
            // From: "Максим Васенков" &lt;vasenkov@any.place.com&gt;
            String usernamePattern = "To:\\s*(.+)";
            Pattern emailPat = Pattern.compile(emailPattern);
            Matcher emailMat = emailPat.matcher(text);
            Pattern usernamePat = Pattern.compile(usernamePattern);
            Matcher usernameMat = usernamePat.matcher(text);
            String foundUserId = null;
            if (emailMat.find()) {
                // found someone by email
                String userName = emailMat.group(1);
                String userEmail = emailMat.group(3);
                if (userName == null) userName = emailMat.group(4);
                foundUserId = KernelManager.getUser().findUserIdByEmailNameProject(userEmail, userName, task.getParentId());
            }
            if (foundUserId==null && usernameMat.find()){
                String userName = usernameMat.group(1);
                foundUserId = KernelManager.getUser().findUserIdByQuickGo(userName);
            }
        if (foundUserId!=null) message.setHandlerUserId(foundUserId);
        }

            return message;
        }
}


ChangeUDFByEmail.java

Code: Select all

package scripts.before_add_message;

import com.trackstudio.exception.GranException;
import com.trackstudio.external.OperationTrigger;
import com.trackstudio.secured.SecuredMessageTriggerBean;
import com.trackstudio.secured.SecuredTaskBean;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

/**
* This class changes a workflow custom field via email submission
*/
public class ChangeUDFByEmail implements OperationTrigger {

    public SecuredMessageTriggerBean execute(SecuredMessageTriggerBean message) throws GranException {
        String fieldName = "Somefield";
        String text = message.getDescription();
        SecuredTaskBean task = message.getTask();
        if (text != null && text.length() > 0) {
            String udfPattern = fieldName + ":\\s*(.+)";
            Pattern udfPat = Pattern.compile(udfPattern);
            Matcher udfMat = udfPat.matcher(text);
            if (udfMat.find()) {
                String value = udfMat.group(1);
                message.getUdfValues().put(fieldName, value);
            }
        }
        return message;

    }
}


[fbourget]

Hello,

Thanks a lot for these very useful examples.

Another request: I would like to fill "Priority" during mail submission process.
I write script below, but it doesn't work, "Priority" is always empty. I check with a trace, value of "priorityMat.group(1)" is OK.

String fieldName = "Priority";
String text = task.getDescription();
if (text != null && text.length() > 0) {
String priorityPattern = fieldName + ":\\s*(.+)";
Pattern priorityPat = Pattern.compile(priorityPattern);
Matcher priorityMat = priorityPat.matcher(text);

if (priorityMat.find()) {
String value = priorityMat.group(1);
task.setPriority(value);
}
}

Can you, please, help.

Thanks and regards

[Petr]

Hi. Can you show example email message, which you want to parse for filling custom field?