Focal Point
[CASE OPENED] Timestamp on File Output Name

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7467057196

October 02, 2019, 09:34 AM
Jeremy S
[CASE OPENED] Timestamp on File Output Name
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,


WebFOCUS 8201m,
Windows,
Excel, HTML, CSV
October 02, 2019, 09:59 AM
BabakNYC
Can you show us your ON TABLE HOLD syntax?

I just tried ON TABLE PCHOLD AS FILEOUTPUT FORMAT XLSX

and Excel opened FILEOUTPUT.XLSX.


WebFOCUS 8206, Unix, Windows
October 02, 2019, 10:42 AM
Jeremy S
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.


WebFOCUS 8201m,
Windows,
Excel, HTML, CSV
October 02, 2019, 11:07 AM
Doug
'COM' and 'XLSX' appear to work differently in 8202 as well.

COM : Ignores AS NAME
XLSX: Accepts AS NAME
October 02, 2019, 11:09 AM
BabakNYC
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.


WebFOCUS 8206, Unix, Windows
October 02, 2019, 11:35 AM
Jeremy S
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.


WebFOCUS 8201m,
Windows,
Excel, HTML, CSV
October 03, 2019, 11:23 AM
Jeremy S
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.


WebFOCUS 8201m,
Windows,
Excel, HTML, CSV
October 03, 2019, 03:45 PM
FP Mod Chuck
Jeremy

Better open a case with techsupport on this one.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 06, 2019, 02:36 PM
Doug
quote:
Better open a case with techsupport on this one.

And, PLEASE, post your results.
October 07, 2019, 05:12 PM
Jeremy S
I opened a case and will update the thread with any information I receive.


WebFOCUS 8201m,
Windows,
Excel, HTML, CSV