Scheduled Reports - File Name Time Mappings

[Martin_Shaffer]

I have been testing the Xporter (v5.4.5, Server) Scheduled Reports feature and have successfully created a scheduled report.  But when I add any time mapping to the file name, as specified in the Xporter resource: "Exercise 2 - How to Manage Scheduled Reports", the report will not generate.  If I remove the time mapping, the file generates successfully and overwrites itself upon every scheduled run (set to run every minute for my tests). 

The Output Name field of my scheduled report is:  My File ${CurrentDate}.pdf

Again, if I remove the mapping to just: My File.pdf it works fine, but it overwrites itself on every run.

Thanks for the help!

[Mafalda de Azevedo Mendes]

Hi @Martin_Shaffer

That happens because the result of "CurrentDate" is something like "2018-05-04T16_44_07.118+01_00[Europe\London]" that contains characters not allowed on filenames.

Please try this filename and give us your feedback.

My File ${dateformat(“yyyy-MM-dd”):CurrentDate}.pdf

Best Regards, 

Xpand Add-Os Team

[Martin_Shaffer]

That was it! Thank you.

[Mafalda de Azevedo Mendes]

You're welcome!

[Santiago Estel]

Well, I'm using Xporter 6.9.10.2 and this does not work, any advice?

Time to Work in Progress - ${dateformat("yyyyMMdd"):CurrentDate}.xlsx