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     [CLOSED] wf8 creating an URL for an existing PDF residinf in a MRE folder

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] wf8 creating an URL for an existing PDF residinf in a MRE folder
 Login/Join
 
Guru
posted
I want to drill to an existing PDF that was created outside of IB and placed within a MRE folder, for example, the Hidden Content folder.

Would it be something like? This obviously does work, but I think I am close.

http://servername:8080/WFC/Rep...port_Description.pdf

This message has been edited. Last edited by: Jay Potter,


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Expert
posted Hide Post
Jay, If that's where it resides, then it should work. Does it work if you use it directly?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Guru
posted Hide Post
When I run my fex that calls the include from the application folder without a full path, it works. When I run it from the "Content/MRE" it does not. The application IS in the path.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
<MLerner>
posted
Jay,

Based on your mentioning of the Hidden Content folder I assume you are on WebFOCUS 8. If so use the following code.

TYPE=DATA, COLUMN=N1, TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/bugs/mypdf.pdf, $

It is basically the same code as calling a report. If it was a HTML page you could even pass in variables.

Note: The UI does not support creation of this. I recommend you open a New Feature Request, but we are already on it.

Regards,
Matthew
 
Report This Post
Guru
posted Hide Post
Thanks for the information. I will check it out.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Guru
posted Hide Post
I was able to get to the pdf document that way. But when it tries to open it, it says it is damaged and can not be repaired.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
<MLerner>
posted
Jay,
According to my programming team we may have had a problem like this that has since been resolved. Can you open a case with support and provide them the PDF for us to try in house?

Thanks,
Matthew
 
Report This Post
Virtuoso
posted Hide Post
Am I missing something here? I was under the impression that, under release 8, IBI did away with storing MR objects in folders, and moved everything into a database.
 
Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005Report This Post
<MLerner>
posted
Jack,
It is in a database, but you still have a folder concept for organizing things. They are just not real folders.

Regards,
Matthew
 
Report This Post
Member
posted Hide Post
quote:
=IBFS:/WFC/Repository/bugs/mypdf.pdf

First...I'll advise that there is a known problem (project 145944) open for WF8 with viewing PDF files (not created by WebFOCUS FORMAT PDF) uploaded to the WF8 repository. Only the TOC content of the PDF file (if there is a TOC) is displaying.

Next...Answer to your ? on the coding...
This takes a bit of detective work using Fiddler (or other Web debugger tool that traces URL calls) to see the URL that is sent from BIP to View the PDF that is uploaded. Once you have the URL that submitted the request the next step is to reference the Creating Reports with WebFOCUS Lang manual doc topic 'How to Link to a URL'.
The coding of the URL drilldown in Stylesheet code does not use the exact URL you obtained in Fiddler.
1. No HTML encoding
2. Parameters are specified separate from the URL

Syntax reference...
TYPE=type, [subtype], URL=url[(parameters ...)], [TARGET=frame,] [ALT ='description',] $

FEX example that you have to be signed on to WF8 and be authorized to run the FEX and view the PDF file referenced in the drilldown. The
PDF file used in example is the 8004 SNF Highlights doc.
TABLE FILE CAR
BY CAR.ORIGIN.COUNTRY
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=DATA, COLUMN=N1, TARGET='_blank', URL=/ibi_apps8004/views.bip? (BIP_REQUEST_TYPE='BIP_RUN' BIP_folder='IBFS:/WFC/Repository/Reports' BIP_item='8004snfhilit.pdf') , $
ENDSTYLE
END

As for -HTMLFORM... the HTML report could just be sent to HOLD HTMTABLE file and displayed. Again...you have to be signed on to WF8 and be authorized to run the FEX and view the PDF file referenced in the drilldown.
TABLE FILE CAR
BY CAR.ORIGIN.COUNTRY
ON TABLE HOLD AS DRILLPDF FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=DATA, COLUMN=N1, TARGET='_blank', URL=/ibi_apps8004/views.bip? (BIP_REQUEST_TYPE='BIP_RUN' BIP_folder='IBFS:/WFC/Repository/Reports' BIP_item='8004snfhilit.pdf' ) , $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN

!IBI.FIL.DRILLPDF;

-HTMLFORM END


Susan Trommer
Information Builders
 
Posts: 28 | Registered: May 22, 2003Report This Post
Guru
posted Hide Post
Thank you for your reply. I solved my problem by storing the external PDFs on a shared folder on my network. In your example you were showing a drilldown PDF. The PDFs that I was trying to use were not created by IB. They were created externaly for documentation and called from within the IB portal. I was hoping to save them within the IB environment. Storing them in a shared folder has satisfied my requirement.

Thank You again.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Member
posted Hide Post
Glad your all set.
I've been advised the URL to use should be a call to WFServlet. So here is revised examples and I also included the FOCEXEC= drilldown coding also on 2nd column in report.

TABLE FILE CAR
SUM RCOST
BY COUNTRY
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=DATA, COLUMN=N1, TARGET='_blank', URL=/ibi_apps/WFServlet? (IBFS1_action='runItem' IBFS_path='IBFS:/WFC/Repository/Reports/8004snfhilit.pdf'), $
TYPE=DATA, COLUMN=N2, FOCEXEC=IBFS:/WFC/Repository/Reports/8004snfhilit.pdf, $
ENDSTYLE
END

-HTMLFORM example with same change:
TABLE FILE CAR
SUM RCOST
BY COUNTRY
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=DATA, COLUMN=N1, TARGET='_blank', URL=/ibi_apps/WFServlet? (IBFS1_action='runItem' IBFS_path='IBFS:/WFC/Repository/Reports/8004snfhilit.pdf'), $
TYPE=DATA, COLUMN=N2, FOCEXEC=IBFS:/WFC/Repository/Reports/8004snfhilit.pdf, $
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN

!IBI.FIL.DRILLPDF;

-HTMLFORM END


Susan Trommer
Information Builders
 
Posts: 28 | Registered: May 22, 2003Report 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     [CLOSED] wf8 creating an URL for an existing PDF residinf in a MRE folder

Copyright © 1996-2020 Information Builders