JEMH correct date parsing

Filip Gawlas_i23ka0

Hello everyone,

I need to parse few dates from email. I created new custom field (Date Time picker). Problem is, that I need date in format "dd/MMM/yy h:mm a" and in the email is date formated in "dd. mm. yyyy hh:mm".

Right now, I'm parsing email with Regexp Field Processor and have no idea if I can do it with this processor.

First choice was to change date format in JIRA, but it is not acceptable.
Next idea is, there will be secundar custom text field where will be stored date in text format. Then thanks to scriptrunner will be date loaded to Date Time picker in correct format. But it is just an idea and don't know if it'll be working.

Do have anybody tip or solution, how it could be done?

Thanks for any answers,
Filip

unknown

Hi Filip,

You will need to provide the custom field date value in the format expected by Jira, if your email is not in the same format, this might be difficult.

What version of JEMH are you running? This sounds like the kind of problem that the Script Field Processor would be ideal for, I think you would be able to parse the date via Javascript and then convert to the appropriate format that Jira expects.

The Script Field Processor is available for JEMH 2.5.1 and above, I think you are probably reaching the limits of the Regexp Field Processor if your data needs additional processing before being mapped to the issue fields.

If you need any assistance please raise a support ticket with us and we can discuss further: The Plugin People Support

Kind Regards,

Reece @ The Plugin People