Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2019Report 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: 1853 | Location: New York City | Registered: December 30, 2015Report 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, 2019Report 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: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report 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: 1853 | Location: New York City | Registered: December 30, 2015Report 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, 2019Report 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, 2019Report 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: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Expert
posted Hide Post
quote:
Better open a case with techsupport on this one.

And, PLEASE, post your results.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report 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, 2019Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders