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     [WORK-AROUND]PDF File Size

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[WORK-AROUND]PDF File Size
 Login/Join
 
Anatess
Guru
posted
Hi all,

I am creating a PDF file with images from a blob oracle field.

I have FILECOMPRESS = ON and the resulting pdf file is over 300MB with 22 images. This file size is too much!

The interesting thing is, when we open the file then do a Save As... the resulting file is only 7MB!

So, how do I create that 7MB file instead of the 300MB?

Regards,
Anatess
7.7.03, Win7, IE8

This message has been edited. Last edited by: Anatess,


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Waz
Expert
posted Hide Post
My guess is that its the images, and they are not being compressed.

I think only the report part of the document gets compressed with FILECOMPRESS = ON.

Have you checked to see how much space the images take ?


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Anatess
Guru
posted Hide Post
Yes, the images are compressed in the DB, Webfocus uncompresses it and puts it in the PDF, but doesn't compress it again when it holds it.

So, I was wondering what you guys do to save PDFs with images in its compressed form like Adobe does.


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Waz
Expert
posted Hide Post
I didn;t think that WebFOCUS uncompressed images, when putting them in a PDF.

What format are the compressed images ?


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Anatess
Guru
posted Hide Post
Oracle has the images stored compressed to 50%. They're mostly jpegs.

There's a FP entry for this problem here http://forums.informationbuild...1057331/m/4847082176 so I know some people have this same issue. There is also a case opened with IBI from last August that has no resolution: https://techsupport.informatio...oblems/92382507.html

So, the bloated PDF due to jpg images is a problem... I just wanted to know if any of you have a work-around...

This message has been edited. Last edited by: Anatess,


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Waz
Expert
posted Hide Post
The only thing I can think of is to get yourself a dos program that will compress an image, then attach that to the PDF.

I assume the images are JPG's ?


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Anatess
Guru
posted Hide Post
Hi Waz,

Yes, they're all JPGs...

The thing is, the images are stored in Oracle already compressed. So, I don't think a DOS program will help here.

Well... I guess a PDF Compressor after the file is already created can be used. But, we don't have such a software in house that I know of. Grrr.

Regards,
Anatess.


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Waz
Expert
posted Hide Post
Now I am at a loss,

You say that the images are compressed in Oracle, but are not when you extract them ?


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Anatess
Guru
posted Hide Post
That's exactly right.

It is compressed in Oracle and Webfocus uncompresses it to put in the PDF and holds it uncompressed.

You can try it in your installation and see if it occurs there too. I'm on 7.7.03.

I'm not sure if you can see our Cases. I opened this case last weekend: https://techsupport.informatio...ry.jsp?case=11713007 and IBI is consulting with Product Management to address the issue on, possibly, an NFR to compress images. Unfortunately, I can't wait too long for a solution from IBI without providing at least a workaround.

I'm kinda scratching my head, though, wondering why there's not much buzz about this issue on Focal Point. It's making me second-guess myself...


Regards,
Anatess


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Waz
Expert
posted Hide Post
I am intrigued now.

I will give it a go, when I have a chance.


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Anatess
Guru
posted Hide Post
I went ahead and swiped some java code to compress images in a PDF file using java's iText Module.

So, the PDF hold file is created and then we call the java class to compress the held file. It's not pretty but it serves our purposes for the meantime.


WF 8.1.05 Windows
 
Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006Report This Post
Waz
Expert
posted Hide Post
The nice thing is that the capability is there to post process the PDF documents.

We do similar things here.


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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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     [WORK-AROUND]PDF File Size

Copyright © 1996-2020 Information Builders