Focal Point
[Submitting NFR] SAVE AS "Name"

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

September 04, 2018, 02:10 PM
S.J. Kadish
[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
September 04, 2018, 03:02 PM
Doug
Interesting... If this turns into a NFR, then requested mixed case names.
September 04, 2018, 03:22 PM
S.J. Kadish
Thanks, Doug.
Let's see if anybody else tunes in.

Thanks,

Sandy
September 04, 2018, 04:00 PM
BabakNYC
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
September 04, 2018, 05:33 PM
Waz
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!

September 05, 2018, 08:00 AM
S.J. Kadish
I appreciate everyone's responses and will keep the thread open for a few more days.

Sandy
September 05, 2018, 12:01 PM
jgelona
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.
September 05, 2018, 12:24 PM
Tony A
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 
September 05, 2018, 01:01 PM
S.J. Kadish
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
September 05, 2018, 05:23 PM
Waz
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!

April 23, 2020, 02:37 PM
John_Edwards
Any news on this?