[Submitting NFR] SAVE AS "Name"

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: 238 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003

Doug

Expert

posted

Hide Post

Interesting... If this turns into a NFR, then requested mixed case names.

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Show Post

S.J. Kadish

Guru

posted

Hide Post

Thanks, Doug.
Let's see if anybody else tunes in.

Thanks,

Sandy

Posts: 238 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003

Ignored post by S.J. Kadish posted

Show Post

BabakNYC

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: 1853 | Location: New York City | Registered: December 30, 2015

Ignored post by BabakNYC posted

Show Post

Waz

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.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Show Post

S.J. Kadish

Guru

posted

Hide Post

I appreciate everyone's responses and will keep the thread open for a few more days.

Sandy

Posts: 238 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003

Ignored post by S.J. Kadish posted

Show Post

jgelona

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: 975 | Location: Oklahoma City | Registered: October 27, 2006

Ignored post by jgelona posted

Show Post

Tony A

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: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Show Post

S.J. Kadish

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: 238 | Location: Atlanta, GA/Rehovot, Israel | Registered: May 06, 2003

Ignored post by S.J. Kadish posted

Show Post

Waz

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.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!