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     [Submitting NFR] SAVE AS "Name"
Go
New
Search
Notify
Tools
Reply
  
[Submitting NFR] SAVE AS "Name"
 Login/Join
 
Guru
posted
I have searched Focal Point for a solution to this item:

We have stylesheet settings such as the line below:

ON TABLE PCHOLD FORMAT XLSX OPEN AS 'Return_Reject_&DATEMtDYY'
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON

The naming works great except that the output name is all lower case:
return_reject_sep 4, 2018.xlsx

Is there some way to make the output name appear in mixed case, e.g.:

Return_Reject_Sep 4, 2018.xlsx

TIA to the FOCUS nation,
Sandy

This message has been edited. Last edited by: S.J. Kadish,


Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL
 
Posts: 239 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
Interesting... If this turns into a NFR, then requested mixed case names.
 
Posts: 3106 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Thanks, Doug.
Let's see if anybody else tunes in.

Thanks,

Sandy
 
Posts: 239 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I can do this with a HOLD and FILEDEF but it's really not the same as PCHOLD.

  
-SET &NAME='c:\Return_Reject_';
-SET &EXT='.XLSX';
FILEDEF HOLD DISK '&NAME&DATEMtDYY&EXT'
TABLE FILE CAR
PRINT CAR BY COUNTRY
ON TABLE HOLD FORMAT XLSX 
END


WebFOCUS 8206, Unix, Windows
 
Posts: 1852 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
I don't like your chances.

I would suggest asking TechSupport, as its WebFOCUS Client that returns the report to the browser.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6278 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
I appreciate everyone's responses and will keep the thread open for a few more days.

Sandy
 
Posts: 239 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003Reply With QuoteReport This Post
Master
posted Hide Post
Sandy, are you a Linux/UNIX shop? If so, do your settings have SET FILECASE = LOWER? If so, I believe that will set all file names to lower case no matter how you name them in a fex. Here's what the documentation says:

FILECASE - Both UNIX and WebFOCUS support uppercase, lowercase, and mixed-case file names and directories. Since lowercase is the default in UNIX environments, WebFOCUS offers a way to automatically convert file names and directories to lowercase.

The syntax is:
SET FILECASE = {ACTUAL|LOWER}

where:
ACTUAL
Retains file names in uppercase, lowercase, or mixed-case, exactly as they are entered. When this setting is used, WebFOCUS looks for file names exactly as they are entered (uppercase, lowercase, or mixed-case).
LOWER
Converts uppercase or mixed-case names to lowercase. When this setting is used, WebFOCUS looks for file names in lowercase.

What the command doesn't say is what the default is. I would guess it depends on your system.

You may want to try SET FILECASE = ACTUAL or ON TABLE SET FILECASE ACTUAL in your fex.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 958 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Docs state that default is lowercase.

Also, it cannot be set temporarily i.e. ON TABLE SET FILECASE is invalid.

On my windows install SET FILECASE = ACTUAL results in all uppercase filename.


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5686 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
SET FILECASE = ACTUAL returned "RETURN_REJECT_SEP 5, 2018" (all caps) just as Tony noted. I will run this past our team because upper case might be preferable to lower case.

I will keep the thread open because there have been such great responses.


Sandy Kadish
Dev: 8.2.04- PostgreSQL
Test: 8.2.04 - PostgreSQL
Prod: 8.2.04 - PostgreSQL
 
Posts: 239 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
SET FILECASE = ACTUAL


Wow, on my linux installation, this stopped the CAR file from working.

I guess it defines the case of the files you work with, including FOCUS files.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6278 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Master
posted Hide Post
Any news on this?



 
Posts: 979 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Submitting NFR] SAVE AS "Name"

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