JEMH correct date parsing

[Filip Gawlas]

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

[Deleted user · Accepted solution]

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

[Filip Gawlas]

Hi Reece,

I knew about Script Field processor, but had no idea how to set it and was afraid of it. It took some time, but documentation for Script Field processor is pretty rich.
We developed new customer Servicedesk with this processor about month ago. It was not easy, but looks like everything work how it should. Love that plugin :)

Thank you for help and Best regards,
Filip

[Deleted user]

Good to hear Filip! If you need any further help feel free to reach out to our support team, we can probably point you in the correct direction in future to save you some time.

The Plugin People Support