Hello,

At some point, I believe after our last upgrade, our file output names began to include timestamps.

For example, fileoutput.xlsx now saves as fileoutput_20191002_082513.xlsx.

For the most part this is not a problem, and is even beneficial. I am working on a report for one customer, however, with an output to a csv for an upload. Changing the name manually works but ideally the timestamp could be removed for this one report. I have been unable to find any reference to this behavior in settings so far.

I appreciate any insight y'all can provide.

Thanks

Jeremy

This message has been edited. Last edited by: Jeremy S,

Can you show us your ON TABLE HOLD syntax?

I just tried ON TABLE PCHOLD AS FILEOUTPUT FORMAT XLSX

and Excel opened FILEOUTPUT.XLSX.

This is the code from the report I am working on for the csv upload:

ON TABLE PCHOLD AS NEWSLETTER_X FORMAT COM

I just ran it and it saved as NEWSLETTER_X_20191002_093522.csv .

This is how all of our csv and excel files end up looking. With most of our reports we don't specify a filename with the code and the filename ends up as the fex nme + the timestamp.

I feel this has to be related to a global setting somewhere as even old reports whose output used to not include the timestamp now include it.

'COM' and 'XLSX' appear to work differently in 8202 as well.

COM : Ignores AS NAME
XLSX: Accepts AS NAME

In the Admin Console, what's your redirect settings for Redirect and Save Report? Values could be Yes or No. I believe the combination of those two determine the way files are named.

Both csv and xlsx are Yes and Yes. I will do some testing with those in our development environment to see if changing them makes a difference.

No Luck. I tried different combinations for the csv format. Save Report needed to be Yes to allow it to save as a csv at all. I tried all the different redirection options ( Yes, No, Len ) and there was no affect on the file name.

Jeremy

Better open a case with techsupport on this one.

quote:

Better open a case with techsupport on this one.

And, PLEASE, post your results.

I opened a case and will update the thread with any information I receive.