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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Output files protected by password? Excel/PDF/???

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Output files protected by password? Excel/PDF/???
 Login/Join
 
<NorthNone>
posted
Is there a way when a fex creates output to also password protect that output?
We have network security but would also like to add file level security by having some of our outputs password protected at the time they are created by a WebFOCUS fex.
Help gratefully received!
NorthNone
 
Report This Post
<JG>
posted
There are two different problems relating to adding passwords to Excel and PDF documents,
First for Excel (EXL2K) WebFocus actually generates these documents as an extended html document not a binary xls document and Microsoft do not support the use of passwords in documents of this format.
Second for PDF documents, the generation of PDF documents with a password requires the use of an Adobe module which is not licensed by IBI.

a possible approach would be to deliver the file to the user as a password protected zip file.

This requires that you write the output to a permanent location and have a license for a command line zip utility such as WinZip + the command line add-in. Naturally all users would also need to have the an unzip product installed.

If you have WinZip on the server assuming you are in a windows server environment download the command line add-in from www.winzip.com. (there are also several freeware command line zip utilities that can do the same sort of thing in windows and Unix environments).


The following example shows how it works.



USE
c:\ibi\apps\ibisamp\car.foc AS car
END
-RUN
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY COUNTRY
BY MODEL
ON TABLE HOLD AS CARXHT FORMAT EXL2K
END
-RUN
!c:\PROGRA~1\WINZIP\wzzip -sPassword -yb c:\ibi\apps\baseapp\protectedzip.zip CARXHT.XHT
-RUN
-HTMLFORM BEGIN


EXCEL2K with MACRO



<br /> <body><br /> <p>This page uses frames, but your browser doesn't support them.</p><br /> </body><br />


-HTMLFORM END

This message has been edited. Last edited by: <Mabel>,
 
Report This Post
<NorthNone>
posted
Thanks! Great idea to use the .zip utility.
 
Report 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     Output files protected by password? Excel/PDF/???

Copyright © 1996-2020 Information Builders