Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Timestamp on File Output Name
Go
New
Search
Notify
Tools
Reply
  
[CASE OPENED] Timestamp on File Output Name
 Login/Join
 
Member
posted
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
 
Posts: 5 | Registered: February 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1677 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 5 | Registered: February 22, 2019Reply With QuoteReport This Post
Expert
posted Hide Post
'COM' and 'XLSX' appear to work differently in 8202 as well.

COM : Ignores AS NAME
XLSX: Accepts AS NAME
 
Posts: 3020 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1677 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 5 | Registered: February 22, 2019Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 5 | Registered: February 22, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1603 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
Better open a case with techsupport on this one.

And, PLEASE, post your results.
 
Posts: 3020 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Member
posted Hide Post
I opened a case and will update the thread with any information I receive.


WebFOCUS 8201m,
Windows,
Excel, HTML, CSV
 
Posts: 5 | Registered: February 22, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CASE OPENED] Timestamp on File Output Name

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.