XPORTER custom template - dateformat issue

[Filip Zizka]

Hello,

probably i have a trivial question, but I would really appreciate your help.
For one of my excel field I used:
#{for comments}
#{if (%{'${Comments[n].AuthorFullName}'.equals('AuthorFullName')})}
${dateformat("dd-MM-yyyy"):Comments[n].Created}
#{end}
#{end}

,but this script doesn't work. I used same condition also for .Body and that works.

For this one I would like to export date when comment was created from specific person.

Note:
if I change dateformat to only MM-dd or dd-MM, than it works. Also found similar issue that if I want to export english-UK format than the whole JIRA language has to be setup in english-UK, but I already have my JIRA in english-UK and am also not abel to export US dateformat as well.

There is comment body script which is working fine.
#{for comments}
#{if (%{'${Comments[n].AuthorFullName}'.equals('AuthorFullName')})}
${Comments[n].Body}
#{end}
#{end}

Thank you in advance.
Filip

[Levente Szabo _Midori_]

Hi @Filip Zizka 

I'm sure the team behind the app would be the best source for a reply. While you wait for a response, let me mention that Better Excel Exporter comes with a default template for handling and exporting comments that doesn't require any script modification or template customization.

It automatically exports the comment author, comment date, and comment body in Excel. You can filter it for a specific user and (in case of Jira Service Management) even decide if you want to leave internal comments out (greyed in the below sample export).

Here is an article + video about how simple it is and see an example export below.

(Please note that I'm part of the team developing Better Excel Exporter.)

[Gabriella Molnar-Toth]

Hi @Levente Szabo _Midori_ 

I just started my free trial and would be curious, if I could get the screenshots exported and not only the link to them? 

This is how it looks like now.

BR,

Gabi

[Gabriella Molnar-Toth]

[Levente Szabo _Midori_]

Hi @Gabriella Molnar-Toth ,

Thanks for giving it a try!

Excel is not the best tool for handling actual images, so image export to Excel is not currently supported.

Is Excel a hard requirement for you?
If you would consider a PDF export as well, Better PDF Exporter is more often used for exporting and handling image files.

Please reach out to our support team if you have any further questions. We are happy to help.

[Gabriella Molnar-Toth]

Thanks for the Tip, I'll try the PDF Export.

Have a great day!

Gabi